ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE ibisamp/car -* Created by Info Assist for Graph SUM CAR.BODY.DEALER_COST BY CAR.COMP.CAR WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(FIND IBISAMP/CAR.ORIGIN.COUNTRY IN IBISAMP/CAR |FORMAT=A10,SORT=ASCENDING,REQUIRED=TRUE).COUNTRY:.QUOTEDSTRING; HEADING "COUNTRY: <CAR.ORIGIN.COUNTRY<+0> " "TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> " "TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> " " " ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH PIE ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setCurveFitEquationDisplay(false); setPlace(true); setPieFeelerTextDisplay(1); *END INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ TYPE=DATA, COLUMN=N1, BUCKET=color, $ TYPE=DATA, COLUMN=N2, BUCKET=measure, $ TYPE=HEADING, JUSTIFY=LEFT, $ TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=1, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=1, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=4, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "65%" }, "agnosticSettings": { "chartTypeFullName": "Pie_Ring" } *END ENDSTYLE END -RUN
quote:"COUNTRY: <CAR.ORIGIN.COUNTRY<+0> " "TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> " "TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> "
quote:Originally posted by BabakNYC:ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE ibisamp/car -* Created by Info Assist for Graph SUM CAR.BODY.DEALER_COST BY CAR.COMP.CAR WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(FIND IBISAMP/CAR.ORIGIN.COUNTRY IN IBISAMP/CAR |FORMAT=A10,SORT=ASCENDING,REQUIRED=TRUE).COUNTRY:.QUOTEDSTRING; HEADING "COUNTRY: <CAR.ORIGIN.COUNTRY<+0> " "TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> " "TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> " " " ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH PIE ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setCurveFitEquationDisplay(false); setPlace(true); setPieFeelerTextDisplay(1); *END INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ TYPE=DATA, COLUMN=N1, BUCKET=color, $ TYPE=DATA, COLUMN=N2, BUCKET=measure, $ TYPE=HEADING, JUSTIFY=LEFT, $ TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=1, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=1, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=2, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=3, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ TYPE=HEADING, LINE=4, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "65%" }, "agnosticSettings": { "chartTypeFullName": "Pie_Ring" } *END ENDSTYLE END -RUN
quote:Originally posted by DWaybright:
BI Dev,
In case you got lost in the code BabakNYC posted, you want to put your fields in the header, like BabakNYC put in HEADING:quote:"COUNTRY: <CAR.ORIGIN.COUNTRY<+0> " "TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> " "TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> "
Use the < sign before the field name.