XSLT extended functions

We will look at the function which are available to us in BI Publisher. All the function should be begin with xdoxslt:{function_name}

To start with , here are few.



Comments

gemjohny said…
Hey Vetri,
Nice blog buddy.. Thanks for the post..

Have a quick question
I have a date in the format '14-MAR-09' in the XML.. I dont have the luxury to change the data source as it refers to C, Pro*C, Oracle Reports, Spawned programs.. wat not !!! Hence thought of formatting at the template layer. but the to_date function doesn't work with this format '14-MAR-09', How do I convert this to the canonical format so that I can format it properly...

--Anto
Wed Mar 18, 06:15:00 AM 2009
Post a Comment

Popular posts from this blog

Repeat Table Header in all pages in BIP

how to repeat the column titles on a table in all pages if the table extends over several pages What you need to is: 1. Select and Highlight the table header row 2. Right click and select table properties 3. On the Row tab properties , specify that the header row should be repeated on every page 4. Save the RTF 5. BIP looks at the properties of the word settings for the table and will repeat the header row on every page the table needs. This works so well in PDF output, but RTF output seeems to have some issue with this header repeat functionality We all can beleive, In future releases this bug won't be there ;)
Read more

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below
Read more

Hyperlink

Image
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...
Read more