I have a Crystal Report (8.5) that generates an invoice report (lots of numbers, calculations, formulas, etc.) When I export it to Excel (doesn't matter which version of Excel), it decides to change some of the invoice totals, for no apparent reason. There is no pattern that it follows when doing this (for example, it "thinks" that $6,750.00 - $3,375.00 = $7,225.00, whereas the total in the .rpt file is $3,375.00)
I didn't think an export was supposed to change any of the data - isn't it just supposed to take a snapshot of the .rpt file?
Has anyone else ever encountered this and is there a "workaround"?
Thank you.
I didn't think an export was supposed to change any of the data - isn't it just supposed to take a snapshot of the .rpt file?
Has anyone else ever encountered this and is there a "workaround"?
Thank you.