Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: bdybldr on 05 Dec 2005 02:23:19 PM

Title: [Solved] Conditionally hide columns based on user prompt
Post by: bdybldr on 05 Dec 2005 02:23:19 PM
Hi everyone,
I 'm developing a report that shows MTD, QTD, and YTD sales data, grouped by Division and product.Ã,  I've created a value prompt with static choices (MTD, QTD, YTD) and based on the users selection, I want to display only the data the user selected.Ã,  This all one query, so I need to conditionally hide irrelavant data based on the user selection.

Any suggestions?

Thanks.
Title: Re: Conditionally hide columns based on user prompt
Post by: JoeBass on 05 Dec 2005 03:03:15 PM
This sounds like a straight forward conditional report.  What is giving you trouble?
Title: [Solved] Re: Conditionally hide columns based on user prompt
Post by: bdybldr on 05 Dec 2005 04:03:11 PM
Ok, I figured it out.  I just used a conditional block and copied 3 different list reports to it.  Sorry.
Title: Re: [Solved] Conditionally hide columns based on user prompt
Post by: JoeBass on 05 Dec 2005 04:12:42 PM
If the fields you are hiding or displaying aren't related to query filters, you can use one query and show or hide columns with conditional formatting at the column level
Text only | Text with Images