Hi all 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? Thanks

I am not sure whether I have undertood your requirement completely. However you could do one thing ! You could place a detail section of a matrix/table control into the 2nd row where you want to display the Enterprise Name and Data for enterprise. HTH, Ram

Hi Richard, From your description, I noticed that you want to present data from 2 datasets in a single matrix, correct? If I have misunderstood, please point out. By design, with a data region, we can only use data from a single dataset. And I also noticed that currently you are using 2 matrices, but it is not satisfactory. Could you post more details about the current result and your expectation? Then, I will try to provide you further assistance. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Richard, From your description, I noticed that you want to present data from 2 datasets in a single matrix, correct? If I have misunderstood, please point out. By design, with a data region, we can only use data from a single dataset. And I also noticed that currently you are using 2 matrices, but it is not satisfactory. Could you post more details about the current result and your expectation? Then, I will try to provide you further assistance. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi all Sorry for not getting back sooner on this. We have decided to go to SQL 2008 R2! Yaaaay!! I still have the same issue. I will try some of the suggestions here, but using 2008 instead of 2005. I will get back to you on the results. Thanks Richard

Hi all First of all, let me say how much I appreciate the help these forums and you as individuals offer to folks like me. It's excellent. Having switched to SQL 2008 R2 it was a relatively simple thing to add a row to the group. Then I simply added the data from the second dataset as an expression in the header row. Now the data is properly presented in the proper row, and it all scrolls as required. Thanks Richard