To display a column header in a format when exported to excel

[musini]

Hi,

I have a column with name as below. This is how it looks when it is exported to an excel file.

(Customer Identification Number)
1
2
3
4
I would like it to be displayed as follows.

Customer
Identification
Number
1
2
3
4
Basically, If the column header is too long, I would it to be in more than one row of the same cell of excel insted of one big line in a cell.

Is there a specific option in crystal, I could choose so that I could export the column names as mentioned above.

Thanks,
M

 

[IanWaterman]

If you get the label to wrap to 3 lines when displayed in Crystal, it should export as 3 rows to Excel.

Ian

 

[musini]

Is tehre a option where I could enable the wrap.

Thanks,
M

 

[IanWaterman]

Just size the text box big enough to fit the word "Identification" and then increase box height and text will wrap automatically.

Ian

 

[musini]

Hi,

I did that before, but it did not work. I am using the following export options.

column width based on objects in details
export object formatting
maintain relative object position
export pageheader and pagefooter

Please suggest.

Thanks,
kranthi

 

[CrysRptDev]

Double hit your text box and modify, make sure hit 'Enter' key for each word to move them to another line. In this case you would write Customer then 'Enter' Identification then Enter Number, then you would have

Customer
Identification
Number

Align them in Center

 

[IanWaterman]

Set text box to Can Grow too.

Ian

 

[musini]

I tried everything but nothing is working. If I do the enter after each word and export the reort with the above export options, I am getting a special charecter in between the words and all the word are in the same line, but not in the new line.

Thanks,
M