COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Hatcher12 on 18 Apr 2023 09:15:54 AM

Title: Report Page Style Based on Parameter
Post by: Hatcher12 on 18 Apr 2023 09:15:54 AM
Hello,

I have a crosstab report that has timecodes on the rows and hour type on the columns. There is a need for these to be reversed which is not a big issue, however I was wondering if there is a way I can set the report to run either version based on a parameter by the user. I've done some reading and a render variable seems like what I want. I just wanted to make sure I was on the right track or if you "cogGods" (cleaver I know) had a better solution. Thank you!
Title: Re: Report Page Style Based on Parameter
Post by: Hatcher12 on 18 Apr 2023 09:26:13 AM
Like I see conditional blocks as well, should I just make two blocks with lists and set a condition on those, set the condition for two seperate pages? I just feel like there's a lot of different ways I can take this.
Title: Re: Report Page Style Based on Parameter
Post by: MFGF on 18 Apr 2023 11:33:22 AM
Hi,

Here are a couple of links that might help - they discuss both approaches:

https://www.cognoise.com/index.php/topic,26240.msg83409.html#msg83409

https://www.cognoise.com/index.php/topic,25849.msg82187.html#msg82187

Cheers!

MF.
Title: Re: Report Page Style Based on Parameter
Post by: dougp on 18 Apr 2023 01:12:55 PM
Create two crosstabs to meet your needs, both based on the same query.
Add a variable.
Set the Render variable property for each crosstab.

https://pastebin.com/FdDjaGjt
Title: Re: Report Page Style Based on Parameter
Post by: Hatcher12 on 19 Apr 2023 11:18:02 AM
Quote from: dougp on 18 Apr 2023 01:12:55 PM
Create two crosstabs to meet your needs, both based on the same query.
Add a variable.
Set the Render variable property for each crosstab.

https://pastebin.com/FdDjaGjt

Perfecto, thank you!