I am building a report using VS 2005 BIDS and SSRS 2005. I do NOT control the version, so this is what I HAVE TO work with.
My report has a matrix. It also has two datasets. One data set presents the data for a number of business units. The other dataset presents the data for the whole organization.
I want to have a single matrix if at all possible where the rows are as follows.
- Top Row = Parameter Selection Information (I have this in place)
- Second Row = Enterprise Name and Data for Enterprise (I don't know how to insert this row)
- Third Row = column headers for data
- Fourth to nth row = data for business units
The second and third row can be swapped, but basically I want the report to scroll such that the users sees the enterprise data along with the row headers. I can even give up on that, if I could only figure out how to add the row for the enterprise data
into the matrix for the business unit data.
Right now I am presented it as two separate matrices. It sucks, but it works. Can someone help me figure out how to get this row into the matrix?
View Complete Post