I have a report where the main report has no tables. Then I add in 8 subreports.
When previewing the report, everything looks fine, but when I export to MS-Excel, a field that doesn't even exist in the main report (no tables) and cannot be found/seen/seleted, appears in the exported data. I've tried everything I can think of to get rid of it. The closest I've gotten is to squish all my data to the left so that the phantom field appears on the right as the last column. My subreports have many manual running totals, running totals and formula fields that do have the field that is phantoming in the main report.
Any ideas would be greatly appreciated.