Tables - 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

Development Tools

Reporting Services Development

Tables

Author

Topic

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-11-24 : 11:45:51

HI all I was wondering if you can get a table in report services to rotate. can it be changed from going horizontal to vertical or something like that??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-24 : 11:47:22

it sounds as if what you need is a matrix. can you explain your requirement? how do you want container to go? based on what data?

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-11-24 : 12:20:30

I am trying to get it to replace the Excel spreadsheet we have. It would be allot better with report services becuase the data will be coming from a database. you know how you can have the data go Horizontal or vertical, well I would like for the data to go vertical. Because each department will have their own table. Example

Auditors

Label Data
Label Data
Label Data

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-24 : 12:26:29

quote:
Originally posted by muzzettemm

I am trying to get it to replace the Excel spreadsheet we have. It would be allot better with report services becuase the data will be coming from a database. you know how you can have the data go Horizontal or vertical, well I would like for the data to go vertical. Because each department will have their own table. Example

Auditors

Label Data
Label Data
Label Data

select a matrix and select row group as items you want to come as rows and column group as ones you want to see as headers for data.

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-11-24 : 12:59:20

Oh now thats perfect thank you so much guys.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-24 : 13:07:10