Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    AND

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

    Ian

    Add comment
    10|10000 characters needed characters exceeded