1. Raymond Longoria
  2. PowerBuilder
  3. Tuesday, 22 February 2022 23:59 PM UTC

I am working with an application in Powerbuilder 2021. I created a composite report with 3 nested reports. Each report has the page count in their header. How can i get the page count in the trailing 2 reports be a continuation of the page count from the preceding report?

Accepted Answer
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 23 February 2022 19:28 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi, Raymond -

In the "container" DW, try adding a Page Computed Field in the Footer. Note that you cannot create a generic computed field, but need to instead use the one that is predefined, as the generic one is disabled in the drop-down toolbar in a composite DW:

To test, I created a composite DW with two nested reports, the first one being five pages long and the second one 18 pages long. For testing, I left the "Page n of nnn" computed field in the footer of each nested report. Here is what I see:

This also works if you place the Page Computed Field in the composite DW's header band instead of the footer band.

Regards, John

 

Comment
  1. Raymond Longoria
  2. Wednesday, 23 February 2022 21:56 PM UTC
John,

Actually I need the page number from the container dw inside the nested report header. For example, I want to get the page count from the first nested report and pass it as a parameter to the second nested report because it has a computed field that calculates the page number. How do I get the page count from the first nested report?
  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 23 February 2022 11:43 AM UTC
  2. PowerBuilder
  3. # 1

you could pass in the page count from the previous report as an argument to the retrieval of the second report. Then show the page() / pagecount() as a computed column which uses that retrieval argument + the current page() or pagecount() value.

 

Comment
  1. Raymond Longoria
  2. Wednesday, 23 February 2022 18:25 PM UTC
Miguel,

That is what I want to do. I don't know how to pass the page count from the previous report as an argument to the retrieval of the second report.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 23 February 2022 11:37 AM UTC
  2. PowerBuilder
  3. # 2

Hi Raymond,

Wouldn't you want the total pagecount() to be the total of all reports and not just the continuation of the previous ones?

regards

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.