BI Publisher - Functions

Card Puncher Data Processing


For use in RTF templates, BI Publisher has extended a set of SQL and XSL functions .



For extended SQL functions, the syntax is:



For extended XSL functions, the syntax is


You have more detail in the documentation but not all. Here below is a Java Doc only for extended XSL functions with all the detail for the version.


In my dataset I have COL4 and COL5. I would like to calculate the difference between these 2 columns an put this in a new column. The function to do this is:


Documentation / Reference

Discover More
Card Puncher Data Processing
Business Intelligence Publisher

BIP is a highly scalable reporting engine capable of generating pixel perfect reports from multiple data sources in multiple formats via multiple delivery channels. Bi Publisher is based on the Apache...

Share this page:
Follow us:
Task Runner