<< Sounds like pulling from a view creates a new hidden temporary table each time the view is hit. >>
That must be happening, although I would have thought that after each detail section was printed the hidden temp table would be deleted. << Creating a temporary table one time is more efficient. I’ll bet your report runs a lot faster. >> No, projecting the views out to the temporary tables then printing the report is no faster than printing the report (at least the first 90 pages or so) from the view. But it's more reliable! -- Larry
