Link to home
Start Free TrialLog in
Avatar of alvinng
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?
Avatar of Bhatti
Bhatti

Where do you want to pass the argument (string array).

If you many dws in a datawindow use GetChild or Nets_arguments_list.

Please can you explain you question little more?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ariel Garcia
Ariel Garcia
Flag of Mexico image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of alvinng

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!!!)




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...
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
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
Avatar of alvinng

ASKER

Thanks