Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (Network Steve Forum)

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Keep getting this error when positioning to the last page of a report. Using Server 2003...SqlRpt Svcs 2000 sp2 Detail error msg: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Anyone have any suggestions? Any way to find out what collection is blowing?...or where parameter name: index comes from?

January 22nd, 2006 4:34am

Figured it out...it wasa white space issue...and RS was trying to insert another page at eoj...when no data was available

Free Windows Admin Tool Kit Click here and download it now

January 26th, 2006 4:24am

Can you please provide the RDL and data files that were used when the problem was seen? I'd like to find out why you were getting an exception.

January 27th, 2006 8:31pm

I was getting the same error message.I had a table within the header of another table.I get this error only when I try to export in Excel.Here's the rdl==================================<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <rd:GridSpacing>0.25cm</rd:GridSpacing> <RightMargin>0.25cm</RightMargin> <Body> <ReportItems> <Table Name="table1"> <Height>4.63492cm</Height> <ZIndex>1</ZIndex> <Style /> <DataSetName>rs_CountryPercentageByFundSICAV</DataSetName> <Top>2.5cm</Top> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <Height>0.63492cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox66"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>12pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>1</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields!LegalEntity.Value</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> <RepeatOnNewPage>true</RepeatOnNewPage> </Header> <Grouping Name="LegalEntity_Group"> <GroupExpressions> <GroupExpression>=Fields!LegalEntity.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> <TableGroup> <Header> <TableRows> <TableRow> <Height>4cm</Height> <TableCells> <TableCell> <ReportItems> <Rectangle Name="rectangle2"> <ReportItems> <Textbox Name="textbox13"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>13</ZIndex> <Top>1.25cm</Top> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>USD Ccy</Value> <Left>3.25cm</Left> </Textbox> <Textbox Name="textbox74"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>12</ZIndex> <Top>1.75cm</Top> <Height>0.5cm</Height> <Width>1.75cm</Width> <CanGrow>true</CanGrow> <Value>Units</Value> <Left>10.75cm</Left> </Textbox> <Textbox Name="textbox29"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>11</ZIndex> <Top>1.75cm</Top> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>EUR Ccy</Value> <Left>3.25cm</Left> </Textbox> <Textbox Name="textbox78"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>10</ZIndex> <Top>1.75cm</Top> <Height>0.5cm</Height> <Width>2.75cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!ShareClassUnits.Value</Value> <Left>12.5cm</Left> </Textbox> <Textbox Name="LegalFundName"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextDecoration>Underline</TextDecoration> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>9</ZIndex> <Top>1.5cm</Top> <rd:DefaultName>LegalFundName</rd:DefaultName> <Height>0.48281cm</Height> <Width>2.53968cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!LegalFundName.Value</Value> <Left>0.5cm</Left> </Textbox> <Textbox Name="textbox32"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>8</ZIndex> <Top>1.75cm</Top> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!NAVPrice.Value * Fields!ShareClassUnits.Value * Fields!FXRateEUR.Value</Value> <Left>6.75cm</Left> </Textbox> <Textbox Name="textbox10"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>7</ZIndex> <Top>0.75cm</Top> <rd:DefaultName>textbox10</rd:DefaultName> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>Total NAV in Fund Ccy</Value> <Left>3.25cm</Left> </Textbox> <Textbox Name="textbox18"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>6</ZIndex> <Top>1.25cm</Top> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!NAVPrice.Value * Fields!ShareClassUnits.Value * Fields!FXRateUSD.Value</Value> <Left>6.75cm</Left> </Textbox> <Textbox Name="TotalFundNAVCcy_1"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>5</ZIndex> <Top>0.75cm</Top> <rd:DefaultName>TotalFundNAVCcy_1</rd:DefaultName> <Height>0.5cm</Height> <Width>3.5cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!TotalFundNAVCcy.Value</Value> <Left>6.75cm</Left> </Textbox> <Table Name="table2"> <Height>1cm</Height> <ZIndex>4</ZIndex> <Style> <FontSize>8pt</FontSize> </Style> <Header> <TableRows> <TableRow> <Height>0.5cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox16"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Bottom>1pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>9</ZIndex> <rd:DefaultName>textbox16</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Agent Code</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox24"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Bottom>1pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>8</ZIndex> <rd:DefaultName>textbox24</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Agent Name</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox35"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Bottom>1pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>7</ZIndex> <CanGrow>true</CanGrow> <Value>Units</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox25"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Bottom>1pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>6</ZIndex> <rd:DefaultName>textbox25</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Value in Fund Ccy</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox1"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Bottom>1pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>5</ZIndex> <rd:DefaultName>textbox1</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Percentage</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Header> <Top>2.75cm</Top> <Width>16.33333cm</Width> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <Height>0.5cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="AgentCode"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>4</ZIndex> <rd:DefaultName>AgentCode</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!AgentCode.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="AgentName"> <Style> <PaddingLeft>2pt</PaddingLeft> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>3</ZIndex> <rd:DefaultName>AgentName</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!AgentName.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox36"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>2</ZIndex> <CanGrow>true</CanGrow> <Value>=Sum(Fields!ValueFundCcy.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="ValueFundCcy_1"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>1</ZIndex> <rd:DefaultName>ValueFundCcy_1</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!ValueFundCcy.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="PercentageInSClassCcy"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>P</Format> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <rd:DefaultName>PercentageInSClassCcy</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!PercentageInSClassCcy.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Header> <Grouping Name="AgentCode_Group"> <GroupExpressions> <GroupExpression>=Fields!AgentCode.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Left>1.5cm</Left> <TableColumns> <TableColumn> <Width>2.08333cm</Width> </TableColumn> <TableColumn> <Width>7cm</Width> </TableColumn> <TableColumn> <Width>2cm</Width> </TableColumn> <TableColumn> <Width>3cm</Width> </TableColumn> <TableColumn> <Width>2.25cm</Width> </TableColumn> </TableColumns> </Table> <Textbox Name="textbox11"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>3</ZIndex> <Top>0.75cm</Top> <Height>0.5cm</Height> <Width>1.75cm</Width> <CanGrow>true</CanGrow> <Value>Fund Ccy</Value> <Left>10.75cm</Left> </Textbox> <Textbox Name="textbox14"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N</Format> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>2</ZIndex> <Top>1.25cm</Top> <Height>0.5cm</Height> <Width>2.75cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!NAVPrice.Value</Value> <Left>12.5cm</Left> </Textbox> <Textbox Name="textbox6"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>1</ZIndex> <Top>1.25cm</Top> <Height>0.5cm</Height> <Width>1.75cm</Width> <CanGrow>true</CanGrow> <Value>NAV price</Value> <Left>10.75cm</Left> </Textbox> <Textbox Name="TotalFundNAVCcy"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <Top>0.75cm</Top> <rd:DefaultName>TotalFundNAVCcy</rd:DefaultName> <Height>0.5cm</Height> <Width>2.75cm</Width> <CanGrow>true</CanGrow> <Value>=Fields!ShareClassCurrency.Value</Value> <Left>12.5cm</Left> </Textbox> </ReportItems> <Style /> </Rectangle> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Header> <Grouping Name="LegalFundName_Group"> <GroupExpressions> <GroupExpression>=Fields!LegalFundName.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Left>0.25cm</Left> <TableColumns> <TableColumn> <Width>19.75cm</Width> </TableColumn> </TableColumns> </Table> <Rectangle Name="rectangle1"> <ReportItems> <Textbox Name="textbox23"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>5</ZIndex> <Top>0.5cm</Top> <Height>0.5cm</Height> <Value>5 rue Hhenhof L-1736 Senningerberg</Value> <Left>11.5cm</Left> </Textbox> <Textbox Name="textbox22"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>4</ZIndex> <Top>1cm</Top> <Height>0.5cm</Height> <Value>Tel: +352 341 342 202</Value> <Left>11.5cm</Left> </Textbox> <Textbox Name="textbox21"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>3</ZIndex> <Top>1.5cm</Top> <Height>0.5cm</Height> <Value>Fax: +352 341 342 342</Value> <Left>11.5cm</Left> </Textbox> <Textbox Name="textbox19"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>9pt</FontSize> <VerticalAlign>Bottom</VerticalAlign> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>2</ZIndex> <rd:DefaultName>textbox19</rd:DefaultName> <Height>0.5cm</Height> <Value>Schroders Investment Management (Luxembourg) SA</Value> <Left>11.5cm</Left> </Textbox> <Line Name="line1"> <ZIndex>1</ZIndex> <Top>2.25cm</Top> <Width>-20cm</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Left>20cm</Left> </Line> <Textbox Name="textbox5"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>14pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>600</FontWeight> </Style> <Height>1cm</Height> <Width>8cm</Width> <CanGrow>true</CanGrow> <CanShrink>true</CanShrink> <Value>=Globals!ReportName</Value> </Textbox> </ReportItems> <Height>2.25cm</Height> <Style /> </Rectangle> </ReportItems> <Style /> <Height>8.75cm</Height> <ColumnSpacing>1cm</ColumnSpacing> </Body> <TopMargin>0.25cm</TopMargin> <DataSources> <DataSource Name="MISDatamart"> <rd:DataSourceID>cebfc401-4541-4fbc-a5f7-541ec4ba92a4</rd:DataSourceID> <DataSourceReference>MISDatamart</DataSourceReference> </DataSource> </DataSources> <Code /> <Width>20cm</Width> <DataSets> <DataSet Name="rs_CountryPercentageByFundSICAV"> <Fields> <Field Name="LegalEntity"> <DataField>LegalEntity</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="LegalFundName"> <DataField>LegalFundName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AgentResidencyCode"> <DataField>AgentResidencyCode</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AgentCode"> <DataField>AgentCode</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="AgentName"> <DataField>AgentName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustomerResidencyCode"> <DataField>CustomerResidencyCode</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustomerNumber"> <DataField>CustomerNumber</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="CustomerName"> <DataField>CustomerName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Units"> <DataField>Units</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="ShareClassUnits"> <DataField>ShareClassUnits</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="NAVPrice"> <DataField>NAVPrice</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="ValueFundCcy"> <DataField>ValueFundCcy</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="TotalFundNAVCcy"> <DataField>TotalFundNAVCcy</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="PercentageInSClassCcy"> <DataField>PercentageInSClassCcy</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="ShareClassCurrency"> <DataField>ShareClassCurrency</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="FXRateGBP"> <DataField>FXRateGBP</DataField> <rd:TypeName>System.Double</rd:TypeName> </Field> <Field Name="FXRateUSD"> <DataField>FXRateUSD</DataField> <rd:TypeName>System.Double</rd:TypeName> </Field> <Field Name="FXRateEUR"> <DataField>FXRateEUR</DataField> <rd:TypeName>System.Double</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>MISDatamart</DataSourceName> <CommandType>StoredProcedure</CommandType> <CommandText>rs_CountryPercentageByFundSICAV</CommandText> <QueryParameters> <QueryParameter Name="@Date"> <Value>=Parameters!Date.Value</Value> </QueryParameter> <QueryParameter Name="@SicavFundFlag"> <Value>=Parameters!SicavFundFlag.Value</Value> </QueryParameter> <QueryParameter Name="@Fund"> <Value>=Parameters!Fund.Value</Value> </QueryParameter> <QueryParameter Name="@ResidencyFlag"> <Value>=Parameters!ResidencyFlag.Value</Value> </QueryParameter> <QueryParameter Name="@Residency"> <Value>=Parameters!Residency.Value</Value> </QueryParameter> <QueryParameter Name="@AgentExcluded"> <Value>=Parameters!AgentExcluded.Value</Value> </QueryParameter> </QueryParameters> </Query> </DataSet> </DataSets> <LeftMargin>0.25cm</LeftMargin> <rd:SnapToGrid>true</rd:SnapToGrid> <PageHeight>29.7cm</PageHeight> <rd:DrawGrid>true</rd:DrawGrid> <PageWidth>21cm</PageWidth> <rd:ReportID>ec42935e-94e5-40a4-a7f0-43ea5abfa6f4</rd:ReportID> <PageFooter> <ReportItems> <Line Name="line2"> <ZIndex>3</ZIndex> <Top>0.25cm</Top> <Height>0cm</Height> <Width>-20cm</Width> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Left>20cm</Left> </Line> <Textbox Name="textbox2"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>2</ZIndex> <Top>0.5cm</Top> <rd:DefaultName>textbox2</rd:DefaultName> <Height>0.5cm</Height> <Width>6cm</Width> <CanGrow>true</CanGrow> <CanShrink>true</CanShrink> <Value>="Run on: "& Globals.ExecutionTime</Value> <Left>13.95cm</Left> </Textbox> <Textbox Name="textbox4"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Center</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>1</ZIndex> <Top>0.5cm</Top> <Height>0.5cm</Height> <Width>4cm</Width> <CanGrow>true</CanGrow> <CanShrink>true</CanShrink> <Value>="Page " & Globals.PageNumber & " of " & Globals.TotalPages</Value> <Left>8cm</Left> </Textbox> <Textbox Name="textbox3"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontSize>8pt</FontSize> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <Top>0.5cm</Top> <rd:DefaultName>textbox3</rd:DefaultName> <Height>0.5cm</Height> <Width>7cm</Width> <CanGrow>true</CanGrow> <CanShrink>true</CanShrink> <Value>=Globals!ReportName</Value> </Textbox> </ReportItems> <PrintOnLastPage>true</PrintOnLastPage> <PrintOnFirstPage>true</PrintOnFirstPage> <Style /> <Height>1.25cm</Height> </PageFooter> <BottomMargin>0.25cm</BottomMargin> <ReportParameters> <ReportParameter Name="SicavFundFlag"> <DataType>String</DataType> <DefaultValue> <Values> <Value>Fund</Value> </Values> </DefaultValue> <Prompt>SicavFundFlag*</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>Sicav</Value> </ParameterValue> <ParameterValue> <Value>Fund</Value> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="Fund"> <DataType>String</DataType> <DefaultValue> <Values> <Value>IEMKA,IEMKB</Value> </Values> </DefaultValue> <Prompt>Fund/SICAV*</Prompt> </ReportParameter> <ReportParameter Name="ResidencyFlag"> <DataType>String</DataType> <DefaultValue> <Values> <Value>Agent</Value> </Values> </DefaultValue> <Prompt>ResidencyFlag*</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>Agent</Value> </ParameterValue> <ParameterValue> <Value>Client</Value> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="Residency"> <DataType>String</DataType> <DefaultValue> <Values> <Value>lu</Value> </Values> </DefaultValue> <AllowBlank>true</AllowBlank> <Prompt>Residency</Prompt> </ReportParameter> <ReportParameter Name="Date"> <DataType>DateTime</DataType> <DefaultValue> <Values> <Value>03/03/05</Value> </Values> </DefaultValue> <Prompt>Valuation Date (DD/MM/YY)*</Prompt> </ReportParameter> <ReportParameter Name="AgentExcluded"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>AgentExcluded</Prompt> </ReportParameter> </ReportParameters> <Language>en-GB</Language></Report>==================================

