Hi,
Is there anyway to have a duplicate DETAIL area on a report?
I note that the report can have several Header and Footers but only one detail.
I have a report that is grouped by name and can have say multiple listings of something. The name is the top header, and the detail shows the listings for the name. Below that in the Name Footer I have additional data that has to remain on page 1.
The problem is if the Owner has more than 10 listings it forces all of the data in the Name Footer to a new page.
What I want to do is if the detail area has <10 listings, show a label that says "Please See Page 2" for the listings and keep all of the information that is in the Name Footer on page one while listing all of the listings on page 2.
I realize this may be a stretch but I cannot seem to figure out a decent way to do it.
Does anyone know of a way to accomplish this?
Thanks.
Fen How
Is there anyway to have a duplicate DETAIL area on a report?
I note that the report can have several Header and Footers but only one detail.
I have a report that is grouped by name and can have say multiple listings of something. The name is the top header, and the detail shows the listings for the name. Below that in the Name Footer I have additional data that has to remain on page 1.
The problem is if the Owner has more than 10 listings it forces all of the data in the Name Footer to a new page.
What I want to do is if the detail area has <10 listings, show a label that says "Please See Page 2" for the listings and keep all of the information that is in the Name Footer on page one while listing all of the listings on page 2.
I realize this may be a stretch but I cannot seem to figure out a decent way to do it.
Does anyone know of a way to accomplish this?
Thanks.
Fen How