I have table with following data when I build Matrix report using SSRS it displays Jan,Feb and July that is true. One of my users requested to show the months which does not have any data also. In Nutshell they want to show all months regardless of the data present for that particular account. How will do this in SSRS. ANy help is appreciated.
Accountid Period Yr Amount
1000 Jan 2013 $200
1000 Feb 2013 $400
1000 July 2013 $700
Output should like this
Accountid Jan Feb March April may June July Aug Sep Oct Nov Dec
1000 200 400 0 0 0 0 700 0 0 0 0 0