FinanciallyFree
asked on
Access97 Subreport Not Printing on Same Page
I have a report with a subreport. The report has a ItemID header band, followed by a MeetingID header band, then a Detail band. The detail will not begin printing on the same page as the MeetingID data. It starts on the next page and continues until the next MeetingID. That next MeetingID data prints just a bit below the last record in the detail area (just as it should), then it's blank on the rest of that page with the detail area for that MeetingID starting on the next page. I have the following settings that may pertain to the problem:
Sorting & Grouping:
ItemID - Keep Together=No
MeetingID - Keep Together=No
Subreport Properties:
Can Shrink=Yes
Can Grow=Yes
What am I missing?
Sorting & Grouping:
ItemID - Keep Together=No
MeetingID - Keep Together=No
Subreport Properties:
Can Shrink=Yes
Can Grow=Yes
What am I missing?
Have you tried setting the MeetingID header's KeepTogether property to Yes?
I'd also inspect the "Force New Page" property of the detail section.
it should be "None"
ASKER
mgrattan:
I tried setting the MeetingID header to Keep Together = Yes and it made no difference.
maatthias:
I double-checked the "Force New Page" property and it is set to None.
Something I thought was weird/interesting... I played with the Sorting & Grouping window Keep Together settings. When MeetingID is set to No, I get the results I described in my original question. When it is set to Whole Group or With First Detail, the ItemID data is printed on page one (about 3 lines of text), the MeetingID data is printed on page two, then the detail data is started on page three. At least with it set to No, I get the ItemID and MeetingID data on the same page... Hmmm...
I tried setting the MeetingID header to Keep Together = Yes and it made no difference.
maatthias:
I double-checked the "Force New Page" property and it is set to None.
Something I thought was weird/interesting... I played with the Sorting & Grouping window Keep Together settings. When MeetingID is set to No, I get the results I described in my original question. When it is set to Whole Group or With First Detail, the ItemID data is printed on page one (about 3 lines of text), the MeetingID data is printed on page two, then the detail data is started on page three. At least with it set to No, I get the ItemID and MeetingID data on the same page... Hmmm...
Interesting.....I will look at it for you if you email a copy to me. outuvtime "at" yahoo.com. Make sure it's compacted and/or zipped to less than 5mb.
ASKER
mgrattan:
I was modifying the 9+mb database to send to you and the report works fine. Of course, the detail section was reduced from probably 250 records to about 10. Now it prints on the same page.
I'll send it to you anyway. Thank you!!
I was modifying the 9+mb database to send to you and the report works fine. Of course, the detail section was reduced from probably 250 records to about 10. Now it prints on the same page.
I'll send it to you anyway. Thank you!!
OK, I'll take a look at it probably on Monday since I'll be out of town this weekend and you won't be back in the office until Tuesday according to your email.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AWESOME! Your direction on moving the subreport to the header was my key! Thank you so much! My client is happy once again!
You're welcome!