1. Daniel Johnson
  2. PowerBuilder
  3. Wednesday, 12 May 2021 17:58 PM UTC

We just updated from PB12.5.2 to 2019R2, and noticed an issue filtering one of our reports.

The report is a composite DataWindow, grouped, with nested report objects in the group header bands. It displays properly on the initial retrieve, but nested reports disappear after a Filter() is a applied. 

Using external DataWindows with embedded data works fine, but nested reports disappear when the child objects have queries.

This was working without issue in the previous version, so does anyone know a workaround or if this was resolved with a patch?

I attached an example showing the issue. The DWs have Oracle "DUAL" queries behind them, but they can be easily updated to pull dummy data from any database.

Attachments (2)
Accepted Answer
Baron Zhang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 08:41 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Daniel,

 

Thanks for your test case and I can reproduce the issue.

Cause of the issue: In your window open event, after the execution of retrieve, you immediately execute DISCONNECT to disconnect from the transaction. So when it executes the filter, there is no data in the child report.

You can try to comment out the DISCONNECT code and the program will work fine.

 

Regards,

Baron

Comment
  1. Daniel Johnson
  2. Wednesday, 19 May 2021 13:06 PM UTC
Thanks, Baron - does that mean that nested reports are re-retrieved when a filter is applied?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 19 May 2021 15:03 PM UTC
Hi Dan ... yes it does Retrieve again!

There is a support ticket open for this issue.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 12 May 2021 18:46 PM UTC
  2. PowerBuilder
  3. # 1

Hi Daniel;

   For PB2019R2 ... are you using build 2353?

   Update: Your Test App works properly for me on R2 build 2353!  <= **

Regards ... Chris

Comment
  1. Daniel Johnson
  2. Wednesday, 19 May 2021 12:56 PM UTC
Thanks so much for looking into this, guys!



We didn't change our code (that disconnects after retrieve), so maybe this was actually a bug fixed between 12.5.2 and 2019R2.



Keep up the good work! :)
  1. Helpful
There are no comments made yet.
Daniel Johnson Accepted Answer Pending Moderation
  1. Wednesday, 12 May 2021 18:49 PM UTC
  2. PowerBuilder
  3. # 2

Yes, that's correct! smile

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.