One of the most common questions I get asked is how do I export reports to Microsoft Excel?
The reason for this is that depending on how the report has been designed in Crystal Reports, how many issues will be created on the export.
This is even more so when exporting a cross tab.
So I spent some time over the weekend having a look at this, and I stumbled across a little trick, that may make exporting Crystal Reports cross tabs into Excel a little easier.
Instead of Exporting the report to MS Excel, simply copy and paste it:
- Launch Crystal Reports
- Open the report
- Run the report
- In the Print Preview view, right click in the top left hand corner of the cross tab
- Select Copy
- Switch to Microsoft Excel
- Right click in cell A1
- Select Paste
- The data from the Crystal Reports cross tab should be copied into MS Excel
Note: This was done with Crystal Reports v11
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us