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

Hide value of Subtotal header?

Hello,
I have 3 row groupings and one column grouping. The visibility of the
2nd two row groupings is toggled by the first. For each value in the
second grouping there is always only 1 in the third (like a first name
and a last name). Therefore, I need two subtotals, one for the first
row grouping, and one for the next two. I put the one for the 2nd and
3rd on the 2nd row grouping. When the first row group is hiding the
next two, the subtotal number appear correctly, but the word "Total" is
displayed with the numbers.
Example
The dataset returns
City, FirstName, LastName, ColumnName, Value
There is a rowgroup for each of the first three and a columngroup on
ColumnName.
The group visibility for FirstName and LastName is toggled by the city.
Column
NY Bob Smith 10
Jane Doe 20
Total 30
Here the total is for the 2nd rowgroup
When I toggle the City, it looks like this
Column
NY Total 30
But I don't want "Total" to be there. Is this Possible?
Thanks,
AbeIs there a way to know if your group visibility is set to hide the
header for the total row? Can you use InScope()? I've tried that a
few different ways and I haven't been able to come up with a solution.
Thanks,
Abe