[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Cover page for a Powerbuilder report

Posted on 2012-08-29
Medium Priority
Last Modified: 2013-12-26
I currently have 2 separate reports. One is a more standard report that lists out a bunch of information between a header and a footer which is grouped by a client. The second report is the cover page for each client's report. One of our employees is charged with collating these two reports and mailing them out.

How would I go about combining the two reports? Meaning I want the cover page to print out each time the client changes. This way we don't have to spend hours collating the reports.

Any help would be appreciated. I should note that I'm not the most well versed in powerbuilder but I should be able to figure it out.
Question by:PathLabs

Author Comment

ID: 38352222
Thanks _alias99!
LVL 14

Accepted Solution

sandeep_patel earned 2000 total points
ID: 38353039
You can use nested report feature of powerbuilder...

1) let's say there are two datawindows. dw_info and dw_cover
2) dw_info is for client information has one standard header, detail, summary and footer plus a header for client (as you have group by) and a trailer for client.
3) dw_cover is the conver information for client.
4) Now expand header group for client in dw_info and from menu select Insert > Control > Report. This will open a dialogue box with all datawindows in your pbls. Select datawindow dw_cover from the list. You will have nested datawindow dw_cover inside dw_info.
5) Set width of dw_cover as of dw_info. Height doesn't matter much, unless you see issue in displaying data from dw_cover when you retrieve the report.
6) If there are any retrieval arguments for dw_cover, set from properties > General Tab > Arguments. I guess mostly client_id will be the argument for dw_cover and as dw_info is group by client_id you can use client_id column from dw_info as argument in dw_cover.
7) Make sure dw_info is set to sort by client_id.
8) Now retrieve dw_info and you are done!!!.

Let me know if this doesn't work or my assumption is wrong.

LVL 53

Expert Comment

ID: 38804716
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question