Never name it.

Multiple Line Chart in BI Publisher

2010-08-04T20:34:00.000+05:30

Here is a sample of how do you do Line-stacked graph.

In BI Publisher menu, select chart and drag and drop the required column , do choose type of the chart as Line- Stacked.

xml is available in the forum post and here it is

Chart Data Values

2010-05-29T00:43:00.001+05:30

In Chart generated from BI Publisher, how do i show the data points in the chart.

Example, say on top of BAR being displayed,i want to display the data values.

Have answered this many times, but did not note it down for others to refer.

<MarkerText visible="true">
<Y1ViewFormat>
<ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" />
</Y1ViewFormat>
</MarkerText>

open the chart image in RTF, right click, format picture, got to ATL TEXT tab.
add the following text between the element.

http://forums.oracle.com/forums/thread.jspa?messageID=3595421&#3595421
http://forums.oracle.com/forums/thread.jspa?messageID=4093816&#4093816

Chart Title

2010-05-26T00:32:00.000+05:30

How to change the font and color in graph title

Here it is.

Use the Bi Publisher chart - option to change the fonts/color

Apply number locale dynamically

2010-04-21T19:42:00.000+05:30

Number format in Bi Publisher.

If i have a requirement to display different locale number format in same report, how am i supposed to do it.

Probably, the locale will be available in the xml itself, How do i use that display the number format for that locale correctly as needed.

Oracle has provided with number formatting function, i already have discussed few of them before.

There was a question about this in the forum.

Here is the real example of how to do it.

Row filters

2010-04-14T23:04:00.001+05:30

How do i suppress row in the loop in BIP ?

Obviously, we need to understand the condition what we need to apply.

Once you identify the condition , it just we need to apply on the loop.

One common mistake , people do is , they dont understand and write the conditions based on xml.

The xml element might not be under the parent on what they are looping.

So need to understand the xml structure to form the condition.

here is the sample

BIP Formatting

2010-04-07T22:44:00.000+05:30

Adding formatting is easier in BIP.
It can be done manually or automated through menu.

How to add the BIP formatting manually, here is an example.
Just add the logic and the formatting you needed.

How to add the BIP formatting through menu, here is an example.

use the Menu and choose conditional formatting

You have to select the data filed and choose the menu option conditional format

Conditional Formats

2010-04-07T22:10:00.000+05:30

Add the condition logic for you requirement inside the IF statement and END IF

Copyright Symbol is returning garbage character.

2010-03-23T08:21:00.002+05:30

Using the unicode character © to display the copyright symbol
introduces the extra character

Â©

How do we get rid of that character?
This Â is nothing but extra two bytes which comes with the default unicode encoding.

It is due, to the output we are generating from the BIP is UTF-8, and the explorer(IE,FIREFOX) we are viewing doesn't understand this.
So, we got to use different encoding to get the character displayed properly.

< xsl:output method="html" encoding="ISO-8859-1" />
would certainly help.

Just making this change, the character is render properly.

Excel Number

2010-03-22T20:44:00.004+05:30

How do i make the excel sum work on the XLS output obtained from BI Publisher ?

You have make use of the template better.

1. Do select the form-field by double clicking it
1.1. A property window will pop-up
2. Choose the number as the datatype for the field
3. Choose the Number format, you want to see as number.

Note: by default every other field could be String or Regular text.

Here is the small samples for it.

Text-Indent

2010-03-21T00:26:00.002+05:30

How do you do text-indent dynamically ?

here is the sample

Hyperlink

2010-03-21T00:09:00.002+05:30

How do you enable the hyperlink based on the element in XML ?

Hi Francisco,

Note:
your xml should only have
<URL>http://dbxserver.dbxprts.com:7778/pls/apex/f?p=134:1:::NO::P1_ID_CONSTANCIA:1183</URL>

Show me your sample XML , i can help you.

What is your expected output ? PDF or HTML ?

here it is.

option1:

If the XML data includes an element that contains a hyperlink , then you can use that element to create dynamic hyperlinks at runtime.
a. insert hyperlink from word menu
b. In the Type the file or Web page name field of the Insert Hyperlink dialog box, enter the following syntax:
c. {ELEMENT_NAME_WHICH_HAS_URL_LINK}
where ELEMENT_NAME_WHICH_HAS_URL_LINK is the xml data element name

