Report Output

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 ?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
"May Liu" wrote:
> 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 ?
>

Report Manager Issue

I have created a parameter in a report, then deployed it Report Manager - this is the issue -

People with only one budget department brought a Reporting Services problem to the forefront - drop-down list boxes seem to be made large enough for x-1 of the items in the list. If there's only one item in the list, the listbox is so small that you can't see the item in the list. Does anyone know how to change the format of some of the stock controls in RS?

This is a known issue that was recently fixed in a QFE. The QFE is not a public QFE so you will need to contact Customer Service to get it. You can refer to KB 919556.