I have a report set up to use a SQL command for the data selection. I've added my needed parameters into the parameter list through the Command menu and then added those parameters to the report. After modifying the report, I'm prompted for the parameter like normal, however when I go to preview the report or use it at run time, the program is not prompting for new parameters.

How do I have the program prompt the user for new parameters at run time i.e. different date ranges then testing ranges?

have created several Crystal Reports using Crystal reports Designer 2008. I am using Report Parameters in the selection criteria to limited the number of records returned to the report. One such report uses a SQL Command (i.e. the new thing in 2008 that's analogous to a virtual table / database view) and a single parameter imbedded in the SQL command. This parameter is date data type and it promots the user to enter a date at report runtime, which is passed down to the DBMS to limit records retruned by the SQL query to records where the date in my field (my field ACN_COMPLETED_DATE) is >= date entered by the user.


Edited by BrianBischof - 08 May 2012 at 8:49am