Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problems with PDF in Free-form format
Go
New
Search
Notify
Tools
Reply
  
Problems with PDF in Free-form format
 Login/Join
 
<sdavis>
posted
I am trying to produce two reports in free-form format. When I comment out the SET ONLINE-FMT=PDF
then I receive two reports but if the PDF is ON, it will only produce the first report in PDF format. I really need both reports in PDF format.

SET STYLE=OFF
SET STYLEMODE=FIXED
SET ONLINE-FMT=PDF
 
Reply With QuoteReport This Post
<Pietro De Santis>
posted
You need to create a "Compound" PDF report. Here's an example.
-* Report 1<br /><br />SET PAGE-NUM=OFF<br /><br />-*SET COMPOUND = OPEN NOBREAK<br /><br />TABLE FILE CENTORD<br />HEADING<br />"Sales Report"<br />" "<br />SUM LINEPRICE<br />BY PRODCAT<br />ON TABLE SET STYLE *<br />TYPE=HEADING, SIZE=18, $<br />ENDSTYLE<br />ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK<br />END<br /><br />-* Report 2<br /><br />-*SET COMPOUND = NOBREAK<br /><br />TABLE FILE CENTORD<br />HEADING<br />"Inventory Report"<br />" "<br />SUM QUANTITY<br />BY PRODCAT<br />ON TABLE SET STYLE *<br />TYPE=HEADING, SIZE=18, $<br />ENDSTYLE<br />ON TABLE PCHOLD FORMAT PDF NOBREAK<br />END<br /><br />-* Report 3<br /><br />-*SET COMPOUND = CLOSE<br /><br />TABLE FILE CENTORD<br />HEADING<br />"Cost of Goods Sold Report"<br />" "<br />SUM LINE_COGS<br />BY PRODCAT<br />ON TABLE SET STYLE *<br />TYPE=HEADING, SIZE=18, $<br />ENDSTYLE<br />ON TABLE PCHOLD FORMAT PDF CLOSE<br />END
Basically, the first PDF report is OPENs the compound report, the middle ones are added to it, the last one closes it. Remove the NOBREAK option if you want the reports to be on separate pages.

Pietro.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problems with PDF in Free-form format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.