Crystal Reports: auto column width

Question

I created a report using Crystal Reports 11 and trying to display it in my ASP.NET application using CrystalReportViewer. My report is just a table with several columns and header row. The problem is that when text exceeds cell's width, it overlaps the next cell. What I'm trying to achieve is that column width is automatically adjusted to accommodate the longest text in the column (just like normal HTML tables do). Please help me, I can't believe this common thing is so hard to do. Thanks!

Solution 1

As far as I know Crystal only allows you automatically expand a field vertically not horizontally.

To automatically increase the size of a field vertically you need to:

• Right click the field and select "Format Text"
• Select the "Common" tab
• Ensure the "Can Grow" check box is checked.
• Enter a value in the "Maximum number of lines box" (Leave at 0 for unlimited growth)

Solution 2

You can automatically increase the size of the field vertically. Then the data will display in several rows if the field length is not enough.

1. First Right Click on the field that you want to resize.
2. Then select the "Format Text"
3. Select the "Common" tab.
4. Then put a tick on the "Can Grow" Check Box.
5. If you need minimum number of lines enter value for the "Maximum number of lines box".
6. If you need to grow it unlimitedly then leave it as 0

Hope this will help for you.