Thank you, it has been very helpfully, just a question exist a function or sometime close to the NVL function in rtf template, i mean the template put a zeros in the fields of null values (blank fields), thank you
Very Helpful. But I am curious to know how you generated the xml file in BIP which was giving you state level tax info in hierarchial mode and not in traditional relational form. Can u give sample query/ reference link pls.
I used the rowset method to create the XML File. Take a look at the post here for details: peopletoolstechtips.com/create-an-xml-file-with-peopletools-using-the-rowset-method/ You can also download the tools project and see all the code including creating the XML file if you import it into a PUM or a DEV environment (HCM)
You could add a new field to your XML File and assign 60k rows of data to that tag value. Add a new value for each 60K. Then page break on that tag value. I would use the RowSet method to create this file
Amazing work, one of the most clearly explained and that too free of cost. Thanks a ton and best wishes!
Thank you so much it was very good and clear explanation i didnt find in any of the channel .. it is so helpful to me ....
Glad it helped!
We're going to be posting a lot more info about working with BI Publisher in PeopleTools... and other subjects.
So stay tuned
- Randy
@@PeopleToolsTechTips i used it for oracle bip report...
It has been really helpfully. Thank you so much!
Glad it helped!
Thank you! it's a very useful video.
Thank you, it has been very helpfully, just a question exist a function or sometime close to the NVL function in rtf template, i mean the template put a zeros in the fields of null values (blank fields), thank you
Look into the conditional areas of the RTF template. If the value is zeros, don't show the zeros or show an alternate value to the user when zero
Very Helpful. But I am curious to know how you generated the xml file in BIP which was giving you state level tax info in hierarchial mode and not in traditional relational form. Can u give sample query/ reference link pls.
I used the rowset method to create the XML File.
Take a look at the post here for details:
peopletoolstechtips.com/create-an-xml-file-with-peopletools-using-the-rowset-method/
You can also download the tools project and see all the code including creating the XML file if you import it into a PUM or a DEV environment (HCM)
Thank you sou much!!!
Nice. How can we sort the data in excel template?
Sort the data in your rowsets before sending it to the XML file
@@PeopleToolsTechTips Thank you
Very informative. Thank you. Is there any way we can split the sheets by number of rows. Ex: the new sheet should be created once it reaches 60K row.
You could add a new field to your XML File and assign 60k rows of data to that tag value. Add a new value for each 60K. Then page break on that tag value. I would use the RowSet method to create this file