• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Report with nested datawindows is not printing custom group header band (client based) on each page

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

Resolved Report with nested datawindows is not printing custom group header band (client based) on each page

  1. Advice
0
Votes
Undo
  1. BRIAN PROM
    BRIAN PROM
  2. PowerBuilder
  3. Tuesday, 15 February 2022 15:28 PM UTC

We have a client chart report that nest many datawindows (chart data) inside a driver datawindow (each row is a new client) and the client header band is not printing on each page.  The nested reports will span multiple pages sometimes.  Is there any way to get the client header band (header.1) to print at the top of each page?  We are using PB 2019 R2 2703.  In the example pdf, the yellow band is in the client header band.  

 

Thanks,

Brian Prom 

Attachments (1)
clien chart.pdf
  1. DataWindow
Themes: Different Window Sizes (IDE, Without Theme...
PowerClient: Suppressing the "Upgrade App" Respons...
Accepted Answer
BRIAN PROM
BRIAN PROM Accepted Answer Pending Moderation
  1. Wednesday, 16 March 2022 19:37 PM UTC
  2. PowerBuilder
  3. # Permalink 
I was able to get the information from the header.1 band on each page with a nested report in the detail band by moving the columns from header.1 to header.  It does refresh on each page and shows the correct data on each page this way.
Comment
There are no comments made yet.
Responses (7)
BRIAN PROM
BRIAN PROM Accepted Answer Pending Moderation
  1. Wednesday, 2 March 2022 23:13 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,
I see the difference in your setup and mine. I have a driver datawindow that gives one row per client and I want to show more detailed info about that client in the detail band of the dw, so I have a nested datawindow in the detail band (with an argument of client_Id) and it's when that nested dw is greater than one page I don't get the client info doesn't print on subsequent pages. The client info in in a created group band of client id. I'll try to attach my dw's so you can see how it's setup.
Thanks,
Brian

Attachments (1)
d_client_chart_driver.zip
Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 2 March 2022 22:27 PM UTC
  2. PowerBuilder
  3. # 2

Hi Brian;

  Example DWO's attached FYR.  They require the "PB Demo DB V2019R3" Sybase SQLAnyWhere DBMS.

HTH

Regards ... Chris

 

Attachments (1)
Child_DWO_Heading_Example.zip
Comment
BRIAN PROM
  1. BRIAN PROM
  2. Wednesday, 2 March 2022 23:11 PM UTC
Hi Chris,

I see the difference in your setup and mine. I have a driver datawindow that gives one row per client and I want to show more detailed info about that client in the detail band of the dw, so I have a nested datawindow in the detail band (with an argument of client_Id) and it's when that nested dw is greater than one page I don't get the client info doesn't print on subsequent pages. The client info in in a created group band of client id. I'll try to attach my dw's so you can see how it's setup.

Thanks,

Brian
  1. Helpful
There are no comments made yet.
BRIAN PROM
BRIAN PROM Accepted Answer Pending Moderation
  1. Wednesday, 2 March 2022 15:03 PM UTC
  2. PowerBuilder
  3. # 3

I still cannot get my group header band to print on the top of each page.  Would you be willing to share your exported dw's, so I can compare any differences?

 

Thanks,

Brian 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 2 March 2022 22:23 PM UTC
Hi Brian;

I will make another post in a few minutes with the DWO source attached. These DWO's run against the PB Demo DB for 2019 R3.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 21:11 PM UTC
  2. PowerBuilder
  3. # 4

Hi Brian;

  FYI: I created a test DW report with a nested header DWO (aka Child). When the parent DWO was saved as a PDF, the heading DW appears on every page (see attached).

Regards ... Chris

Attachments (1)
Test_DW_Heading.pdf
Comment
BRIAN PROM
  1. BRIAN PROM
  2. Friday, 18 February 2022 21:19 PM UTC
Hi Chris,

Did you add the nested report in the detail band?

Which version / build of powerbuilder were you using?



Thanks, Brian
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 February 2022 21:24 PM UTC
Have two nested reports ... one in the header and one in the detail. I created this in PB2019R3 and then migrated & tested it in PB2021.
  1. Helpful
There are no comments made yet.
BRIAN PROM
BRIAN PROM Accepted Answer Pending Moderation
  1. Tuesday, 15 February 2022 19:20 PM UTC
  2. PowerBuilder
  3. # 5

No, the header info is not shown in the datawindow preview.  The PDF report looks like the DW preview.  We are using powerbuilder's save as PDF, but again the preview was showing the same as the pdf. 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 15 February 2022 19:37 PM UTC
Ahhh ... it sounds then like the DWO may not constructed properly to always display the header or .... the header is suppressed somehow (ie with an expression) that stops it displaying on page 2 and higher. I would look at the DWO's design then.
  1. Helpful
BRIAN PROM
  1. BRIAN PROM
  2. Friday, 18 February 2022 19:45 PM UTC
I created a new datawindow from scratch and added a group band for client id and put in the client demographics in that band, then in the detail band I nested a report that I knew would span multiple pages and still the client info in the header band doesn't print on subsequent pages. Maybe I need to open a bug ticket with Appeon?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 15 February 2022 19:17 PM UTC
  2. PowerBuilder
  3. # 6

Hi Brian;

   Does the report look OK in the DataWindow's "Preview" mode before the PDF is produced?

   Also, what mechanism are you using to produce the PDF?

Regards ... Chris

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.