Subreports within table/matrix cells are ignored
Unfortunately, subreports within a table or matrix cannot be exported to Excel. I am not sure why MS did not allow this with Reporting Services. This came into play recently when I wanted to make a report that displayed detail data next to the header data. This would be like displaying customer information and then orders and dollars next to the customer's information. I wanted to display the data side by side with a running list of customer information on the left and a listing of orders on the right. Unfortunately, lack of a vertical cell merge forced me into a subreport within a matrix. This is not very efficient but worked.
The work around was to change out the table and go with a table of orders inside a list of customers. Unfortunately, the table is easier when modifying 30 rows of data. In a list, each field is a text box not a row and column. Now imagine moving and resizing all of them at once, can someone say Crystal Reports :O( Placing the table next to these text boxes also created interesting issues. When there was multiple orders, the text boxes would slide down on the print preview leaving a gap in the customer information. To remedy this, I had to place the table in a box. I expanded the box to the bottom of the page.
The last weird issue I had was how the table is treated in a list box. I wanted to filter the table to only display that customer's orders. Instead of calling my customer dataset for the list and order dataset for the table and filter orders based on customer; I had to make one dataset to return both customer and order information. I grouped the list by customer data, then I had to filter the table that was the same dataset by the customer number.
In all, this was a very time consuming and annoying process just to display the data. I am not sure why a table in a table does not work, why there is no vertical cell merge, and why subreports don't export to excel; but I encourage MS to fix these issues.
The work around was to change out the table and go with a table of orders inside a list of customers. Unfortunately, the table is easier when modifying 30 rows of data. In a list, each field is a text box not a row and column. Now imagine moving and resizing all of them at once, can someone say Crystal Reports :O( Placing the table next to these text boxes also created interesting issues. When there was multiple orders, the text boxes would slide down on the print preview leaving a gap in the customer information. To remedy this, I had to place the table in a box. I expanded the box to the bottom of the page.
The last weird issue I had was how the table is treated in a list box. I wanted to filter the table to only display that customer's orders. Instead of calling my customer dataset for the list and order dataset for the table and filter orders based on customer; I had to make one dataset to return both customer and order information. I grouped the list by customer data, then I had to filter the table that was the same dataset by the customer number.
In all, this was a very time consuming and annoying process just to display the data. I am not sure why a table in a table does not work, why there is no vertical cell merge, and why subreports don't export to excel; but I encourage MS to fix these issues.


Hi Adam.. Have come across the nested table problem and have been trying various list/table combinations. Have read through your blog but don't fully comprehend it. Are you able to post up some sample code? or email me a copy? Would really appreciate it!
Reply to this
Create your dataset
Add a list to the body of the report
Make the dataset of the list your dataset
Under the same properties window assign a field to group on
Put a textbox inside of the list
Give it a value from the field in your dataset
Put a table inside of your list
Make its dataset the same as the list
Add a detail field from the dataset
Run the report
Reply to this
I am having this problem as well. Seems to me that MS should have caught this before pushing out their product. Very annoying!
Reply to this
I had this same issue, which is actually supposed to be fixed in RS 2008. Glad you shared the details of how difficult it was so I can decide wether it was worth it for my particular report. Thanks.
Reply to this
I am having the same problem. I have a table with subreports within. When I try to export it to excel I get the "SRS Subreports within table/matrix cells are ignored.". I tried putting a rectangle and then putting the subreport within the table and got another weird error
"INDEX was out of range. must be non-negative and less than the size of the collection. parameter
name: index"
All I am trying to do is print seven subreport data in one page so that it can be easily exported to excel for manipulation. If I put the subreports just within one list - it does not work.
please suggest.
Reply to this