oprional parameter

[crsdev]

Hi, how can you have an optional paramater,
for example "customer id" or "client id"
the report viewer can just enter one of those two to view the report.
Thanks.

 

[synapsevampire]

Parameters will always display, but you can set default values and take action based on them.

So create both parameters, and in the set default value area place something like "All" or 0, depending on it's data type.

Then in the Report->Select formula->record place:

(
if {?MyClientParm} <> "All" then
{table.client} = {?MyClientParm}
else
if {?MyClientParm} = "All" then
true
)
and
(
if {?MyCustParm} <> "All" then
{table.Customer} = {?MyCustParm}
else
if {?MyCustParm} = "All" then
true
)

For a lengthy discussion on the topic, check out:

faq767-3825

-k