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@gmail.com - 30 Nov 2006 01:47 GMT
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
> Hi,
>
[quoted text clipped - 12 lines]
>
> Regards, Martin