Welcome to SPN

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

Sign Up Now!

Organizing Data on 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...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    This has been answered in one of your other posts.

    --
    Rick B



    "Marcel Stoop" <marcel.stoop@freesurf.ch> wrote in message
    news:%23xl4E6u3FHA.3976@TK2MSFTNGP15.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
    >
    >
     
  4. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    .... which he couldn't see because it was date for 2007 and the post
    disappeared into the future ...

    --
    Van T. Dinh
    MVP (Access)



    "Rick B" <Anonymous> wrote in message
    news:ua48b$u3FHA.1184@TK2MSFTNGP12.phx.gbl...
    > This has been answered in one of your other posts.
    >
    > --
    > Rick B
    >
    >
    >
    > "Marcel Stoop" <marcel.stoop@freesurf.ch> wrote in message
    > news:%23xl4E6u3FHA.3976@TK2MSFTNGP15.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
    >>
    >>

    >
    >
     

Share This Page