I created a crosstab report and it

[gnamachivayam]

I created a crosstab report and it worked fine, but when I tried to save it as an Excel file, the headings (which is a column value), are not stored as I see in the datawindow output. In the excel file, I could see only a_1, a_2, a_3 as column headings instead of data.

Please help!

Ganesh

 

[CriCriCri]

integer ret
ret=dw_stat.SaveAs ( "C:\StatCode.xls", excel!, true )

Is the code like this one?

 

[gnamachivayam]

The piece of code you specified is of no use. Rather I tried with

dw_1.SaveAs("c:\s.xls", HTMLTABLE! TRUE) and it works fine and I get the columns as I expected, but if any row values contain only numbers, then it is saved as trimmed numbers, like 00033 (string) is saved as 33 (number).

I am using PowerBuilder 7.0 and Oracle 8.1
Can you help.

 

[bubbly]

U could do this by means of OLE Object.
Identify the column say E1:E1
i.e,
lole_Sheet.Range("E1:E1&quot.Select

And then modify the format of the column i.e,

EntireColumn.Format.custom = ' Format ' ( 000)


This should work