How to skip a prompt that returns no data to feed the final report

[Hsiao]

Hi,

My problem is as stated in the subject line. I have a report picklist prompt that feeds a final report, but there are times when the picklist returns no data, but the prompt window still displays for users to click, which I want to avoid. Could anyone with similar experience share with me how to work around this? I appreciate your attention and help!

Regards,
Hsiao

 

[griffindm]

Hi Hsiao,

I assume from your previous postings, that this is a conditional filter that may or may not be involved in the final data selection. It sounds like you want to avoid having the end user see a null selection list when that list prompt is really not applicable. Perhaps you could add a row to the prompt box, such as ' N/A' to appear when the end user's other selections result in no rows in the report picklist result. This would be similar to what you did to include an ' All' option in your previous post.

Let me know what you think.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!