sql server reporting services: Dynamic Columns Report -- sql server reporting services

Re: Dynamic Columns Report

MJT
1/26/2006 12:00:03 PM

I dont think the matrix report is as simple as they make it sound. I would
rather have someone post and tell me how to "simulate" a matrix but the
headings have to be dynamic since I wont know what input parms the user will
enter for the start and end dates - I have to do the past 12 months as well
just like the initial post.

Another issue with matrix is that the columns you use for groups dont have
headers which is strange (at least not when I did the wizard)

[quoted text, click to view]

RE: Dynamic Columns Report

RayMerckel
3/7/2006 7:06:31 AM

hey man, put this in your stored procedure...

DECLARE @abbrev TABLE(monthid INT, monthname VARCHAR(3))

INSERT INTO @abbrev
VALUES(1,'Jan')
INSERT INTO @abbrev
VALUES(2,'Feb')
INSERT INTO @abbrev
VALUES(3,'Mar')
INSERT INTO @abbrev
VALUES(4,'Apr')
INSERT INTO @abbrev
VALUES(5,'May')
INSERT INTO @abbrev
VALUES(6,'Jun')
INSERT INTO @abbrev
VALUES(7,'Jul')
INSERT INTO @abbrev
VALUES(8,'Aug')
INSERT INTO @abbrev
VALUES(9,'Sep')
INSERT INTO @abbrev
VALUES(10,'Oct')
INSERT INTO @abbrev
VALUES(11,'Nov')
INSERT INTO @abbrev
VALUES(12,'Dec')

and then join the table to your query like:

INNER JOIN @abbrev a
ON LEFT([yourmonthcolumnname],3) = a.monthname

then in the report for the column header properties - visibility code in
[expression]:

=IIF((Parameters!{yourmonthcolumnname].Value)=0,True,False)

peace out...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.