IBI WebFOCUS - Formatting Graphs using reusable fex file and stylesheet

Some times while creating a graph using web focus code we face problems in formatting the graph. For example – graph title, Font size, font name, Y-axis title, legend position, label rotation etc. To save the time in searching these things the below codes will be very useful.

 We just need to set the values as we want in the graph in set_values.fex and we can include the set_values.fex file to the fex file in our code before GRAPH FILE FILENAME command.

And second fex reuse.fex we need to include after ON GRAPH SET GRAPHSTYLE * command (you can also put the reuse.fex codes to reuse.sty and include it at the same position).

 Code for set_values.fex:

 -*Set the value for the graph Title
-DEFAULT &GRAPH_NAME='XYZ';

 -*Set the value for X-axis Title
-DEFAULT &O1_TITLE='ABC';

 -*Set the value for Y1-Axis title
-DEFAULT &Y1_TITLE='ABC';

 -*Set the font Name for X-axis
-DEFAULT &O1_label_n='Arial';

 -*Set the font Size for X-axis
-DEFAULT &O1_label_s=10;

 -*Set the font Rotation for X-axis
-DEFAULT &O1_label_rot=1;

 -*Set staggered value as true if you want staggered otherwise give false for X-axis
-DEFAULT &O1_label_sta='true';

 -*Set the font Name for Y1-axis
-DEFAULT &Y1_label_n='Arial';

 -*Set the font size for Y1-axis
-DEFAULT &Y1_label_s=10;

 -*Set the font Name for Legend
-DEFAULT &LEGEND_FONT='Arial';

 -*Set the font size for Legend
-DEFAULT &LEGEND_SIZE=10;

 -*Set the legend position for the graph you can give values as 1,2,3 or 4 based on your requirement
-DEFAULT &LEGEND_POSITION=1;

 -*Set the font Name for Footnote
-DEFAULT &FOOT_FONT='Arial';

 -*Set the font size for Footnote
-DEFAULT &FOOT_SIZE=10;

 -*SET &FLG_Y2 as 'Y' if you want Y2 axis also in your Graph
-DEFAULT &FLG_Y2='N';

 -*Set the value for Y2-Axis title
-DEFAULT &Y2_TITLE='ABC';

 -*Set the font Name for Y2-axis
-DEFAULT &Y2_label_n='Arial';

 -*Set the font size for Y2-axis
-DEFAULT &Y2_label_s=10;

 -*Set &LINE_WIDTH as 1,2,3,4 etc. if you are using line in the graph to set the width of the line
-DEFAULT &LINE_WIDTH='';

 -*Set the &LINE_SERIES as 0,1,2,3 etc. for making the styling on the graph
-DEFAULT &LINE_SERIES=1;

 -*Set &MARKER_SHAPE as 1,2,3,4 etc. to give the shape to marker based on the requirement

-DEFAULT &MARKER_SHAPE=1;
*****************************************************

 Code for reuse.fex:

 -*After Setting all the above parameter the user can include this fex file in his fex
-*----------For Setting the graph name-------------------
setTextString(getTitle(),"&GRAPH_NAME.EVAL");

 -*----------For Setting X-axis Title---------------------
setTextString(getO1Title(),"&O1_TITLE.EVAL");

 -*----------For Setting Y1-axis Title---------------------
setTextString(getY1Title(),"&Y1_TITLE.EVAL");

 -*----------For X-axis labels----------------------------
setFontName(getO1Label(),"&O1_label_n.EVAL");
setFontSizeInPoints(getO1Label(), &O1_label_s.EVAL);
setLabelStagger(getO1Label(),&O1_label_sta.EVAL);

 -*----------For X-axis labels Rotation--------------------
setTextRotation(getO1Label(),&O1_label_rot.EVAL);

 -*----------For Y1-axis labels----------------------------
setFontName(getY1Label(),"&Y1_label_n.EVAL");
setFontSizeInPoints(getY1Label(), &Y1_label_s.EVAL);

 -IF &FLG_Y2 EQ 'N' GOTO SKIP_Y2;
