View Full Version : record selection with paramaters


dbrook007
02-22-2006, 02:17 AM
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
03-22-2006, 12:42 AM
(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