In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the resulting report.
Notice the row with all Nulls does not show, but as long as the grouping field has a value it will show a row.
Advertisements
