happycat59 (8/19/2013)

---

A matrix report will only show the months that exist in the dataset used for the report. So, as you are finding, only 3 are currently appearing.

You will need to include all of the months you need on your report for at least one of the companies in the report. I guess one of the issues you will encounter is that at the start of the year, there are no sales for most of the months of the year. Your SQL code will need to include the extra months in the dataset - probably with nulls for the values. If all 12 months appears in the dataset your report will look OK. The "missing" months only need to exist for a single company for the report to show the headings for all 12 months. So, if you only have values for month 01 and you have 20 companies on your report, you dataset would currently have 20 records in it and there would only be one month heading. If you changed you dataset so the at least one of the companies had a record for all 12 months, you would get the result you are after. You don't need to include all 12 months for all companies (although this may make it easier to code)

...hope that makes sense.

Jeff Moden (8/19/2013)

---

The missing months don't need to appear for any of the companies if you use a calendar table or a smaller table with just the months of interest in it and do an outer join to that. I'm not sure how to do that in an SSRS matrix but it's a fairly simple thing to do with a query.