Columns dont line up.

J

Joel

I have 6 columns in my report going Down, then Across. I have the IspID
header that shows the Inspection name and in the detals section I have the
UnitID.
When the list of UnidID's are larger than the page they make a new column
but they start at the same hight as the IspID header.
If I click on the IspID header properties and turn on repeat section it and
the Inspection name again (which I dont want) but it makes the UnitID line up
right.

Any ideas on how to make the UnitID's line up under the InspID header
without using repeat section?

Thanks.
 
M

Marshall Barton

Joel said:
I have 6 columns in my report going Down, then Across. I have the IspID
header that shows the Inspection name and in the detals section I have the
UnitID.
When the list of UnidID's are larger than the page they make a new column
but they start at the same hight as the IspID header.
If I click on the IspID header properties and turn on repeat section it and
the Inspection name again (which I dont want) but it makes the UnitID line up
right.

Any ideas on how to make the UnitID's line up under the InspID header
without using repeat section?
Click to expand...


The way to get the group header to span the width of the
report is to make the report a single column. Change the
report's record source query to exclude the detail data so
it only has a single record for each IspID and drop the
grouping on that field.

Then, create a query for the detail data and use that as the
record source for a multi-column subreport. Add the
subreport to the main report's detail section along with the
IspID text box.
 
Top