Matrix Report: Not to suppress Column/Row with no value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thalia Mei - 09 Jul 2008 13:10 GMT

Hi,

I am building a matrix report. I would like to show all groups return by a
stored procedure. Even the Column/Row contains no record. For example: I
want to show the columns Jan to Dec, let say Feb contains no record/data, i
still want this column to be display with value of 0.

Not sure whether this can be done.

Thanks

Reply to this Message

Alain Quesnel - 09 Jul 2008 14:07 GMT

The query that supplies your matrix with data must have rows for every
month, with a 0 for months that have no value. Just edit your query in
Management Studio until you get the desired result, and then use it in SSRS.

Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message