Free Windows Admin Tool Kit Click here and download it now

January 31st, 2006 2:35pm

Hello Jack! I am having the same problem. Could you please tell me exactly wherethere wasa white space which caused this? In a table, a textbox, etc. Thanks in advance! Greetings! Hernan

February 8th, 2006 7:16pm

In my case it was just below the last textbox on the report... What I did to correct the problem ( because VS was not letting me remove the white space by shrinking it..) was to create a new blank report and copy the objects over from the existing report making sure not excess white space was appearing... If you try this and it works for you...would you please follow up with me and let me know... thanks jack the ripper

Free Windows Admin Tool Kit Click here and download it now

February 8th, 2006 8:56pm

Hi Jack I'm having the same problem, but I can't find the white space on my report. Can you help me?

April 12th, 2006 7:54pm

I found this thread today when trying to solve a similar problem. Thanks Jack, for pointing me in the right direction. One symptomI also had was that I could not shrink the page width in the Layout view in Visual Studio.I also could not reduce the height of the page footer. Manually editing the Width statements in the RDL was the only way I could change the width, but it would reset itself once I saved and reopened. What seemed to finally do the trick was removing a couple of Line statements in the page footer in the RDL file. One had a height of 0 and a width of 10 inches, and the other had a width of 0 and a height of 0.375 inches. After that, I was able to resize the page and footer in Layout view, and the report is now rendering correctly. So, if you're having this problem, take a good look at your RDL file. Chances are that VS screwed something up. Thanks for helping my boss think I'm a genius. ;) --Barry

