Skip to Content
avatar image
Former Member

Phantom Field appears in report w/8 subrfeports

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 04 at 01:10 PM

    There are a number of limitations in how Crystal exports to Excel - it especially has problems with exporting subreports cleanly.

    Are you seeing data that doesn't exist? Or is it just a blank column? Or is it a merged column?

    Can you post a screen shot of the design view of the main report?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03 at 10:51 PM

    I should also mention that I have started with numerous blank reports, but the phantom field always returns.

    Add comment
    10|10000 characters needed characters exceeded