Report Help

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

 

[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?

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

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.

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.