Selecting * for all values in Universe

[kutoose]

Crystal Reports XI

We are trying to change the datasource few simple reports to the universe. All the reports have parameters in which the user can select a single parameter or multiple parameters or * for all the parameters.

While making this report run of universe, I am stuck as far as implementing this. I created a parameter in Universe and at Crystal I used '*' as default value. Now when I select * the reports does not give any records.

Thanls

 

[dgillz]

Write a formula:

if {?YourParam}="*" then true else {YourField}={?YourParam}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lbass]

See Nitroedge's first post in thread149-996360. It might help.

-LB