parameter problem

[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} = ?

Also, how do I get the parameter list the user chooses from to automatically update its contents from the underlying database?

Thanks - Darren

[pravin3032]

just modify your selection condition to like this ....

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