Solved

How to work around "Data Regions within table/matrix cells are ignored" problem

Posted on 2008-10-10
2
5,042 Views
Last Modified: 2012-05-05
I'm using Reporting Services 2005 and to achieve the report layout I wanted I have a table within a matrix cell.

See the attached pics, the layout of the report itself and the output I want to achieve - various sub-totals on the left-hand-side with the blue header using a table grouped on date, and totals per call result on the right-hand side with the yellow header using a classic matrix.

Unfortunately rendering of this is not supported in Excel (with the error "Data regions within table/matrix cells are ignored")

Any ideas how I can achieve the same layout in a way that is supported in Excel?
EEReportLayout.jpg
EEMatrixReport.jpg
0
Comment
Question by:catherinelouise
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 22693961
I recently had a similar issue, tables within tables, and also needed to find a solution for it.

If upgrading to SQL Server 2008 is an option for you then it would be the perfect situation.  In SQL Server 2008 this issue no longer exists.  I did a test with my report.  All I had to do was deploy it on the 2008 server and the export to Excel worked fine, without any modification required!

If that's not an option then you should try to achieve the same result without using nested objects. In my case I used tables in a main table to get a decent layout (the report had 5 drilldown levels).  Upgrading was not an option.  So I ended up removing the nested tables and re-using the existing columns of the main table.  Layout of the report was degraded but still acceptable for the users and the export to Excel worked.
0
 
LVL 5

Author Comment

by:catherinelouise
ID: 22696721
Thankyou for your response ValentinoV - your answer is as I expected!  Upgrading isn't an option unfortunately, so I'll see what I can do without nesting the tables.

Pointage coming your way!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question