Yes it can be done. In 2005 there is something called PIVOT command. In 2000
you need to use sum and group by to rotate from horizontal to vertical.
Amarnath
[quoted text, click to view] "Amy" wrote:
> Hi,
>
> Is it possible to rotate a table in Reporting Services? In other
> words, I need the columns to run vertically down the left of the page,
> and the rows of data to also run vertically. Here is an example of
> what I need. The column names are Product Name, description, etc. The
> rows of data start with Image1, P1, etc. (These should be lined up
> vertically.)
>
> Image1 Image2 Image3 Image4 Image5
> Product Name P1 P2 P3 P4 P5
> Description Desc1 Desc2 Desc3 Desc4 Desc5
> Style Style1 Style2 Style3 Style4 Style5
> Dimensions
> Width 1 2 3 4 5
> Depth 1 2 3 4 5
> Height 1 2 3 4 5
> Price Price1 Price2 Price3 Price4 Price5
>
> Any suggestions would be greatly appreciated.
>
> Thanks in advance,
> Amy Bolden
>
Matrix layout is introduced in RS 2005. You should be able to switch rows
and columns easily. HTH
[quoted text, click to view] "Amy" wrote:
> Hi,
>
> Is it possible to rotate a table in Reporting Services? In other
> words, I need the columns to run vertically down the left of the page,
> and the rows of data to also run vertically. Here is an example of
> what I need. The column names are Product Name, description, etc. The
> rows of data start with Image1, P1, etc. (These should be lined up
> vertically.)
>
> Image1 Image2 Image3 Image4 Image5
> Product Name P1 P2 P3 P4 P5
> Description Desc1 Desc2 Desc3 Desc4 Desc5
> Style Style1 Style2 Style3 Style4 Style5
> Dimensions
> Width 1 2 3 4 5
> Depth 1 2 3 4 5
> Height 1 2 3 4 5
> Price Price1 Price2 Price3 Price4 Price5
>
> Any suggestions would be greatly appreciated.
>
> Thanks in advance,
> Amy Bolden
>
Don't see what you're looking for? Try a search.
