on 04-13-2009 5:25 PM
Hello Crystal Experts!
When I export my crystal report to Excel from the Crystal Viewer, it flips some number signs to negative. I suspect it's happening because I am using 'Reverse sign for Display' number format option. What can be done to get the matching results in Crystal and in Excel?
Thank you!
Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tanya,
Try to export into Excel Data Only option. This will only take few formatting options from crystal reports.
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you have Crystal Designer in your machine? If so then open the report in Crystal Designer and try exporting to Excel Data only by selecting the option "Export Object Formatting" and see the output. If it gives the desired output then click on file>Export>report export options-->select Excel data only -->select the option Export Object Formatting and save the report that saves these export option. Now try to open the report in Crystal Viewer and check the report by exporting to excel data only.
Regards,
Raghavendra
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.