Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5188
  • Last Modified:

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

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
catherinelouise
Asked:
catherinelouise
1 Solution
 
ValentinoVBI ConsultantCommented:
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
 
catherinelouiseAuthor Commented:
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now