Report Page Style Based on Parameter

[Hatcher12]

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!

[Hatcher12]

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.

[MFGF]

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.

[dougp]

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

[Hatcher12]

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!