Row headers in matrix report

Question

Hi,

I am trying to create the following matrix report:

Car             Driver        Cost          Company 1   Company 2    Company 3
Mercedes    John Doe    650$                500$            100$              50$
Ford            Alice            200$                100$            100$                0$


The number of Companies are variable, so i use a Matrix report with Car, Driver and Cost as Rows and Company as Columns

I have succeded in making this:
                                                       Company 1   Company 2    Company 3
Mercedes    John Doe    650$                500$            100$              50$
Ford            Alice            200$                100$            100$                0$

But I cant figure out to put the row headers...(Car, Driver, Cost).

I am using SSRS 2005, using 2008 is not an option because a need them to run with the reportvierwer contol in local-mode.

Thank for any advice!!

Answer 1

Hi,

As far as I know row headers are not allowed when you use matrix report in any of the reporting tools.

Regards,
Raju

Answer 2

I do have to use a matrix lay-out, don't I?
Since the Company is based on a table that is dynamic. It is possible to add/delete companies.

The report shows how the total cost of the car is split between the companies.

Thanks,
Bart

Answer 3

i face the same problem but i resolved it.
matrix does support for multiple row headers for row groups it will give only one single text box

i will tell u what work around i did for this

as u know u r row groups width is constant for the report

1. take a rectangle and place it in the row groups headers text box
2. and place 3 text boxes sided by side in that rectangle
3. align that text boxes with the proper width of the row groups

thats it u r done ..

Answer 4

Thanks Sateesh,

I was considering placing textboxes on top of my rows, but I was hoping for a more elegant solution :)
I'll keep it as a last solution.

Thanks,
Bart

Answer 5

Hi Bart,

It seems you are using Reporting Services 2005, and the only possible work around I konw is using nested Rectangle/table... as Sateesh mentioned. Of cause, this has been improved from Reporting Services 2008. Also, you will see more interesting improvement if you can try the SSRS 2008.

Regards,
Raymond

Answer 6

Thanks Raymond,

too bad I can't use SSRS 2008, because i need my reports to run in local-mode with the reportviewer control.
And that is not possible with SSRS 2008 reports...

Regards,
Bart