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


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 




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

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)




disconnect using ltr_b;



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.