Alright all, after three panicky posts in the span of an hour, the issue has been resolved. Moved to the dataset query in SSRS and added a 'OR Year(datecolumn) IS...

Actually, I believe I found the issue. The NULL containing records are also leaving the date column as NULL, and the report is using a year(datecolumn) and month(datecolumn) parameters to...

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...

Thank you guys. It's looking like I may have to go the insert route. I tried the LEFT JOIN and for some reason, the output did not produce records with...

After further review, I believe I understand your recommendation now. Are you suggesting that I input NULL or 0 values in the table, for all the location groups that currently...

Gazareth, thanks for the...

I am having a very similar issue, except in SSRS 2008. I have a matrix table, with "Accounts" as rows and "Locations" as columns. The data is a money sum...

Thank you all for the incredibly informative replies. Greatly appreciate the wealth of insight offered and have began the long process of incorporating all things mentioned into the document. Unfortunately,...

happycat59 (7/15/2012)

---

What have you used for the category group expression

You will need something like

=iif(Parameters!DateSortOrder=DateInterval.Year, Datepart(DateInterval.Year, Fields!somedate), iif (Parameters!DateSortOrder=DateInterval.Month, Datepart(DateInterval.Month, Fields!somedate) etc

Or (a shorter form of the above

=Datepart...

happycat59 (7/10/2012)

---

Sounds like your category group value will be the the result of a calculation.

e.g. IIF (Parameters!Criteria.Value="Daily", Fields!DailyField.Value, (IIF (Parameters!Criteria.Value="Weekly", Fields!WeeklyField.Value, Fields!MonthlyField.Value))

As an alternative, you could include similar logic...

Thanks for sharing. I tried the solution but, unfortunately, I still receive an error. The error I receive is different than the one mentioned in your post. I get:

The tablix...

Thank you BitBucket. Sorry for sounding novice, but I assume you mean use a...

gissah (7/2/2012)

---

I have the below code in my header I want my parameter to be displayed as MonthYear instead of 01/01/2012. I am using this parameters to run...

I also experience this issue, and have yet to find a way to load an .RDL as a custom report under Database Snapshots in SSMS. Receiving the error "The definition...

/