Unknown number of columns -- sql server reporting services

kloppie
11/29/2006 5:05:43 AM

Hi,

im working on a Report which needs to be able to display an unknown
number of columns; the only one that are always present is the first
one with a timestamp.

An example of the data: [timestamp], [value 1], [value 2], [value 5].

Is that possible with Reporting Services? The only solution that i have
found is unpivot the data in another form and then use a Matrix to
pivot the data back, but that decreases performance of my Report.

Hope somebody can clear this out for me, since im consider to code the
Report myself instead of using Reporting Services.

Regards, Martin

jewelfire1 NO[at]SPAM gmail.com
11/29/2006 5:47:34 PM

hi there

I did a similar one with a matrix - being a weekly timesheet (unknown
columns as some people don't have items each day.

6 fields in matrix
1st field =personname.value - 2nd field across = workdate.value
3rd field down=callsubject - 4th field across = sum(workdate.value)
5th field down=sum(workdate.value) 6th field across blank

see how you go with this

jewel

[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 about sql server reporting services

sql server reporting services : Unknown number of columns