Wednesday, September 17, 2008

Filter results based on Nulls

In many of my Reporting Services reports I use a SINGLE stored procedure for all matrices that returns one table with data in various forms to include cumulative totals of certain fields. When I want to extract and use just this summary information alone, I need to usually extract that data from the result set. The totals records/rows (created by using a SQL ROLLUP or GROUPING SET function) report NULL for the columns its not totaling.
Here is how you would write the filter to get those rows:

No comments:

Post a Comment