Crosstab Hidden Measure Columns

[juliaf]

This one has me a bit stumped. Is there anyway in report studio to conditionally hide or show crosstab columns?? I found an article covering the technique for dimensional data sources, but for now I am stuck using a relational data source. Also saw another thread to conditionally hide/show one of the row items - I tried abstractly applying it to the columns, but no luck.

I have something like the following (product/client are rows, and then years are my columns, with up to 4 columns for measures nested underneath - these can be #, $ or % format):
                                          Year 1                         Year 2
                            Col1    Col2   Col3  Col4   Col1   Col2  Col3  Col4
Product   Client   

Basically what I am envisioning is the user can select any combination of col1-4 using a check box group. The only problem is designing a crosstab for every possible combination of selections is stupid. I know if this was a list there is a render variable for columns, but I can't seem to find such a thing for crosstabs. Any ideas/suggestions?

Thanks in advance for your help!

[wyconian]

Hi instead of using render variables try using style variables,  This can still be based on your prompt selection and you can change the box type to none depending on the prompt selection.

It's going to be a bit more clunky than using render variables on a list but may do the job.

Good luck

[blom0344]

A relational crosstab basically displays what the query generates. Filter the query in the right way and it will generate less rows/ columns.  It is not a matter of conditionally hiding columns but making sure no intersections exist so the column will not be generated.  This can be achieved by the right filters and filters can be build from parameter values associated with prompts..