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

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

Advice

Votes

Undo

BRIAN PROM
PowerBuilder
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

DataWindow

Accepted Answer

BRIAN PROM Accepted Answer Pending Moderation

Wednesday, 16 March 2022 19:37 PM UTC
PowerBuilder
# 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 Accepted Answer Pending Moderation

Wednesday, 2 March 2022 23:13 PM UTC
PowerBuilder
# 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

Comment

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Wednesday, 2 March 2022 22:27 PM UTC
PowerBuilder
# 2

Hi Brian;

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

HTH

Regards ... Chris

Comment

BRIAN PROM
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

Helpful 0

There are no comments made yet.

BRIAN PROM Accepted Answer Pending Moderation

Wednesday, 2 March 2022 15:03 PM UTC
PowerBuilder
# 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
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

Helpful 0

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Friday, 18 February 2022 21:11 PM UTC
PowerBuilder
# 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

Comment

BRIAN PROM
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

Helpful 0

Chris Pollach @Appeon
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.

Helpful 0

There are no comments made yet.

BRIAN PROM Accepted Answer Pending Moderation

Tuesday, 15 February 2022 19:20 PM UTC
PowerBuilder
# 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
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.

Helpful 0

BRIAN PROM
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?

Helpful 0

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Tuesday, 15 February 2022 19:17 PM UTC
PowerBuilder
# 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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

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.