SSRS matrix and displaying columns when there's missing data: I have tried the cross join example as this is not working out for my requirements as so much of the data is an aggregate within a year by..... so wondering if you could help. in the example below it sums the headcount by each year 🙁

Take Qualification enrolment headcounts by year. The selection parameter is by Qualification and the headcount data is to populate a 'template' report that is exported into excel (that's really the problem!!). The report holds much aggregated demographic data creating a template that is copied into an EXCEL worksheet providing links for a graphical summarised front page

Trouble is not all Qualifications are taught for all the years of the front page linking worksheet causing serious issues with maintaining accuracy with the template - so somehow I need all qualifications to have all years/columns 2011-2014 regardless if there is any data.

In the past I have forced this by creating case statements for all permutations and inserted those in each relevant year column but this report just has too many row variables to make it viable

Q1 Year 2011201220132014 SSRS givesQ1 Year 201220132014

Headcount100010001000Headcount100010001000

oror

Q2 Year 2011201220132014 Q2 Year 20112012

Headcount 10001000Headcount10001000

oror

Q3 Year 2011201220132014Q3 Year 201220132014

Headcount100010001000Headcount100010001000

Cheers Vonnie