option2:

create a form field, you can add it

<fo:basic-link external-destination="http://www.google..com">
<fo:inline text-decoration="underline">google Link</fo:inline>
</fo:basic-link>

or

<fo:basic-link external-destination="{ELEMENT_NAME}">
<fo:inline text-decoration="underline">google Link</fo:inline>
</fo:basic-link>

or

<fo:basic-link>
<xsl:attribute name="external-destination"><xsl:value-of select="ELEMENT_URL"/>
</xsl:attribute>
<xsl:value-of select="LINK_NAME"/>
</fo:basic-link>

Another Crosstab total

2010-03-19T23:50:00.003+05:30

Probably, it will look like duplicate entry of
http://winrichman.blogspot.com/2009/09/cross-tab-summation-in-rtf.html

This was a request from another user , he was interested in seeing the results on his xml data.
here it is.

Split List in to Multi-Column

2010-03-05T03:33:00.001+05:30

Ooops, this turning out be an example needed for each query i get.

Neway, i enjoy answering them.

Consider this request, you have list, but you dont want to put in one below other.

Rather, 4 in a row, or consider X in a row and rest X of them in next line and goes on.

You can do it in many ways.
First simple one would be have multiple for-each stmt's in each column.
Add a filter on mod, 1,2,3,4,...0
Note: 0 is on the last column.

Have a look at the snapshots, it is self-explanatory, i guess.

decimal separator

2010-03-04T04:51:00.005+05:30

How to change the grouping to decimal separator.

Here are few examples, how to do it.

There are more functions available, but these would be help to people who would love to start from simple.

Note : add the first two lines inside the form-field.

Another EFT

2010-02-27T04:43:00.005+05:30

There was a request, how to get the parent node and display it in each line of EFT.

here is the sample.

We can access the parent nodes, just by navigating to the one level up using command DOT DOT.

Hope this helps.

Sorting again

2010-01-14T23:39:00.006+05:30

Lots of BIP posts to be done, keeping myself busy nowdays.

Someone Was wondering in forum, need Explanation on how to use variable in sorting.

Well have a look at explanation on Forum to Sorting on template

Why not this way ?

1st option:

<?for-each:employee?>
<?sort: department?>

2nd option:
You got to understand,
if you assign a value to a variable , its a string 'department' which is being assigned.
what you are doing is using a variable in sorting which has string in it, but sort is expecting a element name from the current looping context

well, you can do all various complex sorting.. if you have requirement clearly.

ex. without changing sort code inside the loop, we can change the sorting column by parameterizing or hard coding at global level.

here is the example.

page total.

2010-01-06T02:52:00.007+05:30

Running Page total

How to get a running page total in BIP?

Inside the loop, create and add the page-variable


<?add-page-total:pt;'VAL'?>

And in the footer add the text to show the page level total.


<?show-page-total:pt;"99G999G999D00"?>

here is the sample example of all
Sub template
page total
pagebreak

BI Publisher CrosstabTotal

2009-11-09T21:45:00.003+05:30

Another request to get crosstab total in BI Publisher from forum.
Forum post

Just we need to map the column and row in old way.

Note: this is crosstab and latest BIP has the functionality of PIVOT table, which is more powerful than this.

sum total column in BIP pivot table

2009-10-27T21:25:00.003+05:30

For long long time, wanted to document this , but missed in my list.

In BIP 10.1.3.4 ++, new support was added to the crosstab and changed it to pivot table.
In order to use this functionality, the server has to be in latest or above 10.1.3.4++.

Reason: server support has been added to make it much better.

How does it work.
Forum question



<?crosstab:c45;"//ROW";"CodPais{,o=a,t=t}";"Pais{,o=a,t=t}";"Hombre,Mujer";"sum"?>
 
And use following in total,
 
