Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 01-16-2008, 10:54 AM   #1 (permalink)
Process Manager and Report Writer

Virginia Steger's Avatar

Join Date: Aug 2007
Location: Orlando, FL
Posts: 37
Rep Power: 0 Virginia Steger is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Parameter Field-Sort at Runtime

Drew,

At the Blackbaud Conference, you talked about being about to choose the parameter criteria at runtime. I have set up a report to run based on a parameter field, but when I run the report from RE, I do not get a prompt asking for the criteria. It runs based on the last time I ran the report out of RE.

Can you tell me how to get Crystal to ask me for the criteria at runtime (when I run the report out of RE)?

Thanks!
-Virginia
__________________
Virginia Steger
Database Coordinator
Wycliffe Foundation, Inc.
virginia_steger AT wycliffefoundation DOT org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-16-2008, 12:25 PM   #2 (permalink)
Crystal Reports Guru

DrewAllen's Avatar

Join Date: May 2006
Location: Philadelphia, PA
Posts: 1,155
Rep Power: 4 DrewAllen is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Information Edge (TIE)
- API/VBA

Parameter Field-Sort at Runtime

Virginia,

Is your report set to "Save Data with Report"? If so, it won't get
updated. The other possibility is that the parameter is not being used
somewhere in the report, so it's not prompting you for the parameter.

Drew

J. Drew Allen
Children's Hospital

>>> driver@blackbus.org 1/16/2008 11:54 AM >>>
Drew,

At the Blackbaud Conference, you talked about being about to choose the
parameter criteria at runtime. I have set up a report to run based on a
parameter field, but when I run the report from RE, I do not get a
prompt asking for the criteria. It runs based on the last time I ran the
report out of RE.

Can you tell me how to get Crystal to ask me for the criteria at
runtime (when I run the report out of RE)?

Thanks!
-Virginia
__________________
J. Drew Allen
Children's Hospital of Philadelphia

Crystal Reports and SQL Server Consultant

It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-16-2008, 12:41 PM   #3 (permalink)
Process Manager and Report Writer

Virginia Steger's Avatar

Join Date: Aug 2007
Location: Orlando, FL
Posts: 37
Rep Power: 0 Virginia Steger is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Drew,

The report is set to Save Data With Report, and I'm using the fields in the Select Expert. Here is my report criteria:

Code:
{CnAct_1AttrCat_1.CnAct_1AttrCat_1_Description} = {?Affiliate Name} and
{CnAct_1.CnAct_1_Action_Date} = {?Date Range} and
{CnAct_1.CnAct_1_Completed}
I also have the {?Affiliate Name} field in the title of the report, and the {?Date Range} is being used in a formula field so that it shows the date range in the title of the report. The formula is working right.

What am I missing?
-Virginia
__________________
Virginia Steger
Database Coordinator
Wycliffe Foundation, Inc.
virginia_steger AT wycliffefoundation DOT org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-16-2008, 12:42 PM   #4 (permalink)
Process Manager and Report Writer

Virginia Steger's Avatar

Join Date: Aug 2007
Location: Orlando, FL
Posts: 37
Rep Power: 0 Virginia Steger is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Oh, wait. I just re-read your answer. So I unchecked the Save Data with Report. It works now! Thank you!!!

-Virginia
__________________
Virginia Steger
Database Coordinator
Wycliffe Foundation, Inc.
virginia_steger AT wycliffefoundation DOT org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
parameter field


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Gas - Debt Consolidation - Credit Counseling - Arizona Pools
All times are GMT -6. The time now is 04:50 AM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64