Never name it.

Some thought about the report, where Tim sir himself has explained thousand time, iam doing it for thousand and one time :0) You want to display all the rows continuously and then then if the row end in mid of the page, still you want the total to be displayed at the end of that page. To make you understand better,How to do you say its, at the end of the page. Last page content only in 5.6.2 BIP , we can use here :) The smart way is we can identify how to achieve that is, we got the control of rows running through pages, and if we can decide that a page is going to take 20 rows, that means , 20 th row is the end of the page. So, what you want to decide is , how much row a page can contain, if probably the page is going to take 20 rows, fix as 16 rows, in order to accommodate some expansion in row height due to wrap you worried abt. so, the logic goes here, go with the same approach as the TIM's and then when the row ends, find out how many rows have been printed in that particular ...

Put this in your template in the starting, where the P_BUSINESS_GROUP_ID is one of the concurrent program parameters, ?param@begin:P_BUSINESS_GROUP_ID? and then you can access the parameter in your rtf like Upload the rtf template back into apps. and then rerun the conc pgm :) Tim, has his own blog :) written to do t his.

Link to thread BIP Sample XML. [subt] [ASET] [AA]1[/AA] [AA]2[/AA] [AA]3[/AA] [AA]4[/AA] [/ASET] [BSET] [BB]1[/BB] [BB]2[/BB] [BB]3[/BB] [BB]4[/BB] [/BSET] [/subt] ASET = [?sum(subt/ASET/AA)?] BSET = [?sum(subt/BSET/BB)?] TOTAL SET = [?sum(subt/ASET/AA) + sum(subt/BSET/BB)?] Rsult : ASET = 10 BSET = 10 TOTAL SET = 20

Link of BIP XML ------------------------------------- [ROWSET] [ROW] [DRIVER_KEY]441[/DRIVER_KEY] [INDUSTRY]Motor vehicle & parts dealers[/INDUSTRY] [YEAR]2005[/YEAR] [MONTH]March[/MONTH] [COST]75770[/COST] [AMOUNT]1000[/AMOUNT] [/ROW] [ROW] [DRIVER_KEY]441[/DRIVER_KEY] [INDUSTRY]Furniture & home furnishings stores[/INDUSTRY] [YEAR]2005[/YEAR] [MONTH]March[/MONTH] [COST]8804[/COST] [AMOUNT]1000[/AMOUNT] [/ROW] [ROW] [DRIVER_KEY]443[/DRIVER_KEY] [INDUSTRY]Electronics & appliance stores[/INDUSTRY] [YEAR]2005[/YEAR] [MONTH]March[/MONTH] [COST]8292[/COST] [AMOUNT]1000[/AMOUNT] [/ROW] [ROW] [DRIVER_KEY]443[/DRIVER_KEY] [INDUSTRY]Electronics & appliance stores[/INDUSTRY] [YEAR]2006[/YEAR] [MONTH]March[/MONTH] [COST]6000[/COST] [AMOUNT]1000[/AMOUNT] [/ROW] [ROW] [DRIVER_KEY]441[/DRIVER_KEY] [INDUSTRY]Electronics & appliance stores[/INDUSTRY] [YEAR]2006[/YEAR] [MONTH]March[/MONTH] [COST]4000[/COST] [AMOUNT]1000[/AMOUNT] [/ROW] [/ROWSET] -------------------------------------...

Link for thread in forum To get the sub-total and grand-total for xml, which has been grouped by two level. example is here [Root] [item] [item_detail]WORKER[/item_detail] [amount]100[/amount] [/item] [item] [item_detail]WORKER[/item_detail] [amount]100[/amount] [/item] [item] [item_detail]WORKER[/item_detail] [amount]100[/amount] [/item] [item] [item_detail]WORKER[/item_detail] [amount]100[/amount] [/item] [item] [item_detail]WORKER[/item_detail] [amount]100[/amount] [/item] [item] [category]car[/category] [item_detail]LABOUR[/item_detail] [name]one[/name] [amount]100[/amount] [/item] [item] [category]car[/category] [item_detail]LABOUR[/item_detail] [name]two[/name] [amount]100[/amount] [/item] [item] [category]phone[/category] [item_detail]LABOUR[/item_detail] [name]three[/name] [amount]100[/amount] [/item] [item] [category]parts[/category] [item_detail]LABOUR[/item_detail] [name]four[/name] [amount]100[/amount] [/item] [item] [category]parts[/category] [item_detail]LABOUR[/item_deta...

Did you guess what caused issue, The usage of XDOFX i n both the places has caused the issue, its a single command and remember your are enclosing it in so , i guess the context is getting lost if we use it multiple times in same command. . ?xdofx:round(100.1090,2) + xdofx:round(100.9098,2)? for this NULL ?xdofx:round(100.1090,2) +round(100.9098,2)? for this 201.*******

Bascialy , the numbers should be in raw format in xml, so that BIP engine applies or calculates what ever we needed, and for display purpose in RTF template , we can add the formatting. But, Even if the xml contains p re-formatted tags like this. SAL>10,000,000.00 Use translate to remove all the comma's if you use this translate and pass translate(SAL,',','') , the output is 10000000.00, which looks as raw. now you can generate the xls from this. cant we ? ?format-number: translate('10,000,00.00',',','');'PT999G999D99;( PT999G999D99)'?

After running your report, the report creates you the file type you wnted, but how to coonfigure Oracle apps to make it understand and open in respective editor . Here is the solution. How to Setup The Report Output to Different Viewer Types in Oracle Applications 11i -Doc ID: Note:184375.1

Rounding Issue in Decimal Numbers XMLP Problem: The field is PaymentAmount/Value*100 and for a value of 8397.71 the result is comming out as 839770. Solution: ?(round((8397.71)*10000) div 100)? == gets you 839771 Well its not the solution , but a workaround to get it done. BIP Fix not yet available.

ha ha h ah ahha hah Tim has taken my entry from forum thead and updated in his blog for an entry. Thanks to Tim for this. As i mentioned in the forum thread, there are many ways to do this. the another way is :). You can do this in this way too. create a table with two rows and two column, in the first row give the heading for the each column as TEXT and ID In the second row, first column, type this ""?for-each:LINE_ATTACHMENTS/TEXT? ?.?"" in the second row, second column, type this ""?following-sibling::.[1]? ?end for-each?"" Longtime back I had a colleague named "James" who had a similar requirement, i helped him little bit. But i did not follow-up with him, hope he got the solution what he wanted.

Chandamama was/(is) a monthly magazine , which i njoyed longtime ago. Its good to see its back with a bang, Kudoos to the management people who are working very actively to take that to next lvl to Web. It was a wonderful monthly magazine, which gave lot of tit-bits . To mention few especially everybody know Mr.Tenali , the way it got narrated was amazing . I guess lot of good and great publications got smashed to this web/commercial world, iam not able to re-collect them, i think there were some bi-weekly magazine which used to give scientific facts , inventions, etc.. in kiddo language. May be the management who were handling went out of idea's to improve them or were not able to make it due to financial crisis{i am sure in the world there are so many venture drives who can pump-in money easily for these kind of projects}. Anyhow i assume they were not lost due to money management only:). I guess mainly due the policy followed by handing them over to their family members from the...