On October 8, 2007 I posted the following problem.
I am summing two defined percent fields in a Bubble Graph request. I am using the setTextFormatPreset(getY1Label(),2); and setTextFormatPreset(getX1Label(),2); When I use this percent format, my X and Y percents are being displayed as hundreds. If I sum and compute my percent calculations and divide them by 100, my X and Y percents display the way percents should display, but this distorts my ToolTip display. Is there anyway to display the Y and X axis as normal percents instead of percents displayed in hundreds? Thanks.
Tony A provided me with the following terrific solution that works fine. I am using this solution for my html bubble graphs.
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#\u066A");
What I have to do now is to convert my html bubble graphs into a pdf format image. When I run my program, the percentages for the X and Y axis are not appearing. Does the above two set commands apply only to html format? If so, is there a workaround for pdf format? Pasted below is the entire code that I am using. Thanks.
GRAPH FILE GPHHOLD
SUM
ADMITS_1000
COST_ADMITS
PMPM_12MR
SNAPSHOT_MO NOPRINT
ACROSS HGROUP
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH HOLD AS &TEMP1 FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setUseDefaultBubbleMarker(false);
setToolTipDisplay(true);
setToolTipMode(false);
setMarkerSizeDefault(100);
setUserToolTip("[SL] [R] Admits per 1000: [XV]% [R] Cost per Admit: [YV]% [R] PMPM: $[ZV] ");
setLegendAutomatic(true);
setLegendPosition(5);
setFontSize(getLegendText(),10);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setTextRotation(getX1Label(),0);
setTextRotation(getY1Label(),0);
setY1TitleDisplay(true);
setY1TitleString("Cost per Admit");
setY1TitleAutofit(false);
setFontSizeVC(getY1Title(),888);
setFontSizeVC(getY1Label(),888);
setX1TitleDisplay(true);
setX1TitleAutofit(false);
setX1LabelAutofit(false);
setFontSizeVC(getX1Title(),888);
setFontSizeVC(getX1Label(),888);
setX1MajorGridDisplay(false);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
-*Quadrant Lines to intersect at 0,0
setQuadrantLineValueX(0, 0);
setQuadrantLineValueY(0, 0);
setY1ScaleMaxAuto(false);
setY1ScaleMax(&BUBMAX_Y);
setX1ScaleMaxAuto(false);
setX1ScaleMax(&BUBMAX_X);
setTextFormatPreset(getX1Label(),-1);
setTextFormatPattern(getX1Label(),"#\u066A");
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#\u066A");
-SET &SIGN = IF (&BUBMAX_Y) OR (&BUBMAX_X) LE 1 THEN 'true' ELSE 'false';
setY1ScaleMaxAuto(&SIGN);
setY1ScaleMax(&BUBMAX_Y);
setX1ScaleMaxAuto(&SIGN);
setX1ScaleMax(&BUBMAX_X);
setAutofit(getTitle(),false);
setFontSize(getTitle(),12);
setFontSizeAbsolute(getTitle(),true);
setFontStyle(getTitle(),2);
setSubtitleDisplay(false);
setTitleString("Utilization and Cost (Admits)");
setRect(getTitle(),new Rectangle(-3888,11000,29806,1939));
setDisplay(getAnnotation(0), true);
setTextString(getAnnotation(0), "Admits per 1000");
setFillColor(getAnnotation(0), new Color(0,0,0));
setRect(getAnnotation(0),new Rectangle(-15999,-5000,30000,-5000));
setFontSizeAbsolute(getAnnotation(0),true);
setFontSizeInPoints(getAnnotation(0),9.0);
setFontStyle(getAnnotation(0),2);
-*setFontStyle(getY1Label(),2);
-*setFontStyle(getX1Label(),2);
setToolTipFontSize (12);
setToolTipFontStyle(3);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
BOTTOMGAP=0.054889,
SIZE=10,
FONT=ARIAL,
TITLETEXT=' ',
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
BOTTOMGAP=0.054889,
$
TYPE=HEADING,
BACKCOLOR='BLUE',
$
TYPE=FOOTING,
BACKCOLOR='NONE',
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=FOOTING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
LINE=5,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
LINE=6,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
ENDSTYLE
END
-RUN
TABLE FILE GPHHOLD
ON TABLE SUBHEAD
"
- <+0> Inpatient <+42 PA"
"Utilization and Cost Trends (Admits) - Medical/Surgical/ICU Rollup"
ON TABLE SUBFOOT
"32"
-INCLUDE app/footerfe.fex
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.000000,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=12,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TABHEADING,
BACKCOLOR=BLUE,
COLOR=WHITE,
$
TYPE=TABFOOTING,
LINE=34,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
LINE=35,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
LINE=36,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=REPORT,
IMAGE=&SVG1,
POSITION=(0.597222 1.241667),
SIZE=(8.375000 4.166667),
$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
-*&&HOLD
END
-RUN
Webfocus version 7.1.7/Windows XP