Tips to Export Crystal Report (.rpt) to Excel
Tips to achieve the same report structure when you export into Excel:
Following points will help to avoid the unwanted cell spaces and formatting issue while exporting .rpt file to Excel files.
- Remove unwanted sections in the report. If the sections are not used either suppress or delete it.
- Avoid more spaces between each object. For example if you have more space between each objects then when you are export to excel, the space will be considered as each cells & the data will be shifted randomly. To avoid the cells shifting, insert the blank text objects in between the objects.
- Even for the small space try to insert the blank text objects.
- For conditional objects try to create in the different sections.
– For example I have condition to display two fields i.e. Grade A and Grade B based on revenue value.
– If revenue is more than 60000 then we need to display Grade A field else Grade B. This condition we need to give at 2 objects suppression formula.
– In this case the .rpt file will display only one field object at report. But when you export to excel it will take 2 cells for both field objects. To avoid that just create 2 different sections for example you just create detail 1 for Grade A and Detail 2 for Grade B with above suppression logic.
5. We can’t export lines and tables when you are export to Excel data only.
6. After you drag & drop fields into your designer, don’t resize or overlap them. Make sure that you have selected options snap to grid.
7. Select the Can Grow option for all the fields in the report by default. This will avoid the overlapping.
These are main point’s needs to be remember, when you are exporting the .rpt file to .xls file.