Free Windows Admin Tool Kit Click here and download it now

December 28th, 2006 12:12am

This was all good info and helped me find my own specific problem as it related to this error message. In my case it was a page header that wasn't set to be big enough given the placement and height of the stuff inside of it. The report properties, when set to print this page header on the first page, caused this error to be thrown when exporting to Excel. Just for the record. :)

March 15th, 2007 7:15pm

While exporing the report file to PDF from reportviewer i am getting a following error message "An error occurred during rendering of the report. (rrRenderingError) Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I have a Main Report and a Subreport. Subreport is placed in Group header of a Table in main report. deleting a subreport from the group header works fine, i can easily export the report to PDF. any help thanks in advance Prashant Kumar

Free Windows Admin Tool Kit Click here and download it now

April 21st, 2007 10:01am

Hi,I had same problem when exporting to Excel.What fixed it for me was:I had a table on my report, the footer of this table was empty, so i did not realy need it anyway.After deleting the footer row from the table export worked fine.Hope it helps other people...

May 31st, 2007 3:48am

I used matrix in my report. The column had Percentage calculation. Although there was no divide by zero error in the report, I also had same problem when i export to excel. When i correctedfordivide by zero error, my export to excel worked fine. This may be one of the way to solve. Regards, karthik

Free Windows Admin Tool Kit Click here and download it now

