We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
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)?
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.
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.