Crosstab Datawindow

[wsmall73]

I am creating a report for displaying parts by category for particular vehicles.

row info = vehicle number
column = category_no
value = cost

I want to be able to drill down by clicking a trouble category and looking at the individual records. Is there any way to obtain the category_no in this case. I have tried to use DWO.name and obviously get the cost_1, cost_2 etc... I have also attempted to use dw_1.Describe ("#" + string(li_col) + ".dbname&quot to look at name and dbname properties (utilizing the getclickedcolumn function).

I have thought about exporting the datawindow syntax and parsing that but that would be really (REALLY) ugly. Any ideas would be greatly appreciated and I thank you in advance.
-wayno

 

[PowerObject]

If you have Category_No column placed in the report, you should be able to get its value for the clicked row in the Clicked! event:

ll_CategoryNo = This.Object.Category_No[ row ]

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[wsmall73]

I get the unable to access external object property category_no

the category_no is is repeated from left to right across the report

1000 1200 1400 etc...