I have a section of a SSRS2005 report that must display 6 identifiers in two rows of three i.e.
val1, val2, val3
val4, val5, val6
The dataset for these fields will have up to 6 rows.
I want the value from the identifier column of row 1 to go in val1, identifier column from row 2 to go in val2, etc up to val6
I'm having a brain dead day as I can't figure out how I can do this, can anyone help?
I've seen a link to http://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/ which talks about hoizontal tables and creating a matrix from the data. I may end up having to do it this way but it seems like a lot of work for what appears to be a relatively simple problem. (So simple I can't suss it out)
Thanks