SQL Reporting Services 2008 - Rectangle Page Break in Group Footer (Network Steve Forum)

SQL Reporting Services 2008 - Rectangle Page Break in Group Footer

I've got an invoice designed in SSRS 2008. Am trying to get the pagination correct. In my invoice report, I group by Invoice Number. I have multiple group footers, two of which have subreports (these are supporting documentation that are attached to most invoices - these row visibility are conditional, although the issue occurs even if they're set to show.) For some reason, the "Page Break Before" on the rectange that contains the subreport in the group footer does not fire. Any ideas? I've attached the edited RDL (removed Datasource and Dataset inf, as well as main body details, to get under the 60000 character limit on the post) The section of note is Subreport1 and Subreport5 <?xml version="1.0" encoding="utf-8"?><Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> <Body> <ReportItems> <Tablix Name="GroupLevel0"> <TablixBody> <TablixColumns> <TablixColumn> <Width>8.01475in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.51319in</Height> <TablixCells> <TablixCell> <CellContents> <Rectangle Name="Rectangle1"> <ReportItems> <Subreport Name="Subreport1"> <ReportName>Invoices_New_ExpenseRec</ReportName> <Parameters> <Parameter Name="InvoiceNUmber"> <Value>=Parameters!INvoiceNumber.Value</Value> </Parameter> </Parameters> <Top>0.04826in</Top> <Left>0.04697in</Left> <Height>0.41667in</Height> <Width>7.9208in</Width> <Style> <Border> <Style>None</Style> </Border> </Style> </Subreport> </ReportItems> <PageBreak> <BreakLocation>Start</BreakLocation> </PageBreak> <ZIndex>2</ZIndex> <Visibility> <Hidden>=First(Fields!ExpenseAmt.Value, "DataSet1")=0</Hidden> </Visibility> <Style> <Border> <Style>None</Style> </Border> </Style> </Rectangle> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <Group Name="Group3"> <GroupExpressions> <GroupExpression>InvoiceNumber</GroupExpression> </GroupExpressions> <PageBreak> <BreakLocation>Between</BreakLocation> </PageBreak> </Group> <SortExpressions> <SortExpression> <Value>InvoiceNumber</Value> </SortExpression> </SortExpressions> <TablixMembers> <TablixMember> <KeepWithGroup>After</KeepWithGroup> </TablixMember> <TablixMember> <Group Name="Group1"> <GroupExpressions> <GroupExpression>=Fields!ServiceLine.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>ServiceLine</Value> </SortExpression> </SortExpressions> <TablixMembers> <TablixMember /> <TablixMember> <Visibility> <Hidden>=Fields!ServiceLine.Value="Expenses"</Hidden> </Visibility> </TablixMember> <TablixMember> <Visibility> <Hidden>=Fields!ServiceLine.Value<>"Expenses"</Hidden> </Visibility> </TablixMember> <TablixMember> <Visibility> <Hidden>=(Fields!ServiceLine.Value<>"Coding") or (Fields!OnsiteMF.Value+Fields!RemoteMF.Value =0)</Hidden> </Visibility> </TablixMember> <TablixMember /> </TablixMembers> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DataSet1</DataSetName> <Left>0.03474in</Left> <Height>5.62376in</Height> <Width>8.01475in</Width> <Style /> </Tablix> </ReportItems> <Height>5.79985in</Height> <Style /> </Body> <ReportParameters> <ReportParameter Name="INvoiceNumber"> <DataType>String</DataType> <Prompt>Invoice Number</Prompt> </ReportParameter> </ReportParameters> <Width>8.04949in</Width> <Page> <PageHeader> <Height>1.0416in</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <Line Name="Line327"> <Top>1.0416in</Top> <Left>0.03474in</Left> <Height>0in</Height> <Width>7.9166in</Width> <Style> <Border> <Color>#000000</Color> <Style>Solid</Style> </Border> </Style> </Line> <Rectangle Name="Rectangle4"> <ReportItems> <Textbox Name="Label16"> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Invoice</Value> <Style> <FontStyle>Normal</FontStyle> <FontFamily>Franklin Gothic Book</FontFamily> <FontSize>26pt</FontSize> <FontWeight>Bold</FontWeight> <TextDecoration>None</TextDecoration> <Color>#000000</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> <LineHeight>33pt</LineHeight> </Style> </Paragraph> </Paragraphs> <Top>0.0416in</Top> <Left>5.6667in</Left> <Height>0.4166in</Height> <Width>2.0416in</Width> <Style> <Border> <Color>#000000</Color> </Border> <Direction>LTR</Direction> </Style> </Textbox> <Textbox Name="InvoiceNumber"> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!InvoiceNumber.Value</Value> <Style> <FontStyle>Normal</FontStyle> <FontFamily>Franklin Gothic Book</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>None</TextDecoration> <Color>#000000</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> <LineHeight>15pt</LineHeight> </Style> </Paragraph> </Paragraphs> <Top>0.4583in</Top> <Left>6.3334in</Left> <Height>0.18057in</Height> <Width>1.375in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Color>#000000</Color> </Border> <BackgroundColor>#ffffff</BackgroundColor> <Direction>LTR</Direction> </Style> </Textbox> <Image Name="Image325"> <Source>Embedded</Source> <Value>Image325</Value> <Sizing>Clip</Sizing> <Height>0.9583in</Height> <Width>4.4583in</Width> <ZIndex>2</ZIndex> <Style> <Border> <Color>#000000</Color> </Border> <BackgroundColor>#ffffff</BackgroundColor> </Style> </Image> <Textbox Name="Text338"> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!TotAmt.Value</Value> <Style> <FontStyle>Normal</FontStyle> <FontFamily>Franklin Gothic Book</FontFamily> <FontWeight>Bold</FontWeight> <Format>C</Format> <TextDecoration>None</TextDecoration> <Color>#000000</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>General</TextAlign> <LineHeight>15pt</LineHeight> </Style> </Paragraph> </Paragraphs> <Top>0.68054in</Top> <Left>6.71531in</Left> <Height>0.3055in</Height> <Width>1.01389in</Width> <ZIndex>3</ZIndex> <Style> <Border> <Color>#000000</Color> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> </BottomBorder> <LeftBorder> <Style>None</Style> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> </RightBorder> <BackgroundColor>#c0c0c0</BackgroundColor> <Direction>LTR</Direction> </Style> </Textbox> <Textbox Name="Label339"> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Total Amount Due:</Value> <Style> <FontStyle>Normal</FontStyle> <FontFamily>Franklin Gothic Book</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>None</TextDecoration> <Color>#000000</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Left</TextAlign> <LineHeight>15pt</LineHeight> </Style> </Paragraph> </Paragraphs> <Top>0.68054in</Top> <Left>4.8889in</Left> <Height>0.3055in</Height> <Width>1.82641in</Width> <ZIndex>4</ZIndex> <Style> <Border> <Color>#000000</Color> <Style>Solid</Style> </Border> <RightBorder> <Style>None</Style> </RightBorder> <BackgroundColor>#c0c0c0</BackgroundColor> <Direction>LTR</Direction> </Style> </Textbox> </ReportItems> <KeepTogether>true</KeepTogether> <Top>0.02778in</Top> <Left>0.03474in</Left> <Height>0.98604in</Height> <Width>7.7292in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Style>None</Style> </Border> </Style> </Rectangle> </ReportItems> <Style> <BackgroundColor>#ffffff</BackgroundColor> </Style> </PageHeader> <PageFooter> <Height>0.52778in</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <Textbox Name="PageNumber"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Page </Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> <TextRun> <Value>=Globals!PageNumber</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> <TextRun> <Value> of </Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> <TextRun> <Value>=Globals!TotalPages</Value> <Style> <FontSize>8pt</FontSize> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>PageNumber</rd:DefaultName> <Left>5.74304in</Left> <Height>0.21875in</Height> <Width>2.2292in</Width> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="Textbox9"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Questions? Contact us at or at</Value> <Style> <FontFamily>Franklin Gothic Book</FontFamily> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Center</TextAlign> </Style> </Paragraph> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Franklin Gothic Book</FontFamily> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox9</rd:DefaultName> <Top>0.01389in</Top> <Left>0.09724in</Left> <Height>0.22916in</Height> <Width>5.30031in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <Style> <Border> <Style>None</Style> </Border> </Style> </PageFooter> <Style /> </Page> <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace> <rd:ReportID>a6687dbf-b7d2-46b7-a40a-adc5d0228d78</rd:ReportID> <rd:ReportUnitType>Inch</rd:ReportUnitType></Report>