June 4th, 2007 1:07pm

By reading your exception..."......less than the size of the collection"....it talks about size.......so what you can do is replace int / string / object to type long. When you use long then it can store much bigger values. Usually if the array couldnt store big size data it throws that exception. So use "long" in place of int/string that should solve your problem.

January 15th, 2008 1:44am

Hy guys,I had this same error (as in the first post of this topic).Well, what solved the problem for me was the following.I removed my page header and my page footer from te report, then i deployed the report (without header en footer) and i saw all the information was pulling through from the database. So the report was working now.Then i re-created the header, put everything back that was on it. Deployed again, still working.Did the same for the footer.The only way to recognise this i think is:If you can't resize your header or footer, you probably will need to do the things i described above.Weird problem, but it got solved doing this thinks, i hope it helps for anyone else too.Regards Hephie

Free Windows Admin Tool Kit Click here and download it now

January 17th, 2008 1:41pm

i got same proble when i am using paging in my gridview wheni want to comeback to previous page. please give me the reply anyone . thanking you regards daya

January 25th, 2008 8:21am

I was getting the following exception when exporting some reports into Excel after upgrading to SP 2 which had previously worked: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index This exception was only happening when exporting some reports for some reason. I removed the header and the footer from the reports in question after reading this post, deployed the reports and voila, the reports now export without any expections!!! Hope this helps.

