Wednesday, March 21, 2012

Matrix Report Not Showing All Columns

I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this:

January March

Actual Goal Actual Goal

25 25 30 35

I have tried adding

iif(Sum(Fields!Total.Value, "DatasetName")> 0, Sum(Fields!Total.Value, "DatasetName"),"N/A")

But it still is not showing up.

Any ideas?

Thanks,

SHP

SHP,

You will need to make sure in your SQL statement you are returning data for that month. If there is no data then you will need to return "Zero" and or "Spaces"

Ham

|||

Thanks, Ham.

Yeah, I set up the month table in the stored procedure and then returned isnull(datafield,0) and that took care of the problem.

Thanks for your help. I found a similiar question that directed the person to the SQL statement and realized that was where I needed to make my changes.

Thanks again.

SHP

|||

Not a problem glad to help,

Also can you mark my reply as answer so I can get credit for the solution. Thanks.

Ham

|||Sure. No problem.sql

No comments:

Post a Comment