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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Pointage coming your way!