• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB DW Report - Summary nested report not displaying all data

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

Resolved PB DW Report - Summary nested report not displaying all data

  1. Advice
0
Votes
Undo
  1. Suresh Thoduvail
    Suresh Thoduvail
  2. PowerBuilder
  3. Thursday, 16 February 2023 16:28 PM UTC

Hi Team,

Not sure if this is a known issue, i have noticed that the nested report that i have placed in my Datawindow summary section is not displaying all the data retrieved by the report and is truncating after a few rows (I have attached a screenshot with this issue).

Any suggestion, advise greatly appreciated.

Version Info: PowerBuilder 2021 Build 1509 (Runtime version 2021 Build 1509).

Thanks in advance,

Suresh 

 

 

 

 

 

 

Attachments (1)
Report_Layout.jpg Report_Layout.jpg
  1. DataWindow
  2. PowerBuilder (Appeon)
Application Management
datawindow dataobject name
Accepted Answer
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 22 February 2023 06:08 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi, Suresh -

I don't know if this will work, but possibly worth a try...

  1. Create a "summary" DataWindow containing the summary portion of the main report. The summary information should be in this new report DW's detail band.
  2. Remove the summary from the main report, ensure the summary band is empty and has zero height.
  3. Create a new nested/composite report. In it, place the main report DW (that does NOT have the summary), followed by the new Summary-only DW, both in the Detail band. Pass in the ID retrieval argument to both.

Best regards. John

Comment
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Wednesday, 22 February 2023 15:56 PM UTC
Hi John,



What i did is somewhat similar and seems to be working fine now.



What i did to accomplish this:

1. Moved the nested report from the Summary band (r_indprofile_rlse_summary) to the Detail band of the Main Report.

2. Set the Summary Band Height to zero.

3. Passed in the Individual ID from the Main report to the nested report.

4. Position tab of the nested report set - Autosize height and Directly Above.



Please note:

1. The report seems to be returning all the rows for large datasets.

2. The report is only for a single Individual (so Individual ID is passed on to all the nested reports from the main report).

3. Seems to be working fine for a few accused which were manipulated to have larger result sets (UAT).



Thanks very much for your help John.



P.S:



Report Design:

1. A single Individual ID is passed on from the Main Report to all the nested reports.

2. An Individual may have multiple addresses, Charges, Alias, co-accused and Release Summary (Files that the accused individual is directly associated with and the events on those files that are of interest to the Crown to make a decision to deny or approve Bail).



Assumption:

I am assuming that the PowerBuilder Datawindow Summary tab as of now (PB 2021, Build 1509) is not designed to return large result sets.

  1. Helpful
John Fauss
  1. John Fauss
  2. Wednesday, 22 February 2023 16:11 PM UTC
That's great news, Suresh! I'm glad I could help. Good luck on your upcoming deployment!
  1. Helpful 1
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Thursday, 23 February 2023 15:30 PM UTC
Thanks much John :)
  1. Helpful
There are no comments made yet.
Responses (9)
Suresh Thoduvail
Suresh Thoduvail Accepted Answer Pending Moderation
  1. Tuesday, 21 February 2023 19:51 PM UTC
  2. PowerBuilder
  3. # 1

Report output shows only 32 rows, while the actual report data (Actual_Report_Data_001.jpg) has 60 rows.

Attachments (1)
Actual_Report_Data_001.jpg Actual_Report_Data_001.jpg
Comment
There are no comments made yet.
Suresh Thoduvail
Suresh Thoduvail Accepted Answer Pending Moderation
  1. Tuesday, 21 February 2023 19:35 PM UTC
  2. PowerBuilder
  3. # 2

I am assuming that the report in the summary tab will *only display data worth one page* and not more than that.

So far i did the following and tried to see if all data would be displayed:

1. Coded THIS.Modify ( 'datawindow.PushCutControlToNextPage=yes' ) --> Retrieve Start event --> no change/luck.

2. Removed the line objects in the report --> no change/luck.

3. Removed the autosize property on the summary band and coded in the Retrieve End Event --> no change/luck.

   ls_Modify = "Datawindow.summary.Height.autosize=yes"
   ls_modify_error = this. Modify(ls_Modify)

