Parameters 1

[dBjason]

CR 9.2

I have a parameter set up for a field called 'Classification'. It has four default values it can be which works great.

Problem is, my boss wants a fifth value for 'All' instead of having to click 'Add' four times in a row to get a full report.

How can I do this?

Thanks in advance,
Jason

 

[synapsevampire]

Add in another default value of All, and in the Report->Selection Formulas->Record alter it to:

(
if {?MyParm} <> "All" then
{table.field} = {?MyParm}
else
if {?MyParm} = "All" then
True
)

Note that the parentheticals and the intentional use of an ELSE IF instead of just an ELSE is there to help Crystal properly create SQL and pass it to the database for faster processing.

-k

 

[dBjason]

Thanks!!