Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Creating a Report

Discussion in 'Information Technology' started by Marcel Stoop, Nov 2, 2005.

  1. Marcel Stoop

    Marcel Stoop
    Expand Collapse
    Guest

    Hi everyone

    My Report retrieves data from a specific MS SQL Table. The report is
    filtered by a SQL Statement.
    The Data within that Table can be defined into 3 sub-categories; say
    Material A, Material B, Material C

    My Question is:
    Is it possible to tell the Report to start a new Page as soon as data from
    the next category appears. So, as soon as all the Data concerning Material A
    has been retrieved and put into the report, the report should start a new
    page for Material B.

    Thanks for the help

    Marcel
     
  2. Loading...

    Similar Threads Forum Date
    Canada Ottawa weighs creating ambassador for religious freedom Breaking News Oct 4, 2011
    India SGPC Accused of Creating a Row Breaking News Jan 20, 2011
    Pacific International Gathering of Young Sikhs Focuses on Creating Good Citizens Breaking News Jan 8, 2011
    Are We Creating New Devtas? Sikh Sikhi Sikhism Aug 21, 2009
    Sikh News Sharif warns against creating instability in Punjab (Express India) Breaking News Sep 19, 2008

  3. Dennis

    Dennis
    Expand Collapse
    Guest

    Assuming you have the material in a sorting/grouping section, then look at
    the properties of the section. There is a 'force new page' property. Set this
    to After section and you should get each material details on a separate page.

    "Marcel Stoop" wrote:

    > Hi everyone
    >
    > My Report retrieves data from a specific MS SQL Table. The report is
    > filtered by a SQL Statement.
    > The Data within that Table can be defined into 3 sub-categories; say
    > Material A, Material B, Material C
    >
    > My Question is:
    > Is it possible to tell the Report to start a new Page as soon as data from
    > the next category appears. So, as soon as all the Data concerning Material A
    > has been retrieved and put into the report, the report should start a new
    > page for Material B.
    >
    > Thanks for the help
    >
    > Marcel
    >
    >
    >
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Just to piggy-back on Dennis's post, if you want the data sorted, you MUST
    use the Sorting/Grouping feature in the report. Reports don't respect the
    underlying order of their recordsources.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Dennis" <Dennis@discussions.microsoft.com> wrote in message
    news:FC98816A-C226-4737-88C4-2946D254B75A@microsoft.com...
    > Assuming you have the material in a sorting/grouping section, then look at
    > the properties of the section. There is a 'force new page' property. Set

    this
    > to After section and you should get each material details on a separate

    page.
    >
    > "Marcel Stoop" wrote:
    >
    > > Hi everyone
    > >
    > > My Report retrieves data from a specific MS SQL Table. The report is
    > > filtered by a SQL Statement.
    > > The Data within that Table can be defined into 3 sub-categories; say
    > > Material A, Material B, Material C
    > >
    > > My Question is:
    > > Is it possible to tell the Report to start a new Page as soon as data

    from
    > > the next category appears. So, as soon as all the Data concerning

    Material A
    > > has been retrieved and put into the report, the report should start a

    new
    > > page for Material B.
    > >
    > > Thanks for the help
    > >
    > > Marcel
    > >
    > >
    > >
     
  5. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    If you wait until 2007, everything will be done automatically for you ...

    --
    Van T. Dinh
    MVP (Access)



    "Marcel Stoop" <marcel.stoop@freesurf.ch> wrote in message
    news:%23KvI1Ws3FHA.3296@TK2MSFTNGP09.phx.gbl...
    > Hi everyone
    >
    > My Report retrieves data from a specific MS SQL Table. The report is
    > filtered by a SQL Statement.
    > The Data within that Table can be defined into 3 sub-categories; say
    > Material A, Material B, Material C
    >
    > My Question is:
    > Is it possible to tell the Report to start a new Page as soon as data from
    > the next category appears. So, as soon as all the Data concerning Material
    > A
    > has been retrieved and put into the report, the report should start a new
    > page for Material B.
    >
    > Thanks for the help
    >
    > Marcel
    >
    >
     
  6. Bob Miller

    Bob Miller
    Expand Collapse
    Guest

    If Material A, etc. is a value in a field e.g Material, then you can
    group on Material and in the Group Header properties set it to Force
    New Page Before Section.
    Marcel Stoop Wrote:
    > Hi everyone
    >
    > My Report retrieves data from a specific MS SQL Table. The report is
    > filtered by a SQL Statement.
    > The Data within that Table can be defined into 3 sub-categories; say
    > Material A, Material B, Material C
    >
    > My Question is:
    > Is it possible to tell the Report to start a new Page as soon as data
    > from
    > the next category appears. So, as soon as all the Data concerning
    > Material A
    > has been retrieved and put into the report, the report should start a
    > new
    > page for Material B.
    >
    > Thanks for the help
    >
    > Marcel



    --
    Bob Miller
     

Share This Page