Force user to choose new paramaters upon opening report in viewer

[jlopeman]

I have a report that is working fine from within Crystal Reports XI. The report consists of a main report that lists a location (hospital or clinic) and the provider (doctor or RN) and is linked to a sub report that shows the tasks associated with that provider at that location.

I have cascading parameters set up to choose the location first, and then the providers that are associated with that location.

The report works fine in CR. The issue, however, is that when using this report with CR Viewer, the report loads with the last saved data of the actual .RPT file. I need this report to open up, always asking for new parameters.

I've done this before using stored procedures, but the report and subreport pull directly from tables. The "set to null" check boxes do not show up. Is there a way that I can force the report to open up, requiring the user to enter parameters?

 

[IdoMillet]

Go to the File menu in Crystal and turn off the Saved Data with Report option.

Cheers,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jlopeman]

Thanks Ido....

I knew it was something simple. I was stuck on the "set to null" boxes.

 

[IdoMillet]

Note that you can also discard saved data in your viewer application. In my viewer application I have a setting that allows you to set what should happen when a report is opened with saved data: view the saved data, refresh, or ask the user.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com