Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt for parameters on open

Status
Not open for further replies.

barbola

Technical User
Feb 27, 2003
1,132
CA
I'm very new to Crystal (8.5) I've played around with it and still prefer Access, but I want to learn and am having trouble with parameters.

I would like my report to prompt the user for the parameter values every time the report is opened and I can't find any help as to how this is done?

Thanks,
barb

Thanks!
Barb E.
 
Reference parameters in the Report->Edit Seledction Formula->Record and the report wil always prompt on open or when the users select refresh (lightning bolt icon).

An example would be:

{table.date} = {?MyDateParameter}

-k
 
Here is what I have set up so far.

{DOCDATE} >= {?dtStart} and
{DOCDATE} <={?dtEnd} and
{ITEMCLASS} = {?ItemClass} AND
{CUSTCLAS} = "INTERNAL"

but the report always opens with the data that I last saved it with. It does prompt when the user clicks the lightening bolt, but I don't want the user to even see the lightening bolt.

I unchecked the option to save data with report,but then the design view comes up instead of the report asking for criteria.





Thanks!
Barb E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top