Help with parameter

[abc567]

I want to add 'ALL' wildcard character in parameters so that when users select 'ALL' then all the records should be displayed.
Which formula should i write in select expert to do this..?

 

[chelseatech]

The formula you want is
({?Parameter} = "ALL" or {table.field}={?parameter})

Easier to do this in the formula editor rather than the select expert. It's a little bit complex for the select expert. Use the menu item Report/Edit Selection Formula/Record

Editor and Publisher of Crystal Clear

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

 

[abc567]

Damn !!
You are excellent buddy...!!

Thanks

 

[techie2]

If database filed has null or blank, those records are not showing up in the report output.

Do you know how to pull the null values with this statement:

({table.field}={?parameter} or {?Parameter} = "ALL")

I have null's / blanks in {table.field}.

Thanks,

techie2

 

[techie2]

Thanks guys, I figured it out.

I should have used "ALL" statement before to handle nulls. This is how the stament should look like.

({?Parameter} = "ALL" or {table.field}={?parameter})

Thanks.