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)  highlight row for missing data

Author  Topic  khan379 Starting Member 1 Post Posted - 2011-01-07 : 14:11:13 Hi, My quesiton is really tricky. i have a report with query for the table that displaysa results something like this. member yr_month count ORDSYS 200401 668 ORDSYS 200402 368 ORDSYS 200403 3668 ORDSYS 200406 368 ORDSYS 200407 3668 ORDSYS 200408 21427 ORDSYS 200410 3668 ORDSYS 200411 3668 ORDSYS 200412 1568 i am grouping by the counts for each month of the year. my requirement is to show an extra row for the missing months with zero count. like in the above, month # 5 and 9 are missing. after all my research i found that this can be done with partitoned outer join by changing the query. with the overly complex query i have i cannot take that path. what i am asking here is, is there a way i can catch this missing data in the SSRS some how. like highlighting the previous row if next row date is not consicutive ? or any other way ? my aim is to make the report viwer aware that data is missing for few months. thanks, Abdul