WebFOCUS Blogs

Many times while working on the projects, we face some small issues which takes a long time to fix it or achieve the requirement even if it looks very small. For example concatenation of 2 columns seperated by a '-' and it should contain 1 space between '-' and second column. It looks very small but when I tried to do that, it took me a long time to find out a very simple solution. There are many example like that. I want to share such things with you which I faced in my day to day coding. Concatenation with space:   You can either do it in define or compute as given below: COUNTRY_CAR/A50=CAR||(' - ' |COUNTRY); User defined function in WebFOCUS:  If we need to perform repeative set of statements again and again, user defined funtion is a very good approach. Below is a simple example of function ADDNO to add 2 numbers and return the output: DEFINE FUNCTION ADDNO(NO1/D20.2, NO2/D20.2) ADDNO/D20.2 = NO1+NO2; END -RUN TABLE FILE CAR PRINT COUNTRY ...

We do create lot many report and many of them do have Subtotals and Grand total. Subtotals are mainly required in Sales, finance & accounting and in most of the reports where there are more factual data in the report. Surprisingly we always gets confused about the difference between SUB-TOTAL and SUBTOTAL & SUMMARIZE and RECOMPUTE. Now lets see what is the differences in between these: SUB-TOTAL and SUBTOTAL: 1) You can use the SUBTOTAL and SUB-TOTAL commands to sum individual values, such as columns of numbers, each time a named sort field changes value.  2) SUB-TOTAL displays a subtotal for all numeric values when the sort field changes value, and for any higher-level sort fields when their values change.  3) SUBTOTAL displays a subtotal only when the specified sort field changes value. It does not give subtotals for higher-level fields.  4) Both SUB-TOTAL and SUBTOTAL produce grand totals. You can suppress grand totals using the NOTOTAL command.   ...

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-...

In my Recent project, I had a requirement where I had to show subtotal based on the selection from launch page. And the Sub Total had both total as well as %'s to display. The percentage was nothing but for example. 100*Sum(Column A)/Sum(Column B). I thought to share this with all of you since it can be reused for similar requirement and can help others to save lot of time.  This situation could have handled by using RECOMPUTE (ON TABLE RECOMPUTE "OR" ON SORT_COLUMN  RECOMPUTE) concept. However there were some challenges with that.  1) First issue was when we do RECOMPUTE all the numeric columns will get RECOMPUTEd. So if RECOMPUTE is needed to only selected columns, all other should be changed to alpha format. That is not a feasible approach according to me.  2) If all alpha columns in the report are not sorted, Sub Total row will be coming in 2 rows. That is another issue. So to avoid RECOMPUTE and use SUBFOOT (which I prefer most because of it's flexibili...

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...

Have you worked on creating graphical reports in WebFOCUS? Do you want to use google high charts in your WebFOCUS reports? The reason I like WebFOCUS over other reporting tool is it's adaptability and flexibility to integrate with other codes. You can write HTML, javascript, XML, Unix and lot more codes into your webFOCUS procedure. I was working on a POC with my colleague to implement google charts with webFOCUS. The Reason I chose that is because of look and feel on how chart is drawn on step by step basis. Just try it running once. It looks awesome.  Below are the code for data creation file(chart_data.fex) and highchart_test.fex: Fex File for Data -* File chart_data.fex TABLE FILE CAR SUM  SALES DEALER_COST BY COUNTRY -*WHERE FLG EQ 1 ON TABLE PCHOLD FORMAT XML END -****************************************************** Fex file for highchart -* File highchart_test.fex -HTMLFORM BEGIN <html xmlns="http://www.w3.org/1999/xhtml">   <hea...

In our day to day coding in WebFOCUS we would have used DEFINE and COMPUTE many a times. Even if you go for an interview this is the most common question (More than 90%). Surprising fact is there are many who cannot answer this question properly. Answering this question doesn't guaranty you the job but it is expected from a WebFOCUS developer to know the difference. First of all what is DEFINE and COMPUTE in WeBFOCUS term? The Answer is simple. Both does create virtual fields. They are used in WebFOCUS to perform calculated fields. Now when both does calculation, why do we have 2 options to do that? There are few differences listed below: 1) Calculation using DEFINE is on row by row basis meeting the selection criteria and Calculation using COMPUTE is done when all aggregation and sorting is done. For example- if the database has 100000 records for sales transaction and we want to aggregate it by 4 Regions. In case of DEFINE the calculation will happen 100000 times however ...