COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: dbaliki918 on 18 Jul 2023 12:33:36 PM

Title: Set Excel Sheet Colour from Cognos?
Post by: dbaliki918 on 18 Jul 2023 12:33:36 PM
Hello,

I have a report with multiple pages, where each page will be its own Excel worksheet. This is a report I normally manually update, but I'm getting tired of doing that. Thing is, the worksheets in the report are colour coded. I can't really change that requirement. Is there a way in Cognos to set an Excel sheet colour? Like this:

(https://i.imgur.com/uwUv8AW.png)

I hope this question is clearly written. If there's any confusion, I'll clarify further.

Thank you!
Title: Re: Set Excel Sheet Colour from Cognos?
Post by: Cheeks100 on 21 Jul 2023 12:25:15 AM
Not sure about tabs but you would create a conditional style for each page.  Maybe create a value prompt and hide it for each page.