Paul,

I figured out what was wrong with my Crystal Report. The tables and links were different between the main report and subreport after I added and took away a table from each and did Auto-arrange tables in the Database Links window. That table manipulation really messed up the Crystal Report and caused the report to generate 1000+ pages all the same, repeating.

Thanks for your suggestion. I did not need it this time, but I will remember it for next time I have problem I cannot figure out. Have a great one!