Hello. This is my first post here. I am usually lucky with just googling my problem but I am having no success. My problem is this: I have a report that shows groups of procedure codes that belong to a larger family.
In general the report looks like this
Larger Family Information 1
Related Procedure Information A
Related Procedure Information B
Larger Family Information 2
Related Procedure Information A
Related Procedure Information B
Related Procedure Information C
And so on. What I want it is, if the related procedure information spills onto the next page, that the larger family information is repeated at the top of that page. So, I set the group header repeat section to yes. And now it repeats at the top of the page like I wanted. However, if the last line of the detail section is the last line of the page the group header repeats at the top of the next page, even though there is no more information. (Right now this is happening on page 3 or the report.)
I have attached a clean version of the database with just the problematic report and its underlying table.
I would greatly appreciate any incite. I have tapped my resources here.