alvinng
asked on
Nested Report
I would like to create a freeform report which contains a nested report. When I tried to link the arguments to that nested report, I could not find the arguments(which is string array) of outer datawindow to link with the arguments of this nested report. I use PB 6.5.
How can I pass this arguments (string array) into nested report in a datawindow?
How can I pass this arguments (string array) into nested report in a datawindow?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The most important point in my question is "how to pass argument, which data type is >>> string array <<< in the master report, from master report to nested report.
My master report has the same set of arguments as nested report. However, when I try to pass the argument into nested report, not all the arguments shown in the properties tab. (the data type, which is string array, is missing on the properties tab!!!)
My master report has the same set of arguments as nested report. However, when I try to pass the argument into nested report, not all the arguments shown in the properties tab. (the data type, which is string array, is missing on the properties tab!!!)
If you need execute a retrieve only once on your report make this with this code...
DataWindowChild state_child
integer rtncode
rtncode = dw_1.GetChild('emp_state', state_child)
IF rtncode = -1 THEN MessageBox( "Error", "Not a DataWindowChild")
// Set the transaction object for the child
state_child.SetTransObject (SQLCA)
// Populate with values for eastern states
state_child.Retrieve("East ")
// Set transaction object for main DW and retrieve
dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()
Nad whend you retrieve a State_Child you can incluye your string array args.
------
Think your report is fill in two steps one for DW_1 and the Nested report previosly was filled.
Maybe this can help you...
DataWindowChild state_child
integer rtncode
rtncode = dw_1.GetChild('emp_state',
IF rtncode = -1 THEN MessageBox( "Error", "Not a DataWindowChild")
// Set the transaction object for the child
state_child.SetTransObject
// Populate with values for eastern states
state_child.Retrieve("East
// Set transaction object for main DW and retrieve
dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()
Nad whend you retrieve a State_Child you can incluye your string array args.
------
Think your report is fill in two steps one for DW_1 and the Nested report previosly was filled.
Maybe this can help you...
Hello leirags,
I read comments, but please first SetTransaction to your master datawindow and then to childs.
I wrote you first work with Child GetChild() function. If you have some problems with string array, use steucture to transfer the data, otherwise array can be used also, but I am not understanding the main point from where to where you want to transfer the string array.
Bhatti
I read comments, but please first SetTransaction to your master datawindow and then to childs.
I wrote you first work with Child GetChild() function. If you have some problems with string array, use steucture to transfer the data, otherwise array can be used also, but I am not understanding the main point from where to where you want to transfer the string array.
Bhatti
Hello alvinng,
Sorry this comment is for alvinng.
I read comments, but please first SetTransaction to your master datawindow and then to childs.
I wrote you first work with Child GetChild() function. If you have some problems with string array,
use structure to transfer the data, otherwise array can be used also, but I am not understanding the
main point from where to where you want to transfer the string array.
Bhatti
Sorry this comment is for alvinng.
I read comments, but please first SetTransaction to your master datawindow and then to childs.
I wrote you first work with Child GetChild() function. If you have some problems with string array,
use structure to transfer the data, otherwise array can be used also, but I am not understanding the
main point from where to where you want to transfer the string array.
Bhatti
ASKER
Thanks
If you many dws in a datawindow use GetChild or Nets_arguments_list.
Please can you explain you question little more?
Thanks