Do the pages look like they have the have the same format or are they all individual layouts?
If the same it sounds a bit odd that your detail only selects from page 1.
If you take one component of the extraction at a time and prove that each part works on its own then, in theory, they should all work together.
It may be that your Page Header does not need to be a header but just an append. Before you created the header did you get a complete selection of the detail lines as you wish to select them?
I'll work on getting an example posted. There is a ton of information which might be considered "sensitive". /b[/quote]
So, ignoring the page header for now, how well can you 'map' the data, which I presume is the detail you require to extract, from page to page?
I am beginning to wonder if you have been thrown in at the deepest possible end of a problem here!
Seeing the report layout would help enormously.
The last time someone came up with a 3 page report having constant headers but different 'body' formats it was the result of a conversion from a 3 page .pdf file. I don't suppose this is from a similar source by any chance?
Appreciating that the data is sensitive do you or any of your colleagues have access to a sample version of the report with dummy or obsolete data?
Each page has the same header but different layouts. /b[/quote]