Free Windows Admin Tool Kit Click here and download it now

February 27th, 2008 6:33pm

I had the same issue where my page header was not large enough to handle the image inside it. I changed the height of page header, and the export to excel worked as advertized.

March 26th, 2008 6:29pm

I am having the same problem. I have a table with subreports within. When I try to export it to excel I get the "SRS Subreports within table/matrix cells are ignored.". I tried putting a rectangle and then putting the subreport within the table and got another weird error"INDEX was out of range. must be non-negative and less than the size of the collection. parametername: index"I did more testing and it seems like if the subreport is using a table, then the I get the error"Index was out of range ...". If the subreport is using a matrix, I do not get the error when trying to export to excel. So, SRS does not like table within table (via subreport), I guess. All I am trying to do is print seven subreport data in one page so that it can be easily exported to excel for manipulation. If I put the subreports just within one list - it does not work and I get more than 1 pages. Please suggest a possible workaround. Thanks! Avi

Free Windows Admin Tool Kit Click here and download it now

June 18th, 2008 2:36am

I also had this problem with multiple reports moved from SQL Katmai Feb CTP to SQL 2008 RTM on Windows Server 2008. The RDL for some reason had become corrupted. The width of certain line elements in the report had been made negative. Once I removed the negative signs, all was well.

September 4th, 2008 9:09pm

