CR 11 Wildcard -> Param?

[Besoup]

Is there a wildcard character I can use in a parameter to pull all the data instead of using an actually parameter?

I would like to give the user an option to use specific criteria or pull all the data on one report.

Thanks!

[Besoup]

Am I better off making 2 reports... 1 that takes a parameter and one that doesn't? I would think there is another way but that seems to be the only solution I can see.

[lheo15750]

hi,

there is a wildcard symbol used in CRXI

'?' stands for single character
'*' stands for any number of character

if you want to select all the data just use '*' on your record selection formula.

good day!

[Besoup]

I tried "is equal to" with * and ?, neither of them work

[lheo15750]

try this one:

if {?yourParameter} <> '' then
({yourField} = {?yourParameter})
else
({yourField} like '*')