Report Question

D

DavidW

I have got a very short report
in the detail it is only 5 lines long
how do you make the detail area equal your report instead of it filling the
detail area the entire length of the sheet.example

line1
line2
line3
line4
line5
then stop, instead of
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5

thanks
david
 
M

Marshall Barton

DavidW said:
I have got a very short report
in the detail it is only 5 lines long
how do you make the detail area equal your report instead of it filling the
detail area the entire length of the sheet.example

line1
line2
line3
line4
line5
then stop, instead of
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
line1
line2
line3
line4
line5
Click to expand...


That's confusing. Are Line1, 2, ... controls in the report
or are they supposed to represent records in the report's
record source?

Is there a subreport involved?

What is the record source for the report?

If it's a table or a query, open it from the database window
and check if the report is displaying the same data.
 
F

Fons Ponsioen

I suspect you have the report based on a query, and I
suspect the query is the cause of the repetition of the
data.
Look first at the underlying query in design view and than
run the query and see what the result is.
If, as I suspect the query repeats the data you may want
to look at the query design to eliminate the duplication
or otherwiase set possibly the property of the query to
show unique values only.
Hope this helps.
Fons
 
Top