Detail Type3 Sub Heading (Oracle table4) Detail Type3 Reocrd1
Master Record3 (Oracle table1) . . .
Thanks, Vadivel NagarajThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.1.4 Windows Both Excel & HTML
July 30, 2009, 10:42 AM
GinnyJakes
Are Oracle tables 2,3, and 4 of the same format?
The basic answer is to join Master 1 to Oracle N, then sort the data by master keys then detail keys. On master sort break, do a subhead. Make the rest of the report detail.
If all the Oracle tables are the same, after each join, extract the columns you need into a hold file. Then use MORE or Universal Concatenation to combine them and do the report as stated in paragraph 2 of this post.
The oracle tables 2,3,4 are different formats and have different columns. Also, the records in each detail table are different. If all the tables are equi joined, for some of the tables the records are repeated/duplicated as the records counts are different in each detail table.
Brief Details on the Table, Table1 - Shipment Table2 - Shipment Parties Table3 - Shipment Party Items Table4 - Shipment Discrepancies
Thanks, -Vadivel Nagaraj
WebFOCUS 7.1.4 Windows Both Excel & HTML
July 30, 2009, 11:28 AM
GinnyJakes
Can you give an example with date of what the output is supposed to look like?
Please share your ideas, Your help on this is much appreciated.
WebFOCUS 7.1.4 Windows Both Excel & HTML
July 30, 2009, 04:43 PM
Darin Lee
Have you tried ANYTHING yet to try and solve the problem, or are you waiting for someone else to do it?
Nothing personal, but this sounds like a request for someone to write your code for you more than a request for help with a problem. I'm sure there are plenty of WebFOCUS consultants needing work and $$ who would be happy to help.
I understand that this is your first time here, but the Forum is more to help those who are trying to accomplish things by themselves but are having a particular problem, more than a place to post you report requirement and ask for someone to write your report.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 30, 2009, 04:53 PM
VadivelNagaraj
Hi Darin,
I developed a report with master and single detail, but when i enhanced the same for multiple details, i found it is bit challenging. Please don't misunderstand, I am looking for the guidance and not for the code. Please share your ideas if you know.
Thanks, Vadivel Nagaraj
WebFOCUS 7.1.4 Windows Both Excel & HTML
July 30, 2009, 04:55 PM
Darin Lee
You might want to try a coordinated compound report with the summary information as the first report and the detail report as the second. The coordination feature allows you to collate the two reports together by a primary sort field.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 30, 2009, 06:05 PM
GinnyJakes
If you look at the report, the data from Oracle 3 is a subset of Oracle 2, etc. But you want in your report to print, for example, the shipment id from Oracle 2 in the SAME column as the party id from Oracle 3. So with defines or MacGyver or something or both, you will have to force the same column data from the different tables into a field designated for column 1, column 2, etc. You have to homogenize your data to get it to come out the way you want it.
It is not necessary to print under the same columns. As long as the details are grouped under the corresponding sub heading and under the corresponsing master, it should be fine. Darin Mentioned that it can be done thru coordinated compound report, I will try with it.
Thanks, Vadivel
WebFOCUS 7.1.4 Windows Both Excel & HTML
August 02, 2009, 02:37 PM
VadivelNagaraj
I completed this report.
Thanks
WebFOCUS 7.1.4 Windows Both Excel & HTML
September 05, 2012, 12:17 PM
DD
Hi Nagaraj, Iam trying to do the same report. Would You Please post the sample code on how you did this.
Thanks, Ram.
WebFocus 7.7.01 Desktop: Windows and Server: Unix Excel, HTML, PDF