Welcome to SPN

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

Sign Up Now!

Report expression giving one record per page

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

  1. Dan Sweetwood

    Dan Sweetwood
    Expand Collapse
    Guest

    I have a report 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
     
  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. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Do you have groups in your report? If so check the Force New Page property

    Sheila

    "Dan Sweetwood" wrote:

    > I have a report 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
     

Share This Page