Horizontal to vertical - SQL Server Forums

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

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Horizontal to vertical

Author

Topic

itsarnie
Starting Member

18 Posts

Posted - 2009-10-26 : 08:15:51

Hi,

I have table like:
A B C
1 2 3

I want to view this as:
A 1
B 2
C 3...in SSRS..

Please provide me some hint...

Thanks and regards
Arnie,

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 08:19:26

You should be able to use a Matrix Report style and specify the field you want as rows and columns

John
It's a small world (but I wouldn't want to paint it)

itsarnie
Starting Member

18 Posts

Posted - 2009-10-26 : 09:02:12

I couldnot...

There are no rows..
only columns and there values...So,I couldnot form the matrix ...

Thanks and regards
Arnie,

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 09:11:22

A column that has a value, by definition that "value" is a row.

Could you post the table definition here? How about also posting a sample Select statement?

John
It's a small world (but I wouldn't want to paint it)

itsarnie
Starting Member

18 Posts

Posted - 2009-10-26 : 09:15:59

Ok..I got it...

Had to put the table in a list...and I got the required format..

Thanks and regards
Arnie,

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources