Posts

Showing posts from March, 2010

Copyright Symbol is returning garbage character.

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

Image
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

Image
How do you do text-indent dynamically ? here is the sample

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

Another Crosstab total

Image
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

Image
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

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