As 2807661 mentioned use the xdofx command same like SQL .. and use can IF or CHOOSE for any conditional formatting required. As John Stegeman​ suggested please mark the threads if they are helpful and open a new one for a new question .. so going forward it would be easy for people to search ..

Hello, What is the user and what kind of roles are assigned to this user ?? Please check the bipublisher.log which may have more info.. also you statement "i have the permission to create a new datamodel and to modify an existing report .." is not clear .. can you try creating a new user and assing Administrator roles and…

Jeffy, First you need to work on how you generate the data .. as sample below G_1 DATA G_2 DATA G_3 DATA ....etc once the data is ready .. work on it piece by piece rather than trying everything in a single shot... post for any questions. --YG

Balaji, If i understand it correctly your issue is with PDF output there the data is displayed in the second page and is not starting from PAGE1 ?? please see of any blank spaces in the template which might be causing this .. also upload sample data file and your template. --YG

can you try the below .. ipp://localhost.localdomain:631/printers/epson

I did not quite understand your requirement.. but for "My problem is that BI Publisher loop operation <?for-each:name?> allows me to iterate only over a XML tags and not over a variable" --> include a null column in your query and make sure in the publisher properties it's set to create tags for null elements (" Include…

pl check if the printer is added in the server where BI is installed.

that is a very good link and should work for the requirement

@row feature can be used .. please see the following example to get an idea https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2489 https://blogs.oracle.com/xmlpublisher/entry/conditional_rows_and_columns Hope this helps .. --YG

as mentioned by other users, change your orientation and page size .. interactive reports allow upto A3 size which can hold lot of columns, if still you need more columns, trying reducing the font size to accommodate more. --YG

Please refer to the following URL and verify if BI Publisher supports your requirement. https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_lay_tmpl.htm#BIPRD2263

Can you pl be more specific .. may be a mok-up and sample data would help

can u send the data file(.xml) and any mockup of the exact output you are looking for.

I didn't quite understand ... is your requirement as below 1) when there are no records you want to display a blank page ?? 2) you want to insert a page-break for INVOICE_DIV ?? also lets forget abt #1 , did your page-break work in the past ?? upload your template and xml file. --YG

You have to move the title to the header section or alternatively you can use the start:body and end body tags as below TITLE COLUMNS (HEADER) <?start:body?> TABLE WITH COLUMNS <?end body?> FOOTER IF ANY --YG

Agree with ChrisThi10 .. adding to that comment in your data model please create the grouping per the requirement.. so it would decrease the burden on layout. --YG

Deep, Refer to 10G How To Set Up BI Publisher Responsibilities In EBS When Integrating BIP With EBS (Doc ID 1344623.1) or below Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher http://docs.oracle.com/cd/E23943_01/bi.1111/e22255.pdf Hope this Helps --YG

use a variable to count the rows .. and insert a IF statement to validate it and display blank page .. <?variable:countrow;count(G_1)?> -- this is variable deceleration and using the count of the group (G_1 in this case) <?$countrow?> -- Invoking the variable ..

Hello, Just do a simple test like below .. <?variable:countrow;count(G_1)?> <?$countrow?> <?if:$countrow>0?> HELLO<?end if?> this is working .. Pl check -- YG

Hello - The title you mentioned is this part of the page header ?? and the two columns with a table are part of the body ?? Pl upload a screenshot or your template for better understanding.