Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  SSRS: Hiding a matrix column leaves whitespace?

Author  Topic  Cody Starting Member 24 Posts Posted - 2009-01-23 : 04:31:32 Hi, I'm still new, trying to do my first report and get it to look "just right". I have a Matrix with a couple of row groups. I set them so that you can expand each level as you go down to get more detail about how a total has been calculated. The expansion works fine - because I have the cell and group visibility both set to hidden and linked to the previous cell. However it leaves lots of whitespace! I think this is because, the groups are on the left, and above it you have a big empty white box until the column group on the far right. ------------------------- Column Group Row Grp 1, Grp 2, Grp 3 | Detail ----------------- Total -------- I hope my ASCII art does it justice. The thing is I can't work out a way around this, and it's annoying - because if you collapse all the groups and try to print the report as a summary, it's way too wide for the page because of all that extra unused whitespace. I thought maybe I could use a Table or List or something instead of a Matrix, but I couldn't work out how because I need it to have dynamic columns. ie: The data coming back from the query has a date, and in the column I group by (iif (date <= 90, 0, 1)) to get two columns, 90 days or less and over 90 days. Help. Why is it that couple SSRS books I have never give me examples of the real problems I'll face? Cody