Welcome to SPN

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

Sign Up Now!

RE: Report Help

Discussion in 'Information Technology' started by xRoachx, Nov 17, 2005.

Tags:
  1. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Hey Dan, give this a shot: Check the format tab for the detail properties of
    the report. Make sure the Force New Page is equal to none.

    "Dan Sweetwood" wrote:

    > I have a report that is supposed to be only one page showing the room, beds
    > for
    > the facility which are occupied and which are empty. The report shows the
    > room and bed number information in labels with the related info from
    > expressions.
    > Example:
    > Room # Bed # Patient Name
    > B1-1 1 =iif([RoomNo]="B1-1" and [BedNo]="1",
    > [firstname]&" "&[lastname],"")
    > 2 =iif([RoomNo]="B1-1" and [BedNo]="2",
    > [firstname]&" "&[lastname],"")
    >
    > The expression works except that it prints only one patient per page. The
    > query shows the correct information. How do I solve getting it to a one page
    > report? Your help will be greatly appreciated.
    > --
    >
    > Dan S
    >
    > --
    > Dan S
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Dan Sweetwood

    Dan Sweetwood
    Expand Collapse
    Guest

    Thanks for the info. All the sections check out fine fo the new page. There
    is no sorting or grouping other than a simple sort in the query which is to
    alpha the last names. Can you think of anything else?
    --
    Dan S


    "xRoachx" wrote:

    > Check the other sections as well for this property. If it's not one of
    > these, then it must be grouping. To check this, go to view, then Sorting and
    > Grouping. What are these settings?
    >
    > "Dan Sweetwood" wrote:
    >
    > > The forced new page is set to none. Any other ideas? I am in real need of
    > > your help. Thanks
    > > --
    > > Dan S
    > >
    > >
    > > "xRoachx" wrote:
    > >
    > > > Hey Dan, give this a shot: Check the format tab for the detail properties of
    > > > the report. Make sure the Force New Page is equal to none.
    > > >
    > > > "Dan Sweetwood" wrote:
    > > >
    > > > > I have a report that is supposed to be only one page showing the room, beds
    > > > > for
    > > > > the facility which are occupied and which are empty. The report shows the
    > > > > room and bed number information in labels with the related info from
    > > > > expressions.
    > > > > Example:
    > > > > Room # Bed # Patient Name
    > > > > B1-1 1 =iif([RoomNo]="B1-1" and [BedNo]="1",
    > > > > [firstname]&" "&[lastname],"")
    > > > > 2 =iif([RoomNo]="B1-1" and [BedNo]="2",
    > > > > [firstname]&" "&[lastname],"")
    > > > >
    > > > > The expression works except that it prints only one patient per page. The
    > > > > query shows the correct information. How do I solve getting it to a one page
    > > > > report? Your help will be greatly appreciated.
    > > > > --
    > > > >
    > > > > Dan S
    > > > >
    > > > > --
    > > > > Dan S
     
  4. Dan Sweetwood

    Dan Sweetwood
    Expand Collapse
    Guest

    The forced new page is set to none. Any other ideas? I am in real need of
    your help. Thanks
    --
    Dan S


    "xRoachx" wrote:

    > Hey Dan, give this a shot: Check the format tab for the detail properties of
    > the report. Make sure the Force New Page is equal to none.
    >
    > "Dan Sweetwood" wrote:
    >
    > > I have a report that is supposed to be only one page showing the room, beds
    > > for
    > > the facility which are occupied and which are empty. The report shows the
    > > room and bed number information in labels with the related info from
    > > expressions.
    > > Example:
    > > Room # Bed # Patient Name
    > > B1-1 1 =iif([RoomNo]="B1-1" and [BedNo]="1",
    > > [firstname]&" "&[lastname],"")
    > > 2 =iif([RoomNo]="B1-1" and [BedNo]="2",
    > > [firstname]&" "&[lastname],"")
    > >
    > > The expression works except that it prints only one patient per page. The
    > > query shows the correct information. How do I solve getting it to a one page
    > > report? Your help will be greatly appreciated.
    > > --
    > >
    > > Dan S
    > >
    > > --
    > > Dan S
     

Share This Page