Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EMBEDHEADING?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] EMBEDHEADING?
 Login/Join
 
Expert
posted
Is there a known issue with EMBEDHEADING? Or, perhaps, an additional counter-part to this setting which counter acts the ill affects shown in the below image?

I need to have a link in the heading of a chart without scrollbars. This fex, of a production version, not the CAR file, will reside in a portal. The scrollbar renders it unacceptable.

Is there a 'counter-part' to it that would produce the HEADING as seen in the image on the right while not displaying the scrollbars?

The below image shows it set to ON and OFF. both are unacceptable.


Link to image.


Sorry, the image shows the incorrect % Profit. The code below has been modified to display the correct % Profit.
So, ignore the Profit in the images as they do not affect the issue with the HEADING and Scrollbar.

The Code: Run it with &EmbedHeading -SET to ON and OFF to see for yourself.
-SET &EmbedHeading = ON ;
-SET &EmbedHeading = OFF ;
-SET &ECHO = ALL;
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE
SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT
SET EMBEDHEADING=&EmbedHeading.EVAL
-*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 CAR
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit: EmbedHeading = &EmbedHeading"
SUM DCOST/D12.2M AS 'Dealer'
    RCOST/D12.2M AS 'Retail'
-* Code Correction:
COMPUTE PCT_PROFIT/D12.2% = ((RCOST - DCOST) / DCOST ) * 100 ; AS 'Profit'
BY MODEL
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT 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 GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $

TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $

TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1),
     FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/EMBEDHEADING_Sample.fex, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getY1MajorGrid(),false);
setSeriesType(0,1);
setSeriesType(1,1);
setSeriesType(2,2);
setDisplay(getLegendArea(),true);
setLegendPosition(2);

setMarkerShape(getAllSeries(),2);
setMarkerSizeDefault ( 50 );

setMarkerShape(getAllSeries(),13);
setMarkerShape(getSeries(0),3);
setMarkerShape(getSeries(1),13);
setMarkerShape(getSeries(2),2);

setFillColor(getSeries(1),new Color(39,107,175));
setTransparentBorderColor(getSeries(1), true);
setFillColor(getSeries(0),new Color(155,216,119));
setTransparentBorderColor(getSeries(0), true);
setFillColor(getSeries(2),new Color(0,0,0));
setTransparentBorderColor(getSeries(2), true);

setLabelStagger(getO1Label(),false);
setConnectLineMarkers(true);
setTextFormatPreset(getY1Label(),15);
setTextRotation(getO1Label(),3);
setTextFormatPreset(getY2Label(),28);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 1);
*GRAPH_JS_FINAL
"xaxis": {
    "title": {
        "visible": false
    }
},
"pieProperties": {
    "holeSize": "0%"
},
"agnosticSettings": {
    "chartTypeFullName": "Bar_Clustered_Dual_Axis"
}
*END
ENDSTYLE
END

As always, Thanks.
Doug
Using 8202M, Thinking about 8203M...

This message has been edited. Last edited by: FP Mod Chuck,


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Smiler I got it to work using a sample fex in the GUI.
Frowner But don't really understand how it's working.

Any explanations or directions to associated information are welcome.
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
What did you do ?

I'm intrigued.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
We had that problem.
The reason is that by not indicating the "EMBEDHEADING" is adding the size of the graph plus the size of the header, which generates the scrollbar.

In your case I would have considered several options:
- Using HTML indicate: overflow-y: hidden;
- Change the height of the graph (this does not work in all cases, because in some places it takes into account the height of the FEX to put the HTML size).
- Put it with EMBEBED + link via HTML "floating" with HTML code. Remember that you can dynamically generate that link using a webfocus variable.


WebFOCUS 8

Windows, All Outputs
 
Posts: 7 | Registered: April 20, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
MMoreno: This needs to be, and can be, done within a single fex. I know that We can do that in WebFOCUS!.

Waz: I created a very basic GRAPH in text with the heading that I wanted and an associated drilldown. Ran it. Opened it in the GUI. Saved/Exited. It was fine.
Starting/Base Fex - Pre-GUI
 
GRAPH FILE CAR
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit (Pre-GUI)"
SUM DCOST/D12.2M AS 'Dealer'
    RCOST/D12.2M AS 'Retail'
COMPUTE PCT_PROFIT/D12.2% = ((RCOST - DCOST) / DCOST ) * 100 ; AS 'Profit'
BY MODEL
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $

TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $

TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1),
     FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/CAR_File_FP_Base.fex, $
ENDSTYLE
END

Starting/Base Fex - Post-GUI
-TYPE *** CAR_File_FP_Base (Post-GUI) ***
-SET &ECHO = ALL ;
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT 
-**** I removed these lines for brevity ***
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET ARGRAPHENGINE=JSCHART
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 CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.RETAIL_COST/D12.2M AS 'Retail'
CAR.BODY.DEALER_COST/D12.2M AS 'Dealer'
COMPUTE PCT_PROFIT/D12.2%=( ( RCOST - DCOST )/DCOST ) * 100 ; AS 'Profit'
BY CAR.CARREC.MODEL
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit (Post-GUI)"
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
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
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $
TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1), FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/CAR_File_Base_GUIed.fex, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH


I really done want to do this each time I need this functionality. However, I do keep one as a base and plagiarize as needed.

~ Doug
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
I guess you haven't spotted what made it work ?
The difference between your old one and the GUI massaged new one.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
I Do see the big difference between the Pre-GUI an Post-GUI versions. But, what is it, exactly, that makes it happen? Confused
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EMBEDHEADING?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.