sql server reporting services: Report Output -- sql server reporting services

Report Output

May Liu
11/24/2004 5:57:02 PM

sql server reporting services:

Normally, the report always display like the follow:

Department Employee No. Average Salary
-----------------------------------------------------------
HR 15 11250
IT 25 15510
Sales 5 10000

But I want to display the record as the follow: (the record is shown
horizontally, instead of vertical)

Department HR IT Sales
Employee No. 15 25 5
Average Salary 11250 15510 10000

How can I do that ???

RE: Report Output

Chris McGuigan
11/25/2004 1:45:01 AM

May Liu,
Use a matrix instead of a table, your scenario is exactly what they are for.
If your query finds a new department it will add another column automatically.

Regards
Chris

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.