CODEWITHSUNDEEP
asp.netexcelcrystal-reports
Suman
Suman

Reputation: 63

Export Crystal Report rpt file to Excel without can grow format object

I am exporting Crystal Report to Excel file using Crystal Report version 13 and VS 2013.

When I tried to export the Crystal Report file to Excel, the columns are merged. I need to unmerge all the fields at runtime so that I can manipulate data in an Excel sheet. TIA

Upvotes: 1

Views: 1350

Answers (1)

MilletSoftware
MilletSoftware

Reputation: 4001

There is a 15-page SAP document describing various aspects of designing Crystal Reports so they export as expected to Excel. Link is here. In your case, the most important guideline is probably to make sure all objects that overlap vertically are perfectly aligned and have the same width.

You may want to consider using Excel (Data Only) export format to get better output. Similarly, you may find that exporting to Tab Separated (TTX) file produces cleaner output when opened in Excel.

Upvotes: 1

Related Questions