I am getting the same error when trying to export this report into Excel. This worked last week and no major changes to the layout this week. I deleted the rdl.data file, which somebody told me to try and that didn't work. I don't know what exactly to look for in the XML file to change either. Any suggestions as to where to start looking?

Free Windows Admin Tool Kit Click here and download it now

September 24th, 2008 3:32am

p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm;margin-bottom:.0001pt;text-align:right;direction:rtl;unicode-bidi:embed;font-size:12.0pt;font-family:'Times New Roman';} @page Section1 {size:595.3pt 841.9pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;} div.Section1 {page:Section1;} You must look for nonstandard values like 0 or less than zero width or height or something like these.

September 30th, 2008 11:15am

Hi All, I am creating matrix reports in SSRS 2005. The report is properly viewed in report viewer control. But when clicking the Export to Pdf option it throws the Index out of range error. This error occurs only for a specific data been rendered in the report but could not find what is actually wrong in the data. Later i just modified the height of the report footer section in designer and deployed the file and ran the report , this time it worked out and generated pdf. But this error keeps repeating and everytime we have to change some areas of design on a trial and error basis and make it work. But this is not a permanent solution. Looking for a permanent solution i installed the latest SP2 for SQl 2005 based on a KB article in Microsoft site. But no luck even after doing that. Does any one have a permanent correct solution or this is still a bug in SSRS 2005 which Microsoft has to fix. Thanks in advance for all who can help me.

Free Windows Admin Tool Kit Click here and download it now

October 30th, 2008 2:41pm

Your problem is a negative number in a width tag <width>. The GUI in BIDS (visual studio) can under some circumstances insert a negative number in the .rdl, I am guessing this is a bug that is being fixed. I have old old .rdl upgraded from SQL 2000->2005->2008 Katmai 1 & 2. Something about the formation of the xml doesn't parse with these old files, and I recently had this problem in the SQL 2008 Deployment version also.Your problematic tag appears to be the below. Search on that and remove the negative and I am guessing your problem will be fixed. <Line Name="line1"> <ZIndex>1</ZIndex> <Top>2.25cm</Top> <Width>-20cm</Width>Hope this helps.

October 30th, 2008 7:26pm

Thanks for your immediate help! I checked with the .rdl file that is deployed in report server and it does not have any negative values in any of the tags. As you say if the .rdl file has some negative number then my report should not run always. But the report generates pdf for some data without throwing this error. So can you think of some other reason for this issue?

Free Windows Admin Tool Kit Click here and download it now

October 31st, 2008 9:02am

I've been in your situation before, and have gotten out of it by either:1. Scanning the .rdl file for unwanted garbage.2. Creating a blank report, doing a select all and cutting nad pasting the report contents from one report to the other. You will have to recreate your data sources manually, and this should be done first to avoid any errors when the new controls are pasted on and have no idea what they are associated with.If that doesn't work, I would first look at all line elements on the page to see if any are rendering unusually. Or perhaps your matrix has so many columns it is exceeding the 22" width limit. I run dashboards on 1080p which are about 19.5 inches and never throw an error when rendered. Hope this helps.

October 31st, 2008 7:23pm

