Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved nested report - transaction object

  1. How-to
0
Votes
Undo
  1. Andrew Davis
    Andrew Davis
  2. PowerBuilder
  3. Thursday, 21 November 2019 17:17 PM UTC

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

 

  1. Transaction
Appeon Workarounds - location
Is there a free utility to convert pb 7 objects to...
Responses (1)
Miguel Leeuwe
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)

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.