If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Making optional a non-parameterized filter

Started by Dampa, 25 Jun 2020 10:21:59 AM

Previous topic - Next topic

Dampa

Dear all,

I'm building a report with some non-parameterized prompts valid for more than 1 queries.
I'm linking the prompts in the queries with the filter as [ORDER] IN ?Parameter?
Parameter is a text box prompt with multiple values and multiple lines

However, I need to make this prompt as optional.
I have already selected this while building the prompt, but if I run the report and I do not select any Parameter, I cannot go ahead.
I'm assuming this is due to the "IN" filter.

Is there any solution for this?

Thanks,
D

bus_pass_man

The #Prompt#  syntax allows you to make the parameter optional.   The ?prompt? syntax does not.

Dampa

Dear all,

My fault, putting also the filter as optional it works.
Newbie's mistake.

Thanks a lot.

KR,
D