I have a compound PDF report that is not displaying correctly.

The first of the two component reports appears to be fine. The second one shows up in the right spot, but for some reason the first 50 or so records do not appear.

I am retrieving the records via a SQL Server stored procedure. The stored procedure does return the missing records, and if I run the component report individually in DevStudio the missing records appear there, too.

To me, then, this pretty strongly suggests that the problem has something to do with the compounding. I just haven't yet found anything that would explain this result. Does anyone have any experience with a similar problem? I will greatly appreciate any insight anyone can provide. Thanks!

This is the text of my .fex file for the main report:

-* File [report name]
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
OBJECT=TOC, NAME='text1', TEXT='<font face="ARIAL" size=10>Table of Contents</font>', MARKUP=ON, TOC-NUMBERING=ON, POSITION=(0.854 0.854), DIMENSION=(9.500 7.000),  METADATA=' TOCTITLE: Table of Contents OUTERHTML: <SPAN style="Z-INDEX: 101; POSITION: absolute; WIDTH: 9.5in; FONT-FAMILY: Arial; HEIGHT: 7in; FONT-SIZE: 10pt; TOP: 0.854in; LEFT: 0.854in; Justify: center" id=text1 tabIndex=2 TOC_Text="true">Table of Contents</SPAN>', $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=ON, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0, TOPMARGIN=.1, METADATA='BOTTOMMARGIN=.1,TOPMARGIN=.1,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.521 0.521), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 9.982in; HEIGHT: 0.727in; OVERFLOW: auto; TOP: 0.521in; LEFT: 0.521in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(+0.000 -.43), DIMENSION=(* *), RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 9.983in; HEIGHT: 0.728in; OVERFLOW: auto; TOP: 1.352in; LEFT: 0.521in', $
OBJECT=STRING, NAME='text4', TEXT='<font face="ARIAL" size=9 color=#696969>Page <ibi-page-number/> of <ibi-total-pages/></font>', POSITION=(9.563 0.146), MARKUP=ON, WRAP=ON, DIMENSION=(1.771 0.417), style=bold+italic, METADATA=' OUTERHTML: <SPAN style="Z-INDEX: 100; POSITION: absolute; WIDTH: 1.771in; FONT-FAMILY: Arial; HEIGHT: 0.417in; FONT-SIZE: 10pt; TOP: 0.042in; LEFT: 6.563in" id=text4 tabIndex=6><SPAN id="<ibi-NofN/>" contentEditable=false>^lt;Page # of ##^gt;</SPAN></SPAN>', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE app/[first component .fex name]
SET COMPONENT='report2'
-*component_type report
-INCLUDE app/[second component .fex name]
COMPOUND NOBREAK END
-IF &LINES EQ 0 THEN GOTO BLANKRPT ELSE GOTO DONE;
-BLANKRPT
-INCLUDE BLANKREPORT
-DONE

This message has been edited. Last edited by: DougPowers,

Doug,

Please, please, please put your code within

[code]

[/code]

tags - the TABLE OF CONTENTS code is messing up the FocalPoint screen for this thread.

Cheers,

Done. Thanks, Francis. I wasn't aware that I needed to do that. Just another IBI/WebFOCUS idiosyncracy, I suppose.

If you delete the first report, do all the records from the second report show? If yes, it is possible that you don't have your overflow set up quite right and the top of report 2 is getting covered up by report 1.

Just an idea.

Ginny, thanks. I'll give that a look. I do see the headers for the second component report at the bottom of page 1, after the end of the first component report. Page 2 of the PDF then shows what would be the second page of results from the second component report, seemingly skipping the first page of results from the second component report. The presence of the headers for the second component report seems to indicate that it's not lying under the first component report, but I'll check out your suggestion.

Ginny, that does turn out to have been it. The compound report was using "OVERFLOW: auto" and the auto setting doesn't appear to have been doing it right.

I set the OVERFLOW to flowing, changed the position of the second report (there was a negative value in there that was also throwing an error), and went into PDF Layout Painter to manually set the relationship between the reports. Once these three things were done, the report worked properly.

Thanks very much for your help!

Glad I could help.

quote:

Just another IBI/WebFOCUS idiosyncracy, I suppose.

Doug,

For info, the need to put your code within [ code] and [/code] tags is nothing to do with WebFOCUS but is how the forum software is designed to cope. There are many forums out there (that you may encounter) that also have the same requirements.

Just so that you know

T

Thanks, Tony. I hadn't encountered that before, but then I've not had occasion to post code snippets to many forums.

I appreciate the clarification. There's no sense in falsely attributing an idiosyncracy.