Hiding columns until toggled

Hi all,

Sorry if this question is a bit basic but I'm fairly new to reporting Services, I've searched for the answer but cannot find a definative answer.

I have created a table report with three groups, Product Group, Product Type and Location. When the report is run there is obviously no data displayed in the report except for the first group, Product Group. What I would like to do is hide the columns without data until the first group is expanded and so on with all three groups.

Is this possible and if so how?

Humbly yours,

Chris

Take a look at these forum threads; I think they can help you out!

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=519430&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=544713&SiteID=1

|||

Thanks. The solutions described in the links you provided were not exactly what I had in mind, but they're close enough.

Cheers,

CPH