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!

Parameter based on other parameter

Status
Not open for further replies.

jjenright

Technical User
May 23, 2006
14
US
I am using Crystal 10. Is there a way to have one parameter that is dependant on another ? The user can select any of 6 local systems in one paramter. Based on the local system selected I would like to make available to the user another paramter (locations) that contains only the records related to this local system. A different list of locations is related to each local system.

Local System Locations
New York 1,2,3
New Jersey 4,5,6

Thank You.
 
What you need is called cascading parameters and it's a new feature that comes with Crystal XI.

Dynamic and cascading prompts
One of the stand-out features of Crystal Reports XI is the ability now have dynamic parameters, tied to a data source so that at run time the data source is used to create the list of available values for the parameters. Add to that cascading parameters, where the values of one parameter are used to filter the next, and you have the number one reason to upgrade to Crystal Reports XI.
 
In Crystal 10, one thing you do is write a formula field that compairs two parameters and produces an answer. If you write it as a 'boolian', without an If .. Then, it will come out as True or False and can be referenced using just the formula name.

Your case is a bit non-standard, you seem to want a selection of records. You could do the first selection in the main report and the bulk of the work in a subreport, which would make its own selection based on the value passed down.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top