Display parameter values conditionally

[mynameant]

I am using CR10 and was wondering if it's possible to display parameter values conditionally. Let me explain

My parameter is fetching values from a table. This table has two fields. Description and Active.

Currently it's displaying description and would like to display only descriptions who has active=1. is it possible?

Thanks for any suggestions.

 

[synapsevampire]

First, CR10 parameters are NOT dynamic, so whatever you load will not be refreshed at runtime later.

To save parameters with only active = 1, create a command object and base the parameter loading on the command object.

select description from table where active = 1

-k

 

[MrBillSC]

To conditionally suppress description, right click on the description field and select "format".

Click the "Common" tab and click the X-2 button to the right of the "Suppress" box. In the conditional suppress formula editor enter:
{table.Active} <> 1

MrBill

 

[mynameant]

Thanks for your help synapsevampire.
I think when you say command object, you meant, from VB/.net or some application. But I am using Crystal reports as it is. I am not calling from any application. So, i cannot create a command object. Is my understanding correct?

MrBillSc, thanks for responding , but I do not want to suppress description conditionally on report, but in the list of parameter values [before user selection].

Thanks for your help.

 

[synapsevampire]

No, your understanding is not correct, it's built into Crystal. Then once you've read them in, you can eliminate the command object since parameters are not dynamic in CR 10.

Under your datasource you'll see Add Command.

-k