Posted: February 22 2006 at 7:03am | IP Logged

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

Posted: April 05 2007 at 2:35pm | IP Logged

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}