Unusual report - help?

[Guest]

I have a report to do that has multiple lines of detail for each of several
sub-headings. The report is laid out as follows:

Admissions
Name Date

 

[PC Datasheet]

You probably need a redesign of your tables!
Admissions and discharges should be in one table where a field designates
the record as an admission or discharge. In your report you would then group
on this field. Grievances/complaints would be in a table for these records
so in your report you would use a subreport for these records. Staff
meetings would have their own table so in your report you would use a
subreport for these records. Purchasing Card Issues, Computer Issues,
Business Office Issues and HR Issues records would all be in an issues table
with a field to designate the type of issue. You would use a subreport for
issues and in your subreport you would group on this field. Finally,
Physical Plant Comments would have their own table and you would use a
subreport for these records.

 

[John Spencer (MVP)]

Sounds as if you have somehow set the detail section to break after each line.
Check the Detail section's Force New Page Property on the Format Tab of the
properties sheet. It should read "None". Also check the New Row or Col property.

 

[Guest]

No, the detail settings are okay. And the data comes from separate tables and
is brought together via JOINs in the query. I'm stumped.

 

[Guest]

Try building the report using the Wizard and instead of a query...filter the
info for the report in the source control with an expression and then group
contents by sorting.may help you ..may be too long around