Posts

These product is going to be brought very sooner

XSL FO Editor for reporting http://www.xslfast.com/products/ www.stylusstudio.com/xsl_fo_processing.html www.oxygenxml.com/fo_editor.html http://www.editix.com/gallery.html http://logixml.com/ Need one stop Oracle HCM reporting ? Here http://www.polarisassociates.com/prod_report_hcm.htm

Row fillers in BIP.

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

Pass concurrent program parameter to report

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.

trying to keep me busy ,. as always the natural way , i live

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

Grand Total, so many time, i work with same code, so thought post here in blog

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

sub-total and grand-total

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

Issue in using xdofx:round fn , but not exactly

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