Focal Point
Question on Compound Reports[CLOSED]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6997058926

March 30, 2013, 11:59 PM
gnanyy
Question on Compound Reports[CLOSED]
Hello,

I am trying to print two holds with PDF OPEN and PDF CLOSE OPTION.

when i get the Report i get the output of first hold then output of second hold in the PDF.
but i need the Report to be generated with a BY filed option.

Example : when i use two holds(using car table) to generate cars of two different countries.total output should be printed BY CAR TYPE

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


WebFOCUS 7.7
Windows
March 31, 2013, 04:38 AM
Twanette
Hi,

Post some code that you've tried with the CAR file. It makes it easier to see what you're trying to achieve.


WebFOCUS 8.2.06 mostly Windows Server
April 01, 2013, 07:49 AM
Alex
Like this maybe?
 
TABLE FILE CAR
PRINT   MODEL
BY COUNTRY PAGE-BREAK
BY CAR
ON TABLE PCHOLD FORMAT PDF
END 



WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
April 01, 2013, 10:05 AM
atturhari
You have to use Composer layout (GUI tool or use the code generated by it) and set the option MERGE = ON.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
April 03, 2013, 04:49 AM
gnanyy
Hi Atturhari,

It would be greta if share any sample code for the same.


WebFOCUS 7.7
Windows
April 03, 2013, 07:12 AM
atturhari

SET HTMLARCHIVE = ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=ON, ORIENTATION=LANDSCAPE, PAGESIZE=LEGAL, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=ALL, NAME='Page Master', $
COMPONENT='DfltCmpt1', POSITION=(0.5 1.0), DIMENSION=(* *), $



WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
April 10, 2013, 02:58 PM
gnanyy
Thanks it worked !!


WebFOCUS 7.7
Windows