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
Really enjoyed reading through your blog, please keep posting similar stuff! Waiting for new Blogs, thankyou.
Reply to this
Cool,
This has been a very interesting post and has come in very useful,
Anyway, thanks for the post
Reply to this
This is great information, just what I was hoping for, has helped me with my coursework, thanks A+++++ Blogger!
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 want to express my admiration of your writing skill and ability to make reader to read the while thing to the end. I would like to read more of your blogs and to share my thoughts with you. I will be your frequent visitor, that’s for sure.
Reply to this
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It's always nice when you can not only be informed, but also entertained!
Reply to this
It helped me with ocean of knowledge so I really believe you will do much better in the future I appreciate everything you have added to my knowledge base.Admiring the time and effort you put into your blog and detailed information you offer!
http://www.lessons4craps.com
Reply to this
Well thanks for the help keep it up!
Reply to this
This page added to Google cache Cached: http://google.com/search?q=cache:http://mysqlserverblog.com/2007/11/27/subreports-within-tablematrix-cells-are-ignored.aspx?ref=rss&ei=AFQjCNHajN_OX0kgxzx7UGA1yBfpoRn tubedfWq
Reply to this
This is good information about creating a table. It will help data management for your business.
Reply to this
For your kind information, subreports within a table or matrix now can be exported to Excel. isn't it great ?
Reply to this
What are the differences between web design and graphic design and which career should I choose?
Reply to this
What are all the elements of graphic design?
Reply to this
This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.
Reply to this
The people who made this should set the example for what humankind should be and represent. Purely perfect amazing work.
http://www.bingogratis.fr
Reply to this
I certainly agree with the author that sub-reports within a table or matrix cannot be exported to Excel. I found this really annoying. I work as an accountant which means that I will have to work a lot with Excel. I found Excel to be extremely helpful in my assignments but in the above case I found it to be of no use. I am certainly going to mail to Microsoft telling them about the problem. I hope that at least in the next version they will make the necessary changes.
Reply to this
thanks god it is fixed with the new version...
Reply to this
That's great, I never thought about Subreports within table/matrix cells are ignored like that before.
Reply to this
oK, Well, I am very late to this post. But didn't knew about it. That's good to now.
Reply to this
The closest you can get is to look into changing the design of the report to use lists / nested lists or not using subreports if you want to export to Excel also. This limitation of the Excel renderer will be removed in a future SSRS release.
Reply to this
Nice information, many thanks to the author. It is incomprehensible to me now, but in general, the usefulness and significance is overwhelming. Thanks again and good luck!
Reply to this
I got the same problem!! The reports looks good in the Report Viewer but when I render in Excel format I got this error : "Subreports within table/matrix cells are ignored" I have SP2 installed Plz help us
Reply to this
Designers typically list locations online and instore where you can purchase authentic merchandise louis vuitton fake gucci wallets copy handbags Understand the difference between designer designer inspired and replicas wholesale handbags designer handbags Designer hand bags have unique and signature qualities Designer inspired purses are purses that are inspired by popular designer handbags While Dooney and Bourke is an authentic brand its purses that include
Reply to this
it seems to be nice collection of plus size clothes since many of my friends are plus size and she didn’t find there choice of clothes so i think it would be nice option for them.
Reply to this
A fantastic presentation. Very open and informative.You have beautifully presented your thought in this blog post
Reply to this
Thank you for one more nice article. The place else may anybody get that kind of information in such an ideal approach of presentation
Reply to this