Link to home
Start Free TrialLog in
Avatar of catherinelouise
catherinelouise

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of catherinelouise
catherinelouise

ASKER

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!