Thank you all for the responses. Unfortunately, I am still having this problem, even after implementing a join query that produces NULL values. The matrix table simply does not show columns where there is no "amount" value (the columns are "locations" and the rows are "accounts"). I tried inserting an ISNULL in my WHERE clause which produced the rows/records with the null amounts.

(ISNULL(dbo.table.date, '2012-01-01 00:00:00.000') = '2012-01-01 00:00:00.000')

All the records come up in Management Studio. When I run my report, the matrix does not show the location columns where there is a NULL amount value. Do the amount values need to be '0' for them to show? Unfortunately, I don't rights to modify the NULLS, so inputting 0's where amt IS NULL is not an option. I also tried putting a boolean in the report cell to display values (=IIF(IsNothing(Fields!amt.Value),FormatCurrency("0.00"),FormatCurrency(Sum(Fields!amt.Value)))) but this does not get the extra columns to show, only displays 0.00 for NULLS for existing columns. Anyone have any ideas? This is driving me beyond nuts...