I've created a report based upon an underlying query. This query outputs the top 5 records based upon descending date.
However I have a small formatting problem. Each group of records for a particular date is printing on a separate page. How do I make sure that all 5 records fit on a page?
To explain that better:
Present Report format
(page 1)
Date 08/26/02
Shift 1
Crew Q
Speed 300
.
.
.
(page 2)
Date 08/15/02
Shift 2
Crew P
Speed 290
.
.
.
(page 3)
Date 08/07/02
Shift 3
Crew R
Speed 320
.
.
.
Desired Report Format
Date 08/26/02 08/15/02 08/07/02
Shift 2 1 3
Crew P Q R
Speed 290 300 320
.
.
.
However I have a small formatting problem. Each group of records for a particular date is printing on a separate page. How do I make sure that all 5 records fit on a page?
To explain that better:
Present Report format
(page 1)
Date 08/26/02
Shift 1
Crew Q
Speed 300
.
.
.
(page 2)
Date 08/15/02
Shift 2
Crew P
Speed 290
.
.
.
(page 3)
Date 08/07/02
Shift 3
Crew R
Speed 320
.
.
.
Desired Report Format
Date 08/26/02 08/15/02 08/07/02
Shift 2 1 3
Crew P Q R
Speed 290 300 320
.
.
.
