Last post Apr 10, 2013 08:34 AM by anilmsdn
Nov 23, 2010 04:55 AM|Anbarasu_P|LINK
Can any one help me to fix the crystal report - export to excel formatting issues. When exporting to excel If the content in a particular cell exceeds to the width of the cell, the text wrap automatically and creates a blank line under the text when exporting
to excel. If the content in the cell is small, then the export works perfectly fine. I tried change the CanGrow and max-lines option. But still exporting to excel generates the same issues (blank lines if the contents in long).
Nov 23, 2010 06:38 AM|AnthonyDas|LINK
Crystal Report to Excel or Crystal Report to PDF depends how you have designed (formatted ) your report.
Cystal Report to Excel
1. Make sure there is not much gap between Details and Report Footer Section (Right click on Details Section and select the option Fit Section)
2. Select all the IFieldObject (data field) in details section right click and select size
3. Make sure that no space is left out between each IfieldObject (data field)
Kindly do the above and if possible send me the crystal report @ (firstname.lastname@example.org)
Apr 10, 2013 08:34 AM|anilmsdn|LINK
thanks for the solution