Welcome to SPN

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

Sign Up Now!

Report Help

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

Tags:
  1. Dan Sweetwood

    Dan Sweetwood
    Expand Collapse
    Guest

    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. xRoachx

    xRoachx
    Expand Collapse
    Guest

    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
     

Share This Page