COnfiguring Number of records per page?

Hot Topic

SSAS 2005 : Calculated member in parent-child dimension
Any examples of a invoice report?
Dataset Filtering Not Working
Parametrized Report with Analysis Services didn't work
SSIS setup for team work
Service Broker Tables
Background Color for SQL Server Management Console
Cannot connect studio to my SQL Server Express Database
TimeOut error with SQL Server 2005 RTM version
cannot login

SQL Server

Packages not executing right on production server?
Restore Analysis Backup to new DAtabase Name
Unable to install SQL Server 2005 September CTP
Help! hresult DTS_E_VARIABLEALREADYONREADLIST
How Can I use this code for Primary Key autogeneration
Aggregation Design Wizard: functionality questions
performance of indexed views
Deleting Reports in Report Server without stopping Report Service
Removing Databases
Error when using VariableDispenser in a custom task.

COnfiguring Number of records per page?

Is there a way I can specify how many records per page should be displayed > This is a very basic functionality that needs to go in the deployment at any cost for us ...any ideas.

thanks


Answer this question

COnfiguring Number of records per page?

  • roeschda

    Here's a working example. The attached report has a self contained dataset and the same table twice, once using a list control with groupping applied. Hope this helps.

    < xml version="1.0" encoding="utf-8" >
    <Report xmlns="    http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
    <DataSources>
    <DataSource Name="master">
    <ConnectionProperties>
    <IntegratedSecurity>true</IntegratedSecurity>
    <ConnectString>Data Source=.;Initial Catalog=master</ConnectString>
    <DataProvider>SQL</DataProvider>
    </ConnectionProperties>
    <rd:DataSourceID>2dd60f19-bf57-4e66-80c3-288d239d3f80</rd:DataSourceID>
    </DataSource>
    </DataSources>
    <BottomMargin>2.5cm</BottomMargin>
    <RightMargin>2.5cm</RightMargin>
    <PageWidth>21cm</PageWidth>
    <rd:DrawGrid>true</rd:DrawGrid>
    <InteractiveWidth>21cm</InteractiveWidth>
    <rd:GridSpacing>0.25cm</rd:GridSpacing>
    <rd:SnapToGrid>true</rd:SnapToGrid>
    <Body>
    <ColumnSpacing>1cm</ColumnSpacing>
    <ReportItems>
    <Table Name="table2">
    <Footer>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox11">
    <ZIndex>5</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>Total</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox12">
    <ZIndex>4</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!balance.Value)</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox13">
    <ZIndex>3</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!prior_balance.Value)</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox14">
    <ZIndex>8</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>exc accts</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox15">
    <ZIndex>7</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox16">
    <ZIndex>6</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox17">
    <ZIndex>11</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>Final</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox18">
    <ZIndex>10</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox19">
    <ZIndex>9</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Footer>
    <Left>10cm</Left>
    <DataSetName>DataSet1</DataSetName>
    <Top>1.25cm</Top>
    <ZIndex>1</ZIndex>
    <Details>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox20">
    <ZIndex>2</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!account.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox21">
    <ZIndex>1</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!balance.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox22">
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!prior_balance.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Details>
    <Header>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox23">
    <ZIndex>14</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>account</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox24">
    <ZIndex>13</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>balance</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox25">
    <ZIndex>12</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>prior balance</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Header>
    <TableColumns>
    <TableColumn>
    <Width>2cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>1.75cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>2.75cm</Width>
    </TableColumn>
    </TableColumns>
    <Height>3.1746cm</Height>
    </Table>
    <List Name="list1">
    <Left>2.25cm</Left>
    <ReportItems>
    <Table Name="table1">
    <Footer>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox7">
    <rd:DefaultName>textbox7</rd:DefaultName>
    <ZIndex>5</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>Total</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="balance_1">
    <rd:DefaultName>balance_1</rd:DefaultName>
    <ZIndex>4</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!balance.Value)</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="prior_balance_1">
    <rd:DefaultName>prior_balance_1</rd:DefaultName>
    <ZIndex>3</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!prior_balance.Value)</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox4">
    <rd:DefaultName>textbox4</rd:DefaultName>
    <ZIndex>8</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>exc accts</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox5">
    <rd:DefaultName>textbox5</rd:DefaultName>
    <ZIndex>7</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox6">
    <rd:DefaultName>textbox6</rd:DefaultName>
    <ZIndex>6</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox8">
    <rd:DefaultName>textbox8</rd:DefaultName>
    <ZIndex>11</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>Final</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox9">
    <rd:DefaultName>textbox9</rd:DefaultName>
    <ZIndex>10</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox10">
    <rd:DefaultName>textbox10</rd:DefaultName>
    <ZIndex>9</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Footer>
    <DataSetName>DataSet1</DataSetName>
    <Top>0.75cm</Top>
    <Details>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="account">
    <rd:DefaultName>account</rd:DefaultName>
    <ZIndex>2</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!account.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="balance">
    <rd:DefaultName>balance</rd:DefaultName>
    <ZIndex>1</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!balance.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="prior_balance">
    <rd:DefaultName>prior_balance</rd:DefaultName>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Right</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>=Fields!prior_balance.Value</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Details>
    <Header>
    <TableRows>
    <TableRow>
    <TableCells>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox1">
    <rd:DefaultName>textbox1</rd:DefaultName>
    <ZIndex>14</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>account</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox2">
    <rd:DefaultName>textbox2</rd:DefaultName>
    <ZIndex>13</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>balance</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    <TableCell>
    <ReportItems>
    <Textbox Name="textbox3">
    <rd:DefaultName>textbox3</rd:DefaultName>
    <ZIndex>12</ZIndex>
    <Style>
    <BorderStyle>
    <Default>Solid</Default>
    </BorderStyle>
    <TextAlign>Center</TextAlign>
    <PaddingLeft>2pt</PaddingLeft>
    <PaddingBottom>2pt</PaddingBottom>
    <PaddingRight>2pt</PaddingRight>
    <PaddingTop>2pt</PaddingTop>
    </Style>
    <CanGrow>true</CanGrow>
    <Value>prior balance</Value>
    </Textbox>
    </ReportItems>
    </TableCell>
    </TableCells>
    <Height>0.63492cm</Height>
    </TableRow>
    </TableRows>
    </Header>
    <TableColumns>
    <TableColumn>
    <Width>2cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>1.75cm</Width>
    </TableColumn>
    <TableColumn>
    <Width>2.75cm</Width>
    </TableColumn>
    </TableColumns>
    </Table>
    </ReportItems>
    <Top>0.5cm</Top>
    <Width>6.5cm</Width>
    <Grouping Name="list1_Details_Group">
    <GroupExpressions>
    <GroupExpression>=Ceiling(RowNumber(Nothing)/2)</GroupExpression>
    </GroupExpressions>
    </Grouping>
    <Height>3.9246cm</Height>
    </List>
    </ReportItems>
    <Height>5.4246cm</Height>
    </Body>
    <rd:ReportID>2e9a4c57-83bc-4a17-9dcd-287d47e72e3d</rd:ReportID>
    <LeftMargin>2.5cm</LeftMargin>
    <DataSets>
    <DataSet Name="DataSet1">
    <Query>
    <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
    <CommandText>select 'A' as account, 1 as type, 10 as balance, 5 as prior_balance
    union
    select 'B', 2, 4, 8
    union
    select 'C', 1, 7, 6
    union
    select 'D', 2, 9, 12</CommandText>
    <DataSourceName>master</DataSourceName>
    </Query>
    <Fields>
    <Field Name="account">
    <rd:TypeName>System.String</rd:TypeName>
    <DataField>account</DataField>
    </Field>
    <Field Name="type">
    <rd:TypeName>System.Int32</rd:TypeName>
    <DataField>type</DataField>
    </Field>
    <Field Name="balance">
    <rd:TypeName>System.Int32</rd:TypeName>
    <DataField>balance</DataField>
    </Field>
    <Field Name="prior_balance">
    <rd:TypeName>System.Int32</rd:TypeName>
    <DataField>prior_balance</DataField>
    </Field>
    </Fields>
    </DataSet>
    </DataSets>
    <Width>16.5cm</Width>
    <InteractiveHeight>29.7cm</InteractiveHeight>
    <Language>en-US</Language>
    <TopMargin>2.5cm</TopMargin>
    <PageHeight>29.7cm</PageHeight>
    </Report>



  • PravinD

    hi there. i encountered the same problem, and i tired doing what you said, applying it to a table.

    however, it does the same thing. it only displays the first record out of 20


  • Wizard_SHill

    Assuming you display your data in a list or a table, you could add a grouping expression like this: =Ceiling(RowNumber(Nothing)/20)
    This will cause the list/table to group on every 20 rows. On the grouping dialog, select to add a page break on every group and you should get the desired result.

    -- Robert


  • Mark Phelps

    I want to display more records in one page
    however, it seems at most display 55 records per page
    Is it right If so, how to change that Thanks

  • Jackey Cheung

    Hi.

    I have a report containing a table and a subreport following the table. If there is enough space (if the table has less records at that page), I want the table and the subreport to be on the same page.But if there is not enough space , I want the following subreport to be on the next page.

    How can I do this

    Note: The subreport may only be on the last page.

    Any help would be appreciated.

  • ruben@usa

    Thanks Robert. This is what happened:

    If there were 60 records returned, I got 3 pages (which i want) but on every page you could only see the top record

    I clicked

    List --> Properties --->Edit Details Group

    In the Group On dialog box, I inserted :
    =Ceiling(RowNumber(Nothing)/20)

    Any ideas on that

    Thanks.

  • Harel Moshe

    How about in a Matrix

  • lgemcor

    Instead of a list, use a table and add a grouping the same way. The table detail rows should then show 20 records each.

     

    -- Robert



  • COnfiguring Number of records per page?
Answer this question