Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-10
2
Medium Priority
?
5,155 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 2000 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

670 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