So I have spent way too much time on this problem. I am using SSRS 2005 and need to put a page break in between columns in a matrix. I want to show data by year. I have a year row and an origin row with a page break after the year row. Which works great, except that the columns for that year still show up but with blank values.
I have attached the report for clarification.
Basically I only want the corresponding 'WeekStart' columns to show up in the matching Year row.
I feel like this should be quite easy and I am just not getting it :(