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,

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.

It may help if you can repro with the IBI supplied files like CAR.

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

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.