-*----------For Setting Y2-axis Title---------------------
setTextString(getY1Title(),"&Y2_TITLE.EVAL");

 -*----------For Y2-axis labels----------------------------
setFontName(getY1Label(),"&Y2_label_n.EVAL");
setFontSizeInPoints(getY1Label(), &Y2_label_s.EVAL);

 -SKIP_Y2

 -*-----------Formatting Legends--------------------------
setFontName(getLegendText(),"&LEGEND_FONT.EVAL");
setFontSizeAbsolute(getLegendText(), true);
setFontSizeInPoints(getLegendText(),&LEGEND_SIZE.EVAL);
setPlaceResize(getLegendText(),0);
setFontStyle(getLegendText(),2);

 -*-----------Legends Position-----------------------------
setLegendPosition(1);

 -*-----------Formatting Footnote--------------------------
setFontName(getFootnote(),"&FOOT_FONT.EVAL");
setFontSizeAbsolute(getFootnote(), true);
setFontSizeInPoints(getFootnote(), &FOOT_SIZE.EVAL);
setPlaceResize(getFootnote(), 0);

 -IF &LINE_WIDTH EQ '' GOTO SKIP_WIDTH;
setLineWidth(getSeries(&LINE_SERIES.EVAL),&LINE_WIDTH.EVAL); 
setMarkerShape(getSeries(&LINE_SERIES.EVAL),&MARKER_SHAPE.EVAL);
-SKIP_WIDTH

******************************************************************************

 Any suggestions are always welcome. Happy Coding in WebFOCUS.

Comments

Post a Comment

Popular posts from this blog

IBI WebFOCUS - Functions available and syntax to use

Using Functions Functions operate on one or more arguments and return a single value. The returned value can be stored in a field, assigned to a Dialogue Manager variable, used in a calculation or other processing, or used in a selection or validation test. Functions provide a convenient way to perform certain calculations and manipulations. There are two types of functions: Internal functions. Built into the WebFOCUS language, requiring no extra work to access or use. The following reporting and Maintain functions are internal functions. You can not replace any of these internal functions with your own functions of the same name. All other functions are external. ABS ASIS DMY, MDY, and YMD DECODE EDIT FIND LAST LOG LOOKUP MAX and MIN SQRT All Maintain-specific functions External functions. Stored in an external library that must be accessed. When invoking these functions, an argument specifying the output fie
Read more

IBI WebFOCUS - Difference (Preference) between Join and Match:

For most of the reports in our WebFOCUS reporting world, we usually pull data from multiple tables and and generate the report. We all know that we can either Join Data Sources(JOIN) or Merge Data Sources(MATCH) to create report from multiple tables. Which one to choose from JOIN and MATCH? Now the question is what is the diffrence between the two and which one to choose from the 2 option. To explain this let's understand how does they process. JOIN: Basically JOIN is temporary, virtual connection between 2 or more physical or logical sources. Data in the first data source (host file) determines which records are retrieved from cross-reference file. When a record from the host file of a one-to-many join has no corresponding record(s) in the cross-reference file, the record is automatically excluded from the report output.  To control this, you can SET ALL to ON, in which case records from the host file, without corresponding records in the cross-reference file, will be disp
Read more

IBI WebFOCUS - Testing and Debugging in WebFOCUS codes

You can debug a Web FOCUS application by querying your environment to display information such as file status, release, server information, and joins, as well as by identifying files you are using. Other debugging methods are available in Web FOCUS, including specialized Dialogue Manager Variables and traces performed from the Web Console. Debugging Your Application with Query Commands You can use query commands to display information about your metadata, data sources, language environment, Developer Studio, and Web FOCUS. This is useful for determining any aspects of your application that may be preventing the proper behavior of your application. You can query your environment with a query command executed in Developer Studio or Web FOCUS. The result of a query command is returned in your browser window or as a comment in the HTML file. Use the applicable Web browser functions to view the HTML comments (for example, View Source in Microsoft Internet Explorer). How to Issue
Read more