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?
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?