Hi, I have the same condition. I have a treeview that I was set its node by dynamically here when I changed the selected node this error fired?? I loked the .aspx page if is there a -width or like element value but there is not What is the reason, dont know but I thinking about that; I asked about 5 minuts ago the centence is abouve but I found the main reason: if VS2008 compiler is working debug mode and if is there a runtime error the script editor didnt know this position

Free Windows Admin Tool Kit Click here and download it now

April 10th, 2009 4:12pm

EASY SOLUTION HERE:This was easy for me to fix. I just save a copy of the .rdl file and then starting deleting items in the layoutuntil I got it to export to excel in the preview. It ended up being a text box in the report header which was the last item I would expect to cause a problem. I went back to the original .rdl file, deleted the textbox and replaced it and no more problems. Please vote as helpful if this solves your problem as even reading the rest of the replies in this thread took me longer to do than the actual fix.

April 23rd, 2009 9:33pm

Hi,I have a report with a subreport embedded in a table,when I preview everything is fine but when I export or try to view in printed mode, then I received the same error as you.On my subreport is a table, within the table there is a group, the group did not have the field to group on set to anything...Setting this value to my underlying field, saving the subreport and then re-running the parent report, everything now works as expected, including export to Adobe, which is what gave me the initial grief...

Free Windows Admin Tool Kit Click here and download it now

April 24th, 2009 5:28pm

I was having this same issue when I put another table on to an existing report. What I found was in the table I used this statement: =(ReportItems!textbox33.value*ReportItems!textbox25.value)This cause the error.I changed to:=(ReportItems!textbox33.value)*(ReportItems!textbox25.value) I'm no longer having the export issue or error being returned.

August 25th, 2009 9:57pm

I encountered this same error whenever I tried to preview the report. The way I got around it was to go through the report and delete individual items one by one until I was able to preview ( after making a backup copy of the report, of course ). Once I was able to preview the report, I could tell where the error was at. Turned out that the report was using the "RepeatWith" property on several text boxes that was causing the error. Once I turned that property off, my report ran like a track star!

Free Windows Admin Tool Kit Click here and download it now

September 1st, 2009 5:16pm

88FGT - It was just that easy. I started taking out all the footer calculations and I knew which ones were causing the problem.. but I wasn't sure why.I had (ReportItems!textbox1.value)/clng(ReportItems!textbox2.value) and it started working.... but I saw your post and it worked like a charm on all 6 reports that were having the problem.But even one better..... just take the brackets out all together if you can. Tried it and it worked as well.TALK ABOUT PICKY!!! Thats all I can say. Index problem... BAH! :DThanks for the insight.dCMAC

October 23rd, 2009 10:32pm

I resolved this error by insuring the FixedHeader property of all my columns that had a dynamic visibility property in the table were set to false. In my case, one of the columns was set to true and this was causing the error message of this thread. Hope this helps someone.

Free Windows Admin Tool Kit Click here and download it now

April 29th, 2010 11:08pm

Thought I should mention I had one of these problems with a table inside a matrix... fortunately placing the table in a list was more appropriate and solved the problem. This was in SSRS 2005. Interestingly my problem was only triggered if I placed any expression in a textbox in the page header. Without anything that could potentially resize (even ="1") in the header I had no problems with the matrix I had in the body. Here's another description of the problem: http://www.bidn.com/blogs/DustinRyan/ssis/125/ssrs-2008-index-was-out-of-range-error

June 14th, 2010 4:00am

