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)  Matrix report with month Columns

Author  Topic  rdowdall Starting Member 1 Post Posted - 2010-11-11 : 14:50:23 I've create a Matrix report that displays products where the warranty is scheduled to expire. The column header shows month/year and the row shows product name. In the detail is sum of the product that expire on that particular month. My problem is that management would like to see the month/year displayed on the report even though there are no records (units that will expire) for that given month/year. Can anyone give me an idea on how to display the month/year even though there is no data? I am using a stored procedure to create the dataset. Thanks RickD