1. Andrew Davis
  2. PowerBuilder
  3. Thursday, 21 November 2019 17:17 PM

Hi

Can anyone tell me whether it is possible to have a nested report connected to a different transaction object and if so how to.

So the report might be on SQLCA - sales database and the sub / nested report on the SQLCB - personel database 

the main report would 'feed' the nested the parameters for its report as usual 

I am using pb2019

 

thanks in advance 

 

Andrew

 

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 21 November 2019 19:30 PM
  2. PowerBuilder
  3. # 1
1
Votes
Undo

I guess so,

Make sure you uncheck the "autoretrieve" option of the column "withDDDDW" on the dw "dw_1", which has the dddw assigned.

Then in code you do a :

 

transaction ltr_b

ltr_b = create transaction

ltr_b.logid = ....

ltr_b.dbpass = ....

etc. for all of the parameters of the transaction object.

Connect using ltr_b;

 

datawindowchild ldwc

dw_1.GetChild("withDDDW", ldwc)

ldwc.SetTransobject(ltr_b)

ldwc.Retrieve(....)

 

disconnect using ltr_b;

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.