Hi, We also had similar problem on SQL Server 2008 and 2008 R2 and it was caused by some bug in the internal void MergeRepeatSiblings(ref List<int> repeatedSiblings) method of the class Microsoft.ReportingServices.Rendering.SPBProcessing.PageItem. It was caused by a textbox with the RepeatWith setup to some Tablix object. The problem did not appear when there was only one textbox with RepeatWith property specified. Adding the second one and linking it to another one Tablix object with the RepeatWith property caused and exception to be thrown. To solve the problem we just cleared RepeatWith property. Here is the stack trace: reportrendering!ReportServer_0-2!114!09/22/2010-09:59:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report., ; Info: Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) at System.ThrowHelper.ThrowArgumentOutOfRangeException() at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItem.MergeRepeatSiblings(List`1& repeatedSiblings) at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity) at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, PageItemHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity) at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetReportNextPage(Stream& stream, Boolean collectPageBookmarks) at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream, Boolean collectPageBookmarks) at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream) at Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory cacheDataChunkFactory, IChunkFactory yukonCompiledDefinition, Boolean& dataCached) --- End of inner exception stack trace --- library!ReportServer_0-2!114!09/22/2010-09:59:25:: i INFO: Exception UnhandledReportRenderingException dumped to: C:\Program Files\Microsoft SQL Server\MSRS10.SS2008\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson chunks!ReportServer_0-2!114!09/22/2010-09:59:25:: w WARN: Rolling back shared chunk

Free Windows Admin Tool Kit Click here and download it now

September 22nd, 2010 11:52am

I'm also effected by this bug (as well as serveral others related to Reporting Services). Could someone direct me to an official page for this issue? I'd like to have a link to this one particularly and other known issues with the product generally so I can keep track of the current state of progress on this bug (and hopefully others)? For example, I'd like to be able to find out when hotfixes are released for particular issues that impact me.

October 15th, 2010 7:16pm

My experience was the same. Two lines for decoration in the page header had height zero inches. I deleted those and things worked fine.

Free Windows Admin Tool Kit Click here and download it now

October 21st, 2010 2:48am

I spoke too soon. I have 47 RDL files with these decorative lines in them and with entries with height = zero, but only the one report is failing. Still, removing the lines from that one report did allow that one report to run. So I am back in mystery-land.

October 22nd, 2010 6:19pm

I had a similar issue a few times. The reports work, then if I change the query statement in the dataset, everything falls apart. All I did to fix it was to remove my chart from the report, then everything works. Which I don't understand as I never changed the statement returning the chart data, only the statement returning the table data. If I then recreate the chart, then everything carries on working as normal.

Free Windows Admin Tool Kit Click here and download it now

October 29th, 2010 8:41am

Hi, I had faced this issues while working on SSRS 2008. I couldn't find the exact cause for this exception. But some how i found work around to get rid of this exception. I was getting this exception when i write some expression inside header or footer of report. Actually i was having Matrix control in Other matrix control. If you place Matrix inside other Matrix you will get this exception. So, i removed inner matrix control and placed it inside List control and it worked fine. Don't embed Matrix inside Matrix OR Table inside table.

November 22nd, 2010 8:28am

I had the same issue where my page header was not large enough to handle the image inside it. I changed the height of page header, and the export to excel worked as advertized. Just for the record. I got the same error message after having deploying my report on sharepoint 2010 even if it works fine in report builder 3.0. Above thread helped me. I had an image in the header (logo of my client). I think the image was to close to the up side of the page. I put the image a little bit down and it did the work for me. Thanks for all the input. Very useful.Sr. Business Intelligence Consultant

Free Windows Admin Tool Kit Click here and download it now

November 29th, 2010 3:46am

My senario is different: if i refer to the cell value from other table, i put in the bracket, the export to Excel i have the error, by removing the brackets. it is working. Wrong Eg: = (reportitems!textbox66.Value + reportitems!textbox305.Value) Correct way: = reportitems!textbox66.Value + reportitems!textbox305.Value

December 30th, 2010 12:08am

I got the same error message after having deploying my report on sharepoint 2010 even if it works fine in report builder 3.0. Above thread helped me. I had an image in the header (logo of my client). I think the image was to close to the up side of the page. I put the image a little bit down and it did the work for me. Thanks for all the input. Very useful. Sr. Business Intelligence Consultant Even though it makes no kind of logical sense, this same fix worked for me. I moved an image in the header away from the border of the page and it resolved the "index out of range error". What a waste of time!

Free Windows Admin Tool Kit Click here and download it now

May 25th, 2011 2:49pm

This topic is archived. No further replies will be accepted.