Skip to Content

Report data in Excel needs to display the complete text by performing 'Wrap Test'

Location Report-IssueHi Support Team,

As part of the report requirements we are using 'SAP Crystal Reports 2016 Support Pack 7' and we want the report to be generated in Excel 97-2003.

I am attaching file 'Location Report-Issue' and I highlighted the cells AJ and AK. We have data with 303 characters in length ( in Database the Column size is 4000) and in AK field under rows 12,13,14 only 66 characters are displayed. So, I made changes for field AJ under Format Field, Common, 'can grow' and gave the maximum size as 12. Data for all the 303 characters are displayed, but the column is expanded vertically. I want the cell size to remain same and the data to be displayed in the cell when it is selected. So, please help to provide your suggestions. In the file 'Location Report-Expected', the expected cell format is displayed. location-report-issue.pnglocation-report-expected.png

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 20, 2020 at 06:53 PM

    Will the report ever be used without exporting it to Excel? If not, don't set a maximum size for the "Can Grow" and just let Crystal do its thing. Unfortunately, Crystal is very picky about Excel exports and there's not much that can be done to control that. Are you exporting to .xls or to .xlsx format?

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2020 at 09:05 PM

    At least one of the 3rd-party Crystal Reports tools listed here allows you to automate exporting a Crystal report to excel and applying Auto-Fit with desired max column widths.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.