November 3rd, 2009 10:01am

Hi,You can use the List control instead of the Rectangle, and set the List control group expression =Nothing and set the "page break" before or after as you want.thanks,Jerry

Free Windows Admin Tool Kit Click here and download it now

November 5th, 2009 1:38am

Have tried this, and its not working still. I've created a very basic report that shows what I'm trying to do - I can't format it, because the formatting screws up the content (removes the second tablix) <?xml version="1.0" encoding="utf-8"?> <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> <DataSources> <DataSource Name="DataSource1"> <DataSourceReference>HIASQL</DataSourceReference> <rd:DataSourceID>072890fb-01c4-4bb8-a7cb-487e3434fa75</rd:DataSourceID> <rd:SecurityType>None</rd:SecurityType> </DataSource> </DataSources> <DataSets> <DataSet Name="DataSet1"> <Fields> <Field Name="InvoiceNumber"> <DataField>InvoiceNumber</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ClientNumber"> <DataField>ClientNumber</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CodingAmt"> <DataField>CodingAmt</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="ExpenseAmt"> <DataField>ExpenseAmt</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>DataSource1</DataSourceName> <CommandText>select InvoiceNumber,ClientNumber,CodingAmt,ExpenseAmt from Invoice_Header where InvoiceDate > '11/1/09'</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> </DataSets> <Body> <ReportItems> <Tablix Name="Tablix1"> <TablixBody> <TablixColumns> <TablixColumn> <Width>7.95205in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox22"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox22</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.51042in</Height> <TablixCells> <TablixCell> <CellContents> <Rectangle Name="Rectangle2"> <ReportItems> <Textbox Name="ClientNumber"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!ClientNumber.Value</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>ClientNumber</rd:DefaultName> <Left>0.22583in</Left> <Height>0.25in</Height> <Width>1in</Width> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="CodingAmt"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!CodingAmt.Value</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>CodingAmt</rd:DefaultName> <Top>0in</Top> <Left>1.66333in</Left> <Height>0.25in</Height> <Width>1in</Width> <ZIndex>1</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="ExpenseAmt"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!ExpenseAmt.Value</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>ExpenseAmt</rd:DefaultName> <Top>0in</Top> <Left>3.11125in</Left> <Height>0.25in</Height> <Width>1in</Width> <ZIndex>2</ZIndex> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <KeepTogether>true</KeepTogether> <Style> <Border> <Style>None</Style> </Border> </Style> </Rectangle> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.95834in</Height> <TablixCells> <TablixCell> <CellContents> <Tablix Name="Tablix3"> <TablixBody> <TablixColumns> <TablixColumn> <Width>7.95205in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.95834in</Height> <TablixCells> <TablixCell> <CellContents> <Subreport Name="Subreport5"> <ReportName>Invoices_MinimumFees-new</ReportName> <Parameters> <Parameter Name="INvoiceNumber"> <Value>=Fields!InvoiceNumber.Value</Value> </Parameter> </Parameters> <Style> <Border> <Style>None</Style> </Border> </Style> </Subreport> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember> <Group Name="Details1" /> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <PageBreak> <BreakLocation>Start</BreakLocation> </PageBreak> <Filters> <Filter> <FilterExpression>=Fields!InvoiceNumber.Value</FilterExpression> <Operator>Equal</Operator> <FilterValues> <FilterValue>=Fields!InvoiceNumber.Value</FilterValue> </FilterValues> </Filter> </Filters> <Style> <Border> <Style>None</Style> </Border> </Style> </Tablix> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <Group Name="Group2"> <GroupExpressions> <GroupExpression>=Fields!InvoiceNumber.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!InvoiceNumber.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>0.03125in</Size> <CellContents> <Textbox Name="Group2"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Group2</rd:DefaultName> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <KeepWithGroup>After</KeepWithGroup> </TablixMember> <TablixMember> <Group Name="Details" /> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DataSet1</DataSetName> <Top>0.00708in</Top> <Height>1.71875in</Height> <Width>7.9833in</Width> <Style> <Border> <Style>None</Style> </Border> </Style> </Tablix> </ReportItems> <Height>1.72584in</Height> <Style /> </Body> <Width>7.9833in</Width> <Page> <LeftMargin>1in</LeftMargin> <RightMargin>1in</RightMargin> <TopMargin>1in</TopMargin> <BottomMargin>1in</BottomMargin> <Style /> </Page> <rd:ReportID>2a323c55-852f-4cf1-a50b-a619c1e2348a</rd:ReportID> <rd:ReportUnitType>Inch</rd:ReportUnitType> </Report>

November 18th, 2009 12:09pm

You should try putting the page break on the group itself rather than the rectangle.JS

Free Windows Admin Tool Kit Click here and download it now

August 12th, 2012 1:11pm

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