Never name it.

FAD movement [Month-over-Month, Average Move/Month] for EB2/EB3

Important Dates for H1B 2022

Looking forward for the new posts

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

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

How to change the font and color in graph title Here it is. Use the Bi Publisher chart - option to change the fonts/color

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.

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 .

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

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

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.

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.

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

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

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.

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.

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.

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.

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.

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