March 6, 2006 at 3:07 pm
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
March 7, 2006 at 9:14 am
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
March 8, 2006 at 1:24 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply