• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

Hidden formula field in Crystal Reports - Make it visible only when exporting to Excel

In my Crystal Reports, I want to add a formula field - but I don't want it to be visible in the report itself, I want it to be visible only when I export to Excel.

Is this possible?
1 Solution
If you suppress it in CR it will not be exported.
You can set the font to white on white in CR and it will then get exported but in XL you will have to reformat it to make it visible.
Change you page layout from Portrait to Landscape or from Letter to 11x17, so that you have a larger area to layout your fields.  Place the hidden field and its label off to the right of where your regular page margin will be.  Then change your layout back.  The fields will float out there in oblivion unseen, until you export to Excel.  Voila.
MIKESoftware Solutions ConsultantCommented:

      : )


Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now