As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
I need to export a JSChart to PDF via "SET GRAPHENGINE=JSCHART" and I'm very close. However my label in the last BY field is very long and I'd like to wrap it. I'm unsure how to do this via JSON/JSCHART when using BUCKET=row. Hoping someone can provide advice. Here's my CAR example below. I'd like to wrap text for the "BY CAR" field.
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET GRAPHENGINE=JSCHART
SET EMBEDHEADING=OFF
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='INCHES';
-DEFAULTH &WF_STYLE_HEIGHT='7.25';
-DEFAULTH &WF_STYLE_WIDTH='10.5';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
SUM
DEALER_COST
BY COUNTRY
BY HIGHEST SEATS
BY MODEL
BY CAR
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
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 BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TOPMARGIN=0.050000,
ORIENTATION=LANDSCAPE,
$
TYPE=DATA, COLUMN=N1, BUCKET=page, $
TYPE=DATA, COLUMN=N2, BUCKET=row, $
TYPE=DATA, COLUMN=N3, BUCKET=row, $
TYPE=DATA, COLUMN=N4, BUCKET=row, $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $
*GRAPH_SCRIPT
*GRAPH_JS_FINAL
"fill": {
"color": "white"
},
"pieProperties": {
"holeSize": "0%"
},
"blaProperties": {
"orientation": "horizontal"
},
"agnosticSettings": {
"chartTypeFullName": "Bar_Clustered_Horizontal"
}
*END
ENDSTYLE
END
-RUN