Solved

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

Posted on 2008-10-10
2
5,056 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is this spec enough for a developer or is it just blabble ? 1 37
TSQL Challenge... 7 36
SQL R 21 27
changing page verifacation 1 28
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

837 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