Report Header cutt off in MS Excel?

[nmmure]

Hi,

Report header was cut off while exporting to my report into Excel in web.
We have 2 versions 1) Intranet (C++) & 2) Internet (.net)

Report is displaying in the front end like below

EX: 1

Job Custo Custo Accou Pooln Pool
ORIG ORIGE LEHM- WARE WARE


While exporting into Excel, In Intranet version I select “MS Excel 97-2000 (Data Only)”& In the Excel Format option I select “Export page header and page Footer”. & In Excel -> Format -> Column -> Auto fit selection then Report is showing entire Header word. Like below

Ex: 2
Job Number Customer Code Customer Name Account Poolnum Pool Descr Pool Type
ORIG ORIGEN FINANCIAL LEHM-WARE WARELAND WAREHOUSE LAND HOME LOANS WARE


In the Web version I export the report into Excel I selected all above options.
Still it is showing same as Ex: 1)

Is there any option to set in the report side or I need to write code on application side.

Pls help me.

I am using Crystal reports 10, SQL Server 2000, VB.Net

Thanks
Mure

 

[nmmure]

Hi,

Right know I don't have access to publish my report into server & Administrator will do this task.
I checked rpt file header, Our developer was not selected "Can Grow" Option. I am thinking if we select the "Can Grow" option, header will display completly, this will help I guess.

My administrator will come tomorrow, I will check this option and let you know.
Is I am thinking in the right way? IF wrong pls guide me.

thanks
Mure