parameter problem

Issues related to using our fonts in Crystal Reports

parameter problem

Postby dbrook007 on Wed Feb 22, 2006 7:03 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} = ?

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

Thanks - Darren
dbrook007
 

Re: parameter problem

Postby pravin3032 on Thu Apr 05, 2007 2:35 pm

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}
pravin3032
 


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 0 guests