"All" Option for Parameter Fields 1

[cclear]

I am sure this question has been asked before, however I would love help with this. In earlier versions of CR, 8.5 and back, you were able to use the wildcard (**) as a Parameter option to bring back all of the records in a filtered report. We have upgraded to CR 10 and we are having a tough time with an (All) option. We have tried to add the * in the pick list field and place a description of what it is related to. However, when you use the Parameter it shows ex: *-All States* , this forces it to produce a blank report.

 

[Turkbear]

Hi,
Try using 0 (zero) or 'ALL' itself ( depending on Parameter type) then,. in the selection criteria use something like:

If {?parameter} = 'ALL' // ( or 0, depending)
Then
True
Else
If {?parameter?} <> 'ALL' 
Then
{table.field} = {?parameter}

Hope it helps..

 

[kskid]

Or if you still want the wild card, then

If {?parameter} = 'ALL' // ( or 0, depending)
Then
True
Else
If {?parameter?} <> 'ALL' 
Then
{table.field} like '*'+{?parameter}+'*'

 

[chelseatech]

It can actually be a lot simpler.

The clause you want is
{?parameter} = "ALL" or
{table.field} = {?parameter}

It is a simpler boolean expression and doesn't require all the if.. then else stuff.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Turkbear]

Hi,

Does that form get passed to the Database for processing?

 

[chelseatech]

Unfortunately if you have other criteria you need to bracket the above expression, so it won't be passed to the database.

Therefore all the records will be sent from the DB for CR to process. Sometimes you have to sacrifice a little efficiency for the flexibility you are asking for.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm