Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  MULTI-COLUMN REPORTS

Author  Topic  lkeeba Starting Member 17 Posts Posted - 2007-05-27 : 04:10:02 How do I create a report with a select statement and the result set as follows : SELECT Code, Desc, Value FROM mytable ORDER BY Desc Code Desc Value ----------------------- B1110 Row1 2 B1120 Row2 4 B1130 Row3 5 B1140 Row4 3 C1110 Row1 1 C1120 Row2 2 C1130 Row3 9 C1140 Row4 1 D1110 Row1 4 D1120 Row2 1 D1130 Row3 3 D1140 Row4 7 I wish to create a report that looks like this (The values correspond to the codes): Desc Col1 Col2 Col3 ================================ Row1 2 1 4 row2 4 2 1 Row3 5 9 3 Row4 3 1 7