Solved

Nested Report

Posted on 2001-09-07
7
820 Views
Last Modified: 2013-12-26
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?
0
Comment
Question by:alvinng
  • 3
  • 2
  • 2
7 Comments
 
LVL 4

Expert Comment

by:Bhatti
ID: 6463599
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
0
 
LVL 2

Accepted Solution

by:
Ariel Garcia earned 50 total points
ID: 6467998
First that all, if you need a ask to the user something, then ask to it before, and the design of report are on 2 steps

1.- Create a Nested Report and Declare on Properties, all of ARGS needs and must be on retrieve args

1.a.- Include your nested reports on the master (before step 1)

2.- Select the nested report and see the properties tab, and you see Arguments for that report, and then you can user a columns of a table and the ARGS defined on master report.

Note: When you select the type of ARGS you can define as String ARRAY if you need.
0
 

Author Comment

by:alvinng
ID: 6469305
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!!!)




0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 2

Expert Comment

by:Ariel Garcia
ID: 6469547
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...
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6471191
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
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6471228
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
0
 

Author Comment

by:alvinng
ID: 6471636
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now