Joined: 07 Mar 2017
Online Status: Offline
Posts: 1
Topic: Crystal Reports export with formalus 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.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum