If you are using group left, make it group right while using the BI Publisher Desktop tool from the RTF template. Then, the merging will not happen. check blogs from Tim Dexter and with Oracle Support also these solutions are mentioned

I declared a variable outside the pivot table and initialized it to 0. The, in the pivot section defined the below if condition before the for-each clause. Then, it restricts the columns to only 4. So far so good. bit for the grid where data is published am unable to pass this condition to display the data for the above…

As per Oracle documentation, you cannot use variables/form fields in header and footer section. so, you want to use them in the body and intend to repeat it. Use the below and place the section that you want to repeat above. Sub templates will also help as suggested <?start:body?> <?end body?> I had a similar requirement…

Hi, though I have not used it myself. I was in a project where a JAVA developer called these using Bi Publisher Wsdls from JAVA. Since, they had to be called via Control M for scheduling and Oracle Support said it couldn't from URL method and this was on the only options. The Bi Publisher wsdls could be called from…

Hi, As I mentioned, I didn't develop the JAVA code to do it. but, when we raised Oracle SR, they shared the documentation and methodology for all the JAVA APIs handbook that could be call BI Publisher reports, define the layouts and email/schedule them to the recipients. Also, caching of the data, caching of the report…

Hi, I needed the report output in PDF format. So, though the pivot table rendered 13 columns, I achieved 4 columns per page just by a adjusting the column width in the RTF template. So, am good with that. The actual requirement here is it should publish the data for the first 4 columns from the beginning row till the last…

Is there some kind of logic for the columns like given below in XSL/XML coding? Step1: I can declare a variable. Step2: The value will increment by 1. Step 3: Use mod function divide by 4 for fetching 4 columns at a time. Step 4: In this step it should loop through the data for the first 4 columns till end of data Step 5:…

Except for 4 am able to achieve all the rest by myself, Thanks

I mean, except for issue 4, rest am able to achieve with workarounds . I have used RTF templates to achieve the same.