Unable to Export Matrix based Report to Excel

Last Post 18 Mar 2007 06:54 AM by sachavieuxroy. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sachavieuxroy
New Member
New Member

--
18 Mar 2007 06:54 AM
The matrix report which I created, uses the [Static Group] in the rows section of the matrix to display several custom calculations that use aggregrate functions. This works fine, when using the windows Report Viewer print features or when exporting to PDF. But, when I attempt to export the report to Excel I get the following error:

An error occured during local report processing.
An error occured during rendering of the report.
An error occured during rendering of the report.
Index was out of range. Must be non-negative and less than size of the collection.
Parameter name: Index

The is the Report code.

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="HRDATA">
<DataSourceReference>HRDATA</DataSourceReference>
<rdataSourceID>55ac96db-7cde-4b80-9237-afcbd8656b92</rdataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>20in</PageWidth>
<ReportParameters>
<ReportParameter Name="Quinzaine">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>200001</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>false</rd:SnapToGrid>
<Body>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>0.23958in</Width>
</MatrixColumn>
</MatrixColumns>
<Left>0.03125in</Left>
<RowGroupings>
<RowGrouping>
<Width>0.03125in</Width>
<FixedHeader>true</FixedHeader>
<DynamicRows>
<ReportItems>
<Textbox Name="Section">
<HideDuplicates>HRDATA</HideDuplicates>
<ZIndex>5</ZIndex>
<ToggleImage>
<InitialState>true</InitialState>
</ToggleImage>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<BackgroundColor>#6e9eca</BackgroundColor>


Acceptable Use Policy
---