I've created a matrix report that displays the quantity of different products set to expire by month/year. The stored procedure returns records for a variety of products and each record contains an expiration date. If there are no products/records that contain an expiration date of lets say 6/2010 then 6/2010 will not appear as a column in the report. I need a way to force these month/year columns to appear in the report. Does anyone have a suggestion on how I can make that happen?

Hi, I think this can be handled better in the stored procedure logic. Along with the resultset, you have another column which will have CASE statement which gets the COUNT of the specific criteria, if the COUNT > 0 then return the month and year combination otherwise return space. This field can be directly used in the RDL layout which takes care of the display. Let me know if you have any further questions. Regards, Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Or when you are getting the result set from mssql, you can get query to join with a month-list tableIf you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com