Crystal Reports Prompting 1

[fe]

In Crystal Reports, how do I create a prompt where the user can either select "All" or pick a single item from a drop down list. "All" would include all items in that drop down list. I don't want to just add all the fields, there should be just the "All" option include in the drop down list.

Thank you for any help!

 

[AyJayEL]

Create your parameter and add a * to the top of the selection. In the select expert go into the formula editor and type in something like this:

if {?Your parameter} = "*" then
{Your field} = {Your field} else
{Your field} = {?Your parameter}

That should do it. Learn something new every day *:->*

 

[AyJayEL]

Replace "*" with "ALL" in your instance. Learn something new every day *:->*

 

[rhinok]

Don't forget, if your list includes both single values and "*" or "All" AND you allow multiple selections then you will need to account for this in your If-Then-Else. For example, the user could select "All" and "ABCD".