Wednesday, 24 July 2013

BI Publisher Graph Formatting Part 2

In BI Publisher Graph Formatting Part 1 We made some changes to line graph now to moving ahead.

Now as you can see the below mentioned graph in which the x-axis label are horizontal and are overlapping each other. 
 
In rtf template while creating BI Publisher report it is working dynamically but if we want to show the x-axis label vertically we can do so for the same we will make some changes in the Advanced tab of charts.Please enter the below code after the tag <LegendArea visible="true" />. 

<O1TickLabel textRotation="TR_HORIZ_ROTATE_90" automaticRotation="AR_NO_ROTATE"></O1TickLabel> 

After making the changes mentioned above you will find that the x-axis label are now vertically displayed.
   


Now much of the formatting is done but now if we want to see the y-axis label without the scale factor the need to make some changes with respect to the scale we can do that too. 
For making the changes with respect to the scale of y-axis please use the following code in the advance tab and place it before the <LocalGridData> 
<Y1Axis><ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1Axis> 

So after placing the above code please see below the graph changed as shown below:
 

Now similarly if you want to make the changes with respect to the values on the line graph you can make that change too. 
For the same please use the below mention code in the advance tab. And place it after the <MarkerText visible="true" markerTextPlace="MTP_OUTSIDE"> tag. 
<Y1ViewFormat><ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1ViewFormat> 

After making the above changes the graph will reflect as shown below.
 

For doing the same please use the below mention code in the advance tab and place it before the <LocalGridData>    
Now we will move towards the next step i.e if we want to show the values on the y-axis i.e Revenue using Currency symbol we can do that too also. 

<Y1Axis><ViewFormat numberType="NUMTYPE_CURRENCY" currencySymbol="$"  numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1Axis> 

So after making the changes mentioned above you will find that the currency symbol has been seen in the graph.
   

As you can see we have made some many changes in the graph and this same logic can be used in other graphs also. 
So now in my next blog will be coming up with something more on graphs and at the same walking you through the steps of implementing the bursting in BI Publisher.  
So please wait for the same…………….