I have a report that has three separate queries and three separate TABLE FILE outputs. I tried to use the compound report feature, but from what I could tell this solution will not help me in this instance. The middle report has a dynamic number of records (1 - 99) and the compound report has a hard coded height defined. If the third report would always follow the end of the second report, then that would work.
Once I scrapped that approach, I resorted to using the HTML format to display the reports, since HTML is designed to be a continuous format. However, the styling of reports 2 and 3 influence the styling of the first report.
Is there a way to specify, perhaps with a -SET command, to reset the styling or prevent the styling to affect the previous data? This is not the case if I use the open nobreak feature for the pdf format.
Also, if the second report can be fluid in a compound report, that would also be helpful.
Thanks in advance.This message has been edited. Last edited by: tkuhns,
WF 8.2, Dev Studio, DB2, MySQL, self-service Output formats: HTML, Excel 2000 and PDF
July 15, 2010, 11:49 AM
Darin Lee
You can change the overflow option of the report to "flowing" in the second report and that should fix the problem.
As for the HTML, it seems there has always been an issue with multiple reports and cascading stylesheets because they apply to the entire content of the page, not just individual reports. Unless you put them each in their own frames, I don't see a way around that problem.
I would stick with a PDF 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 15, 2010, 05:50 PM
Waz
It may help if you can repro with the IBI supplied files like CAR.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
July 21, 2010, 03:44 PM
tkuhns
Here is an example of what is happening if I set it to flowing. The 'height' property seems to take precedence over the 'flowing' feature. The reports end up overlapping. Is there a way around this? Again, the middle report has a dynamic length.
-* File newfex6 -* Default Mode: ResourceLayout SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $ PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $ COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.521), DIMENSION=(9.996 2.500), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 9.996in; POSITION: absolute; TOP: 0.521in; HEIGHT: 2.5in', $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 2.313), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 10.004in; POSITION: absolute; TOP: 2.313in; HEIGHT: 4.937in', $ COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.521 4.479), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.521in; OVERFLOW: auto; WIDTH: 9.983in; POSITION: absolute; TOP: 4.479in; HEIGHT: 3.521in', $ END SET COMPONENT='report1' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST WHERE COUNTRY EQ 'ENGLAND' END SET COMPONENT='report2' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST END SET COMPONENT='report3' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST END COMPOUND END
WF 8.2, Dev Studio, DB2, MySQL, self-service Output formats: HTML, Excel 2000 and PDF
July 26, 2010, 06:33 AM
saikumar
If the Multiple reports you are calling in Composer are Dynamic then better to use PAGELAYOUT feature which avoids overlapping of the reports. Try this , SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $ PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $ COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.521), DIMENSION=(9.996 2.500), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 9.996in; POSITION: absolute; TOP: 0.521in; HEIGHT: 2.5in', $ PAGELAYOUT=2, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 2.000), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 10.004in; POSITION: absolute; TOP: 2.313in; HEIGHT: 4.937in', $ PAGELAYOUT=3, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $ COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.521 2.000), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.521in; OVERFLOW: auto; WIDTH: 9.983in; POSITION: absolute; TOP: 4.479in; HEIGHT: 3.521in', $ END SET COMPONENT='report1' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST HEADING "REPORT 1" WHERE COUNTRY EQ 'ENGLAND' END SET COMPONENT='report2' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST HEADING "REPORT 2" END SET COMPONENT='report3' -*component_type report TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE SEATS DEALER_COST HEADING "REPORT 3" END COMPOUND END
Thanks, Saikumar.
WebFOCUS 8103 Appstudio, Dev Studio MRE Client Windows 7, Serveron Unix. Excel, PDF, HTML,AHTML