Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

crosstab column heading values

348 views
Skip to first unread message

Simon Abela

unread,
Aug 3, 1999, 3:00:00 AM8/3/99
to

I am using pb6.5 on NT4.

I want to be able to get the column heading values at runtime from a crosstab
data window. This is because when i export to excel, the unique column heading
names are lost and replaced with val_col_name_1, val_col_name_2 etc..

I can replace them via ole, but need to get the values first. I have tried a few
variations on dw_1.object.colname... with no success. I have also tried setting
crosstab.staticmode=yes. I don't want to have to do another data retrieval for
performance reasons.

Can anyone help?

Simon Abela

Pavol Rovensky

unread,
Aug 3, 1999, 3:00:00 AM8/3/99
to

Simon,

here is snippet I've used in version 5


for i = 0 to il_column_count_crosstab

if i = 0 then
Valname = "val_t"
else
valname = "val_" + String(i) +"_t"

end if

aModStr = dw_1.Describe(valname+".Text")


// do some processing and modify

aTeststr = dw_1.Modify(valname+".Text='" +aModstr +"'")


next


To get columnCount
il_ColumnCount = long(dw_1.Describe("Datawindow.Column.Count") )

il_column_count_crosstab = il_ColumnCount - MyConstant


Do not forget to set static mode .


--
Pavol Rovensky
4M4 s.r.o.
Jinonicka 80
158 00 Praha 5
Czech republic
e_mail: mb...@icom.cz

0 new messages