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

Sign in to vote

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

Proposed as answer by mkrupiper Tuesday, June 7, 2011 3:17 PM

Thursday, January 26, 2006 1:24 AM

0

Sign in to vote

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.

Proposed as answer by WNBBI Friday, February 22, 2013 4:18 PM

Friday, January 27, 2006 5:31 PM

1

Sign in to vote

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 Höhenhof 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>
==================================

Tuesday, January 31, 2006 11:35 AM

0

Sign in to vote

Hello Jack!

I am having the same problem. Could you please tell me exactly where there was a white space which caused this? In a table, a textbox, etc.

Thanks in advance!

Greetings!

Hernan

Wednesday, February 8, 2006 4:16 PM

0

Sign in to vote

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

Wednesday, February 8, 2006 5:56 PM

0

Sign in to vote

Hi Jack

I'm having the same problem, but I can't find the white space on my report.

Can you help me?

Wednesday, April 12, 2006 4:54 PM

1

Sign in to vote

I found this thread today when trying to solve a similar problem. Thanks Jack, for pointing me in the right direction.

One symptom I 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

Wednesday, December 27, 2006 9:12 PM

0

Sign in to vote

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. :)

Thursday, March 15, 2007 4:15 PM

0

Sign in to vote

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

Saturday, April 21, 2007 7:01 AM

0

Sign in to vote

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...

Thursday, May 31, 2007 12:48 AM

0

Sign in to vote

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 corrected for divide by zero error, my export to excel worked fine.

This may be one of the way to solve.

Regards,

karthik

Monday, June 4, 2007 10:07 AM

0

Sign in to vote

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.

Monday, January 14, 2008 10:44 PM

0

Sign in to vote

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

Thursday, January 17, 2008 10:41 AM

0

Sign in to vote

i got same proble when i am using paging in my gridview when i want to comeback to previous page.

please give me the reply anyone .

thanking you

regards

daya

Friday, January 25, 2008 5:21 AM

0

Sign in to vote

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.

Wednesday, February 27, 2008 3:33 PM

0

Sign in to vote

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.

Wednesday, March 26, 2008 3:29 PM

0

Sign in to vote

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. parameter
name: 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

Tuesday, June 17, 2008 11:36 PM

0

Sign in to vote

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.

Thursday, September 4, 2008 6:09 PM

0

Sign in to vote

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?

Wednesday, September 24, 2008 12:32 AM

0

Sign in to vote

You must look for nonstandard values like 0 or less than zero width or height or something like these.

Tuesday, September 30, 2008 8:15 AM

0

Sign in to vote

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.

Thursday, October 30, 2008 11:41 AM

0

Sign in to vote

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.

Thursday, October 30, 2008 4:26 PM

0

Sign in to vote

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?

Friday, October 31, 2008 6:02 AM

0

Sign in to vote

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.

Friday, October 31, 2008 4:23 PM

0

Sign in to vote

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

Friday, April 10, 2009 1:12 PM

1

Sign in to vote

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 layout until 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.

Proposed as answer by Will E. Smith Thursday, April 23, 2009 6:33 PM

Thursday, April 23, 2009 6:33 PM

0

Sign in to vote

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...

Friday, April 24, 2009 2:28 PM

1

Sign in to vote

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.

Tuesday, August 25, 2009 6:57 PM

2

Sign in to vote

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!

Tuesday, September 1, 2009 2:16 PM

0

Sign in to vote

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! :D

Thanks for the insight.
dCMAC

Friday, October 23, 2009 7:32 PM

0

Sign in to vote

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.

Thursday, April 29, 2010 8:08 PM

0

Sign in to vote

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

Monday, June 14, 2010 1:00 AM

0

Sign in to vote

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

Wednesday, September 22, 2010 8:52 AM

0

Sign in to vote

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.

Friday, October 15, 2010 4:16 PM

0

Sign in to vote

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

Wednesday, October 20, 2010 11:48 PM

0

Sign in to vote

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.

Friday, October 22, 2010 3:19 PM

0

Sign in to vote

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.

Friday, October 29, 2010 12:40 PM

0

Sign in to vote

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.

Monday, November 22, 2010 1:26 PM

1

Sign in to vote

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

Proposed as answer by 3TrungNguyen Thursday, December 30, 2010 4:55 AM

Monday, November 29, 2010 8:42 AM

0

Sign in to vote

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

Thursday, December 30, 2010 4:58 AM

0

Sign in to vote

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!

Wednesday, May 25, 2011 6:41 PM

0

Sign in to vote

Hi, Had a same problem. In my scenario I have a table with two header rows and one group row. Inside the group row there is a nested table consisting of two header rows. There are lots more elements but the one causing the error is a page break before option ticked on the main table described above. As soon as I un-ticked the box the report works again. Hope it helps, Joanna

Proposed as answer by aila84 Thursday, August 4, 2011 1:02 PM

Thursday, August 4, 2011 1:01 PM

0

Sign in to vote

Same error message very different "fix". My report had two parameters both containing a default. I tried many of the other solutions and nothing. Finally after the error appeared I changed one of the parameters and hit the View Report button. All was well. Maybe I could have achieved the same result by blowing away the Report.rdl.data file? I will try that first next time.

Friday, March 30, 2012 3:36 PM

0

Sign in to vote

I had this error and spent quite a while trying to figure out the cause (which I'm still not sure of). Eventually I opened Windows explorer, found the .rdl file and created a copy of it, just to run some tests on it. I opened the copy version of the file and it worked straight away! No idea why it did this but it's worth a try doing something as simple as this first before you spend hours trying to fix it

Wednesday, May 9, 2012 3:30 PM

0

Sign in to vote

I know this has been solved and it's been over some 7 years of seeing this issue. But I have a solution that no one has mentioned before and I'm not sure it will work for anyone else, but I thought I would put it out here just as another option to try in case it can help someone.

When I got this error, I had a main report(Report2) with two subreports (Report2a & Report2b) all encapsulated within a list rectangle. They shared a parameter as well. I tried a couple of the solutions listed hear on this thread but nothing seemed to work.

Finally I was going to create a copy of the RDL file and start subtracting things out 1 by 1 until I could figure out which culprit was causing my issue.

Well as I created the backup. I pulled down the "File" pull-down menu and did a "Save As" and called it Report2BAK. Of course it did the Microsoft thing and left me with the newly named Report2BAK in place of the original Report2. I assumed that my Report2 would be saved. Anyway, for the sake of troubleshooting I attempted to render the newly created Report2BAK and it worked!!! I hadn't changed anything else since I last attempted it as Report2.

Then when I go to look for the original Report2.rdl, in the Solution Explorer I can't find it. I know it must be there but I can't find it in the list. So I perform another rename, to go from Report2BAK back to Report2 and once it was replaced in the current designer, I reviewed it and it Worked again, with the Original name Report2. I don't know if this may have been some form of corruption but it go t me through this error, hopefully it can help you.

Sawyer

Tuesday, May 7, 2013 6:58 PM

0

Sign in to vote

I appreciate this is a really old thread but I'm posting this in case someone else has/had the same symptoms and cause.

I too had the RepeatWith issue associating a text box with a table, looking at the error message it said
'...must be in a data region within the same container...'.

My controls were both in the body which I thought would be OK but I guess for some reason it sometimes doesn't recognise it as the same continer.

My solution was to drag both controls into a rectangle - now they share the same container.

Works fine when rendered in viewer but not when exported to pdf.

Friday, November 22, 2013 12:53 AM

1

Sign in to vote

delete <main report>.rdl.data will do

Saturday, March 18, 2017 9:27 PM

Answered by:

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

Question

Answers

All replies