<?$c45//M0/M1/T?> == Hombre
<?$c45//M0/M2/T?> == Mujer
c45 -- refers to the name of the table
R - refers to ROW
C - refers to column
o=a ==> order - ascending
t=t ==> datatype = text
"sum" ==> specifies the summary, you can use count, sum etc...
$c45//M0/M1/T - sum of Hombre element 
$c45//M0/M2/T - sum of Mujer element

PIE chart - Explode slice

2009-10-27T21:19:00.003+05:30

In the pie chart,
how to seperate the slices.

if there is a support to for a way to separate the slices in pie chart was the question in the forum.

Answer to this is a big YES :)

In order to "explode" pie slices, add the following lines in the "Graph Settings" under the graph element.


<SeriesItems>
<Series id="0" pieSliceExplode="100"/>
<Series id="1" pieSliceExplode="100"/>
<Series id="2" pieSliceExplode="100"/>
<Series id="3" pieSliceExplode="100"/>
</SeriesItems>


<Graph ...... pieDepth="25" pieTilt="25" ....> add this to your graph element attribute , to tilt the pie slices

Custom Scalefactor

2009-10-27T21:13:00.003+05:30

By default the Y or X -axis scale in my graph reads as 0K, 20K, 40K...
How to modify the scale to read 10000, 20000... or in some other custom formats?


<Y1Axis>
<ViewFormat scaleFactorUsed="true" scaleFactor="SCALEFACTOR_NONE" />
</Y1Axis>

Attribute scale factor can take one of the following values.
SCALEFACTOR_THOUSANDS |  SCALEFACTOR_MILLIONS | SCALEFACTOR_BILLIONS | SCALEFACTOR_TRILLIONS | SCALEFACTOR_QUADRILLIONS

Power of Inlines

2009-10-20T20:28:00.003+05:30

How to add the looping element in same line - horizontally ?

use @inlines command,in conjunction with for-each.
Here is the sample on how to do.

subtemplating

2009-10-16T11:08:00.007+05:30

Have a look at this,

just adding sub template and calling them based on the concurrent program parameter.


<?param@begin:ReportType;string(‘YS’)?>
<?choose:?>
<?when: $ReportType =’YES’?>
<?call:TC1?>
<?end when?>
<?when: $ReportType =’NO’?>
<?call:TC2?>
<?end when?>
<?otherwise:?>
<?call:TC2?>
<?end otherwise?>
<?end choose?>

Run with ReportType as NO or other than YES.
You should get the result as follows

Run with ReportType YES.
You should get the result as follows

Avery label Print Template

2009-10-07T19:50:00.009+05:30

How to create label using Avery template ?

Here it is
use the following xml

<Root>
<Row>
<Code>001</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>
<Row>
<Code>002</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>


<Row>
<Code>003</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>004</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>005</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>006</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>007</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>008</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>

<Row>
<Code>009</Code>
<Part>100</Part>
<Id>01</Id>
<Supplier>K0G</Supplier>
</Row>


</Root>

Use the following code in Template.


In the first shape add this
<?for-each@shape:/Root/Row[(position() mod 3) = 1]?><?Code?><?shape-offset-y:(position()-1)*72?><?end-for-each?>

In the second column shape add this
<?for-each@shape:/Root/Row[(position() mod 3) = 2]?><?Code?><?shape-offset-y:(position()-1)*72?><?end-for-each?>


In the third column shape add this
<?for-each@shape:/Root/Row[(position() mod 3) = 0]?><?Code?><?shape-offset-y:(position()-1)*72?><?end-for-each?>

Sample on how to do , have a look at this.

Cross tab Summation in RTF

2009-09-23T22:22:00.003+05:30

Crosstab report.

It can be done in many ways,
ideally people love to take some granular level data and manipulate and apply that in different template.
Advantage of granular level data :
We can use it for some other RTF template.
We can show that the way we need to.

If you pre-group, then your report will be faster.
But you use the flex of using the same data for showing it different layout.
since you pre-grouped it, its fixed data for some layout.
You use this flex here.

its a trade off on flex or performance,
i choose go on the balanced line of these two.

Forums thread with issue

1. it should be pretty simple in BIP template too.
2. have a look the thread link , i answered how to do it in Datatemplate.
3. Db rollup is also good option

but for the answer at OPTION 1 look at this picture.