How to create a menu option to select ALL values in a dynamic prompt list in crystal reports

[Former Member]

I created a crystal report created containing a dynamic prompt which filters using a cascading list of values. First it filters by "Estimator" then "Job." Ideally, I want to select the "Estimator" and have all the corresponding "Job"(s) automatically selected instead of having to manually select the double-arrows, if I want to use all the prompt values to run the report. How do I do this?

If this is not possible, is it possible to create a new menu option under the "Job" field that selects all the jobs?

[Former Member]

Base your dynamic prompt on a command, then in query add a UNION query which includes all in your List of prompts.

Then in Select expert modify filter to something like

AND

({?yourprompt} = 'All' or {yourfield} = {?yourprompt})

Ian