Skip to Content

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

Oct 27, 2017 at 07:27 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Oct 30, 2017 at 09:17 AM

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


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


10 |10000 characters needed characters left characters exceeded