>hi all,
>I have aneed to have a long report, it will run over 2-3 pages so I can't use the page header and footer, also the detail is out as it will repeat fields, everything I do makes the page too long and I crash out of the application. any ideas?

Have look at www.report-sculptor.com
This is fairly easy.