sql server reporting services: forcing column to appear -- sql server reporting services

forcing column to appear

brian
6/6/2007 8:08:01 AM

sql server reporting services:

I have a matrix that shows figures by year, broken down by months (1-12).
When the query runs and that particular month has not values, the column is
not displayed. I previously came across something regarding the use of a
function to force the columns to appear but can't seem to find it again.
Anyone have a suggestion for doing this? It would be similar to how the PIVOT

Re: forcing column to appear

EMartinez
6/6/2007 6:10:13 PM

[quoted text, click to view]

I traditionally look for the columns (value in the pivot column) that
I am expecting in the dataset and if they do not appear union an empty
record with the column name to the returned dataset (as part of the
stored procedure/query that is sourcing the report). Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant