Print Page | Close Window

Crystal Reports export with formalus

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22695
Printed Date: 25 Apr 2024 at 3:22am


Topic: Crystal Reports export with formalus
Posted By: hcdc
Subject: Crystal Reports export with formalus
Date Posted: 07 Nov 2018 at 9:52am
I am exporting crystal reports data to excel 2013 spreadsheet. I have 'sum' subtotal, and total formulas in crystal. When I export to Excel, all those formulas turns into fixed number. I would like to export the data as is with formulas. Can you I get some help to do this please. Thank you.



Replies:
Posted By: kevlray
Date Posted: 08 Nov 2018 at 4:11am
Not possible for any export for Crystal Reports.  For one thing the formula sum in Crystal Reports would not translate properly into Excel.  The closest you could  do is create a text box with the 'formula' in text form.  Of course Excel would probably still treat it as a string.



Print Page | Close Window