Multipe Type-in-Prompts

[sk363644]

Hi
I have a report with many Type-in prompts. When I open the report, I have an option to enter values for all the prompts or I can leave some of prompts blank.The values that I entered will be used for filtering the report.
The report works fine when I enter all the values into the prompts.

But when I leave some prompts blank,its not letting me to run the report.

I did try to implement the technique that was discissed in the following thread 401-609813.But didn't work

Any help in this regard will be greatly appreciated.



Thanks
Sunil

 

[griffindm]

Sunil,

To make this work, the prompts either must contain a default of '%' and the filter statement must use a LIKE clause, or you must use a conditional filter statement. See faq401-2137 for how to use this technique.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[sk363644]

Thanks a lot Dave!

-Sunil