Hi,

I am running a compound report, it only has 2 reports. I set the "SET COMPOUND= 'OPEN NOBREAK'" on the first report. And I set the "SET COMPOUND = 'CLOSE'" on the second report. It is working perfectly on the HTML format, but it doesn't work on the PDF format.

Here is my stylesheet on the first report:

UNITS=IN, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SQUEEZE=ON,
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, TOPMARGIN=0.5, BOTTOMMARGIN=0.5, $

TYPE = REPORT , GRID=OFF, FONT=ARIAL, SIZE=9, TOPGAP=0.02, BOTTOMGAP=0.04, $

TYPE = HEADING , STYLE=BOLD, $
TYPE = HEADING , LINE=1, SIZE=11, POSITION=(0.5 1.5),$
TYPE = HEADING , LINE=2, SIZE=1, $
TYPE = HEADING , LINE=3, COLOR=RGB(2 99 108), $
TYPE = HEADING , LINE=4, SIZE=1, $
TYPE = HEADING , LINE=11, COLOR=RGB(2 99 108), BOTTOMGAP=1.03, $
TYPE = HEADING , LINE=13, SIZE=1, $
TYPE = HEADING , IMAGE=crmrep1.jpg, IMAGEALIGN=TOP, IMAGEBREAK=ON, $

TYPE = TITLE , STYLE=BOLD, $
TYPE = SUBHEAD , STYLE=BOLD, COLOR=RGB(2 99 108), $
TYPE = SUBTOTAL , STYLE=BOLD, $
TYPE = GRANDTOTAL, STYLE=BOLD, $
ENDSTYLE

Here is the stylesheet on the 2nd report:

UNITS=IN, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SQUEEZE=ON,
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, TOPMARGIN=0.5, BOTTOMMARGIN=0.5, $

TYPE = REPORT , GRID=OFF, FONT=ARIAL, SIZE=9, TOPGAP=0.02, BOTTOMGAP=0.04, $
TYPE = HEADING , STYLE=BOLD, $
TYPE = HEADING , LINE=1, SIZE=11, POSITION=(0.5 1.5),$
TYPE = HEADING , LINE=2, SIZE=1, $
TYPE = HEADING , LINE=3, COLOR=RGB(2 99 108), $
TYPE = HEADING , LINE=4, SIZE=1, $
TYPE = HEADING , LINE=11, COLOR=RGB(2 99 108), BOTTOMGAP=1.03, $
TYPE = HEADING , LINE=13, SIZE=1, $
TYPE = HEADING , IMAGE=crmrep1.jpg, IMAGEALIGN=TOP, IMAGEBREAK=ON, $

TYPE = TITLE , STYLE=BOLD, $
TYPE = SUBHEAD , STYLE=BOLD, COLOR=RGB(2 99 108), $
TYPE = SUBTOTAL , STYLE=BOLD, $
TYPE = GRANDTOTAL, STYLE=BOLD, $
ENDSTYLE

Do you see anything wrong?

Thanks
May

May,

What is the error you get when running the report for PDF output?

May,

Have you tried using OPEN on the first report instead of OPEN NOBREAK?

That would be the first change I would make in testing.

T

Hi Francis,

My problem is the 2nd report is covering the first report.

Tony,

I had tried to use 'OPEN' only, but it will break my first and 2nd reports into 2 pages. I prefer both reports will show on one page.

May

May,

That is what I thought and hoped you might say - that you have tried it which is also why you've reached the conclusion that the style sheet is somehow causing your grief.

Try taking out the POSITION attribute in - TYPE = HEADING , LINE=1, SIZE=11, POSITION=(0.5 1.5),$ - initially from both style sheets and let us know what you get back.

T

May,

The problem is that you copied the same stylesheet for both pieces of the report - the POSITION tag in the second report HEADING style is causing the reports to overlap each other.

Try this code:

SET PAGE=NOLEAD
-RUN

SET COMPOUND= 'OPEN NOBREAK'
-RUN

TABLE FILE CAR
SUM
SALES
BY COUNTRY
HEADING
"WebFOCUS Report 1"

ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SQUEEZE=ON, COLOR=BLUE,
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, TOPMARGIN=0.5, BOTTOMMARGIN=0.5, $

TYPE = REPORT , GRID=OFF, FONT=ARIAL, SIZE=9, TOPGAP=0.02, BOTTOMGAP=0.04, $

TYPE = HEADING , STYLE=BOLD, $
TYPE = HEADING , LINE=1, SIZE=11, POSITION=(0.5 1.5),$
TYPE = HEADING , LINE=2, SIZE=1, $
TYPE = HEADING , LINE=3, COLOR=RGB(2 99 108), $
TYPE = HEADING , LINE=4, SIZE=1, $
TYPE = HEADING , LINE=11, COLOR=RGB(2 99 108), BOTTOMGAP=1.03, $
TYPE = HEADING , LINE=13, SIZE=1, $
TYPE = HEADING , IMAGE=crmrep1.jpg, IMAGEALIGN=TOP, IMAGEBREAK=ON, $

TYPE = TITLE , STYLE=BOLD, $
TYPE = SUBHEAD , STYLE=BOLD, COLOR=RGB(2 99 108), $
TYPE = SUBTOTAL , STYLE=BOLD, $
TYPE = GRANDTOTAL, STYLE=BOLD, $
ENDSTYLE
END
-RUN

SET COMPOUND = 'CLOSE'
-RUN

TABLE FILE CAR
SUM
SALES
BY MODEL
HEADING
"WebFOCUS Report 2"

ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SQUEEZE=ON, COLOR=GREEN,
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, TOPMARGIN=0.5, BOTTOMMARGIN=0.5, $

TYPE = REPORT , GRID=OFF, FONT=ARIAL, SIZE=9, TOPGAP=0.02, BOTTOMGAP=0.04, $

TYPE = HEADING , STYLE=BOLD, $
TYPE = HEADING , LINE=1, SIZE=11, $
TYPE = HEADING , LINE=2, SIZE=1, $
TYPE = HEADING , LINE=3, COLOR=RGB(2 99 108), $
TYPE = HEADING , LINE=4, SIZE=1, $
TYPE = HEADING , LINE=11, COLOR=RGB(2 99 108), BOTTOMGAP=1.03, $
TYPE = HEADING , LINE=13, SIZE=1, $
TYPE = HEADING , IMAGE=crmrep1.jpg, IMAGEALIGN=TOP, IMAGEBREAK=ON, $

TYPE = TITLE , STYLE=BOLD, $
TYPE = SUBHEAD , STYLE=BOLD, COLOR=RGB(2 99 108), $
TYPE = SUBTOTAL , STYLE=BOLD, $
TYPE = GRANDTOTAL, STYLE=BOLD, $
ENDSTYLE
END
-RUN

By the way, do you want the crmrep1.jpg image on both pieces of the compound PDF report?

Francis and Tony,

Thanks for your suggestion. It is working now. Yes Francis, I need crmrep1.jpg shows up on the second report when the first report has no result in some cases.

Thanks