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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Parameter set up

Status
Not open for further replies.

IanMWheeler

Technical User
Jul 28, 2009
16
GB
Hi There

I am using a cut down version of crystal provide by syspro.
I wish to set up some parameter to act as a to from parameter, based on the data of my report.

In other words I want to select customer names from a drop down list to limit the return of report

How is this done?

Any help would be great

A person new to crystal with very little training a part from Access based

Regards
Ian
 
In your data explorer you should see parameters, right click and select new, follow the dialog it is fairly self explantory.

YOu can then use this in select expert

customernamefield = @?yourparam

Ian
 
Thanks I will give it a go - but it might be a losing battle I can not set up dynamic parameters in my verion


A person new to crystal with very little training a part from Access based

Regards
Ian
 
Dynamic Params were introduced in XI.

YOu can add a list of customer names, click add default values. In top half find your customer table (must be in report) and the select field you can then add all names.

However, it will not be updated automatically. YOu need to update lit manually from time to time, which will be a pain since its a customer list.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top