Objects from Nested reports

[santosh2natal]

I want to obtain the value or porperty of a column or computed column or any other object like static text from a nested report. Is it possible ? If so how it is done?
Please help

Thanx a lot in advance.

Santosh Natal

 

[wsmall73]

You can do a GetChild on the nested report and then access it's properties. Make sure you set the Name field on the General tab on the nested report this is what you will use as part of your GetChild Call.

dw_1.GetChild('Name Field',dwc_nest1)

I am sure you can take it from here.

 

[pgaec]

Source:

http://www.justpbinfo.com/pbtips/getchild-nested.asp

Getchild() provides a reference to a child DataWindow or to a report in a composite DataWindow, which you can use in DataWindow functions to manipulate that DataWindow or report.

According to the definition above, a call to GetChild ( ) for the nested report that is part of a tabular (or other) DataWindow fails and the function returns -1. So there is no way you can get a reference to the nested DataWindow that is part of a non-composite DataWindow.

The following method enables the usage of the getChild() function also on such non-composite DataWindows.

1. Export your Tabular, Freeform, Grid, Graph ( or whatever ) style base DataWindow in the library painter.

2. In the third line of the export file change "processing=0" (or whatever) to "processing=5". This is the actual trick ie. to impose the functionality of a composite DataWindow (it has processing=5).

3. Import the exported and modified file back.

4. You can call GetChild ( ) on your nested DataWindow as you "normally" would.

Now you have the power of the datawindowchild functions at hand, which means you could easily modify nested reports after the retrieve ie. Filtering and Sorting etc.

NOTICE:

The method described above is an undocumented and NOT SUPPORTED by Sybase and should be used with caution.