Focal Point
Master Details Report in Webfocus

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5657008236

August 13, 2013, 09:50 AM
Trilochan
Master Details Report in Webfocus
I need to create Master-Detail report. It should show Master record and Detail records on the same page in HTML format.

- - - Master record
Department ID| Name |Location
1000 | Software | UK

- - - Detail records
Employee ID | Name | Salary
234622 | TNAYAK|2000
286575 | AJANA |2400

- - - Master record
Department ID| Name |Location
1001 | Hardware | USA

- - - Detail records
Employee ID | Name | Salary
289224 | PBERA |2500
286546 | MHOTA |2400

....etc

How can I do this type of layout where Detail records will show below Master record.

Please help.

Thanks in advance!


WebFOCUS 7.6.1
Windows, All Outputs
August 13, 2013, 10:02 AM
Francis Mariani
Master record in SUBHEAD rows, Detail records in report rows


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 13, 2013, 10:03 AM
Enigma006
one way i think of is to create 2 reports with same sort BY field and merge them as co-ordinated compound reports..then report will display this way.


8.1.05
HTML,PDF,EXL2K, Active, All
December 23, 2014, 08:21 AM
Trilochan
I have implement the master details report using looping from oracle procedures


WebFOCUS 7.6.1
Windows, All Outputs