Access sub-report on a nested datawindow
- New
- How-to
-
Krishna Mohan Gullap
- PowerBuilder
- Saturday, 26 April 2025 12:57 PM UTC
Hi There to all PowerBuilder Guru's -
I have a composite datawindow (say dw_composite) which has 4 sub-reports inside it - dw_child_1, dw_child_2, dw_child_3 (all three placed in the Detail band of dw_composite) and dw_child_4 (placed in the summary band of dw_composite). dw_child_3 in turn is a composite datawindow with few columns in the detail band and another sub-report dw_grand_child_1
I have a client who is asking if he could have an extract of the entire data displayed in dw_composite when he does a Save as Excel from the application. I know there isn't a straightforward way to achieve this and the client doesn't care if the data is in different tabs or the same tab on the spreadsheet
The sub-reports dw_child_1, dw_child_2 and probably dw_child_4 can be accessed using a GetChild() and also after doing the GetChild(), I can do a RowsCopy to a local datastore which has the same DataObject assigned and do a SaveAs () on the DataStore
But none of this works for dw_child_3 because it is a Composite DataWindow by itself. I tried the Object notation too like dw_composite.Object.dw_child_3 but this returns neither a DataWindow nor a DataWindowChild. When I try adding this to the watch during debug -> dw_composite.Object.dw_child_3, it terminates the debug after throwing an error that the reference is NULL or invalid. However, when I add the statement -> dw_composite.Object.dw_child_3.dataobject, it returns the name of the DataObject assigned to dw_composite.Object.dw_child_3. Weird and confusing at the same time how I am able to access the DataObject name but not the Datawindow reference
Any help is gratefully appreciated :-)
Thanks,
Krishna
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.