record selection with paramaters (1 Viewer)

[dbrook007]

I have a report with a paramter field.

The user picks from a list. The list contains unique ID names that are used as part of the selection criteria.

However, the users also want an option for ALL.

{?Underwriter Account} = Paramater field
{Report_claim.underwriter_account} = data field

In the selection criteria, I have something like

if {?Underwriter Account} <> '' then
{Report_claim.underwriter_account} = {?Underwriter Account}

But I also want to add an option for ALL, but what would {Report_claim.underwriter_account} = ?

Thanks - Darren

 

[Kempes]

(if {?Underwriter Account} = "ALL" Then
True
Else
{Report_claim.underwriter_account} = {?Underwriter Account}

Don't forget to key the word ALL into your parameter selection data