Report losing data when exported

[BigChris]

Hi Folks,

I hope this is something simple, but at the moment I'm baffled. I've got a report that runs exactly as it should when I run it screen in HTML. When I export it to either PDF or Excel it loses data from the report. To prove it I filtered the report down to a single record. Everything is fine in HTML, but when I export it the output is blank.

If I take the filter off and run the report again I get more data, including the required record, but again it's missing when I export it.

Any thoughts or suggestions?

[Andrei I]

Can you run/save the report as HTML in background ?
Can you export any report to Excel/Pdf in this environment?
Can you record the SQL your report is generating for both HTML and Excel rendering?