Parameter based on other parameter

[jjenright]

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.

 

[PatriciaObreja]

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.

 

[Madawc]

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.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

Consider a 3rd-party tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

My DataLink Viewer provides dynamic & cascading functionality even for earlier versions of Crystal.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com