Attached the report output --> Actual_Report_OutPut_002.jpg

 

Looking for any other suggestions at this point as we are planning to go to PROD in 2 weeks time with a known issue that will be discussed with the client and possibly agreed upon (i feel really bad).

Attachments (1)
Actual_Report_OutPut_002.jpg Actual_Report_OutPut_002.jpg
Comment
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 18 February 2023 13:36 PM UTC
  2. PowerBuilder
  3. # 3

If you have set Autosize height property for the band try

1.  Remove the autosize height
2.  And immediately set the autosize height property
through code, after retrieval.

This has worked for me in certain reports.

Happiness Always
BKR Sivaprakash

 

Comment
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Tuesday, 21 February 2023 14:47 PM UTC
Thanks much Sivaprakash, I will try this and keep you informed about the outcome.

  1. Helpful
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Tuesday, 21 February 2023 19:22 PM UTC
Hi Sivaprakash, no luck after setting the autosize property in the retrieve end script.
  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Saturday, 18 February 2023 03:23 AM UTC
  2. PowerBuilder
  3. # 4


1)  Looking at r_indiv_profile. In the summary band, get rid of the LINE object.

2)  What are the parameters being passed to the r_indprofile_rlse_summary nested DW?

Comment
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Tuesday, 21 February 2023 14:43 PM UTC
Thanks much Olan,



I will get rid of the line before the line Object, thanks much.



Q: What are the parameters being passed to the "r_indprofile_rlse_summary" nested DW?



A: Individual ID is passed from the main report to all the sub reports.
  1. Helpful
There are no comments made yet.
Suresh Thoduvail
Suresh Thoduvail Accepted Answer Pending Moderation
  1. Thursday, 16 February 2023 21:50 PM UTC
  2. PowerBuilder
  3. # 5

Hi Chris, please find the Report actual output (Actual_Report_OutPut_001.jpg).

Attachments (1)
Actual_Report_OutPut_001.jpg Actual_Report_OutPut_001.jpg
Comment
There are no comments made yet.
Suresh Thoduvail
Suresh Thoduvail Accepted Answer Pending Moderation
  1. Thursday, 16 February 2023 21:19 PM UTC
  2. PowerBuilder
  3. # 6

Report_Layout001.jpg is the actual output.

Attachments (1)
Report_Layout001.jpg Report_Layout001.jpg
Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 16 February 2023 23:14 PM UTC
It was a random thought. Sorry that this setting did not help.

It's super hard to know what the issue really is as we do not have your primary DWO source and the child DWOs that drive your report.

Ideally, a small test case with the above DWOs & test data that replicates this issue. Then we might be able to have a look at how / why this is not working.
  1. Helpful 1
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Thursday, 16 February 2023 23:41 PM UTC
No worries Chris, I will try to send you the DWO source code soon.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 16 February 2023 23:49 PM UTC
Also if you get a small PB App test ready - then you could also open a Support Ticket and attach the test case to it. This would allow our Appeon team to delve into this strange behaviour much deeper. HTH
  1. Helpful 1
There are no comments made yet.
Suresh Thoduvail
Suresh Thoduvail Accepted Answer Pending Moderation
  1. Thursday, 16 February 2023 17:55 PM UTC
  2. PowerBuilder
  3. # 7

Hi Chris, I am stress testing the report now (will keep you posted), i had earlier encountered that only 8 rows displayed out of rows around 14 rows.

Keeping my fingers crossed. I just want to reach out to the group if this is a common occurrence and/or to find any workarounds or if i am doing something wrong or if this is not what is expected from the summary band.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 February 2023 17:32 PM UTC
  2. PowerBuilder
  3. # 8

Hi Suresh;

  From the screen capture of the Design Pane changes you made ... does it work OK now?

Regards ... Chris

Comment
Suresh Thoduvail
  1. Suresh Thoduvail
  2. Thursday, 16 February 2023 21:08 PM UTC
I still get the report truncated in the summary section, i have attached screenshot --> Report_Layout001.jpg. Report shows 9 rows while the nested report retrieved on its own shows 11 rows.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 16 February 2023 21:15 PM UTC
Screen capture of actual Report output ???
  1. Helpful
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.