Suppressing Parameter...

[sam1one]

Hello:

We're wondering if one can suppress the parameter and hide the other parameter, based on a selection within another paramater.

Sorry if this does not make sense.

Thanks for helping/point me in the right direction!

 

[lbass]

Much more info required--please don't make us guess what you are after. I'm (already) guessing you really mean the fields you are setting equal to the parameters.

-LB

 

[sam1one]

Hello LB:

Yes, I have a date range parameter in the report that upon a selection, I want to suppress another parameter (frequency) in the report.

i.e. choosing a choice in the date range parameter will make the frequency parameter disappear and choosing a frequency in the frequency parameter will make the date range parameter disappear.

Is there a way to do this?

Thank you.

 

[lbass]

You mean you want to provide a choice of which parameters to apply? Try setting up a higher order string parameter {?Which Parameter} with the options: "Date Range" and "Frequency".

Then set up your record selection formula (report->selection formula->RECORD) like:

(
if {?Which Parameter} = "Date Range" then
{table.date} = {?daterange} else
if {?Which Parameter} = "Frequency" then
{table.frequency} = {?Frequency}
)

-LB