Solved

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

Posted on 2008-10-10
2
5,110 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

623 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