SET FOCEXURL = http://&SERVERNAME|:&SERVER_PORT|/ibi_apps/WFServlet -SET &fexname = 'test_pdfdd'; -SET &DDO = 'xsusantest/'|&fexname ; -DEFAULT &WFFMT = 'PDF'; -DEFAULT &MYCAR = 'ALL'; -SET &filterCAR = IF &MYCAR.QUOTEDSTRING EQ 'ALL' THEN '' ELSE 'IF CAR EQ ''' | &MYCAR | ''''; TABLE FILE IBISAMP/CAR BY COUNTRY BY CAR BY MODEL SUM SALES &filterCAR ON TABLE PCHOLD FORMAT &WFFMT ON TABLE SET STYLE * TYPE=DATA,TARGET=BLANK, COLUMN=CAR,FOCEXEC=&DDO(MYCAR = CAR WFFMT = 'PDF' ),$ END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
SET SQUEEZE=ONTABLE FILE GGSALESSUM UNITS BUDUNITS DOLLARS BUDDOLLARSBY CATEGORY NOPRINT BY PRODUCT NOPRINTON CATEGORY PAGE-BREAKHEADING CENTER"Category: <CATEGORY"" "ON PRODUCT SUBHEAD"**** Product: <PRODUCT"BY REGION BY CITYON TABLE PCHOLD FORMAT PDF CLOSEON TABLE SET STYLE *TYPE=SUBHEAD, LINE=1, ITEM=2, DRILLTHROUGH=FIRST(CATEGORY PRODUCT),COLOR=RED, $ENDSTYLEEND
-* Default Mode: ResourceLayout SET HTMLARCHIVE=ON *-HOLD_SOURCE COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $ 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.813 0.833), DIMENSION=(7.292 2.500), BYTOC=0, DRILLMAP=((L1 report2)), ARREPORTSIZE=DIMENSION, METADATA='left: 0.813in; top: 0.833in; width: 7.292in; height: 2.5in; position: absolute; z-index: 1;', $ PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', 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.604 0.708), DIMENSION=(7.500 5.104), BYTOC=0, DRILLMAP=((L1 report3)), ARREPORTSIZE=DIMENSION, METADATA='left: 0.604in; top: 0.708in; width: 7.5in; height: 5.104in; position: absolute; z-index: 3;', $ PAGELAYOUT=3, NAME='Page layout 3', text='Page layout 3', 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.500 0.688), DIMENSION=(7.500 5.208), BYTOC=0, ARREPORTSIZE=DIMENSION, METADATA='left: 0.5in; top: 0.688in; width: 7.5in; height: 5.208in; position: absolute; z-index: 5;', $ END SET COMPONENT='report1' -*component_type report TABLE FILE CAR SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST CAR.BODY.SALES BY LOWEST CAR.ORIGIN.COUNTRY ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ TYPE=DATA, COLUMN=N1, DRILLTHROUGH=DOWN( \ CAR.ORIGIN.COUNTRY=N1 \ ), $ ENDSTYLE END SET COMPONENT='report2' -*component_type report TABLE FILE CAR PRINT CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST CAR.BODY.SALES BY LOWEST CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON CAR.ORIGIN.COUNTRY PAGE-BREAK ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ TYPE=DATA, COLUMN=N2, DRILLTHROUGH=DOWN( \ CAR.COMP.CAR=N2 \ ), $ ENDSTYLE END SET COMPONENT='report3' -*component_type report TABLE FILE CAR PRINT CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST CAR.BODY.SALES BY LOWEST CAR.ORIGIN.COUNTRY NOPRINT BY LOWEST CAR.COMP.CAR BY LOWEST CAR.CARREC.MODEL ON CAR.COMP.CAR PAGE-BREAK ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END COMPOUND END