Matrix report

Question

Matrix report

Santosh M

Newbie

Points: 2
More actions
March 6, 2006 at 3:07 pm

#112980

Hello,
Am having this problem, and i have not been able to solve it as yet.
The requirement is to have a matrix like structure such as:
                   Column Header
Row Header    Value1;
                    Value2;
I was able to create a matrix report using SQL Reporting services 2000, placed the column as well as Row headers, however, the value can be just an aggregate expression, which means I can have only one value as the data. But the requirements is to have multiple values in the data placeholder.
Does anyone have experienced the same problem as me? Any help will be highly appreciated.
Regards
Santosh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Mike Kendall SSC Eights! Points: 958 More actions · Answer 1

Santosh,

Can do. After you've created the basic maxtrix with an aggregate cell for 'Value1' right click in that cell and select either 'Add Row' or 'Add Column'. depending on whether you want Value2 below or to the right of Value1. This will create what's termed a 'Static Row/Column'.

Mike

Santosh M Newbie Points: 2 More actions · Answer 2

Thanks for your reply, Mike.

The Value2 mentioned was just an example.. there could be multiple detail rows. I did find a solution: to have the stored proc return the values in a row separated by '~'. And then in my report having a custom code that would remove the '~' and replace them by a carriage return. But this appears a bit convoluted.

I was also experimenting the RunningValue as an expression , but was not so successful.

Thanks very much

Regards

Santosh