Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No data in XLS or PDF format of Report generated in BIP. There is data only in CSV format.

User_TYVZTMar 1 2022

Hi,
For one of my queries, I have 1 row data satisfying the condition. While generating report in BIP, that data is saved as sample data. While viewing the report in various formats(PDF, XLS, CSV), only CSV shows that data. PDF and XLS only has the empty table.
This issue is faced in another similar report too. Is it because of any settings chosen or is it because of any reason like the report has too many columns?
Any feedback will be appreciable.

Comments

Christian Pitet

What means BIP ?

User_TYVZT

Hi Christian Pitet

Oracle Business Intelligence Publisher (BI Publisher) (BIP)

Christian Pitet

I guess you are using an Interactive report. Do you have a Submit page process on that page ?

InoL

While generating report in BIP, that data is saved as sample data.
What do you mean by that? Generating a report via BI Publisher and saving sample data? I don't see the connection.
How are you using BIP? As the print server for Intercative Reports? Or a custom report template?

User_TYVZT

Hi InoL
So for creating report, I have xdm(data model) and xdo. In xdm, after providing the sql query, I can see the data when I click view data. There I can do "save as sample data". Then after link my data model with xdo which has template in it, I can view my report in various formats. There even though there is data I'm not able to see the data in xls and pdf format. Only CSV format report shows data.

InoL

I have xdm(data model) and xdo
I have no idea what that is, not APEX anyway. Is this something from BI Publisher? Maybe you can ask this in that forum then.

User_TYVZT

Hi InoL
Yes it is from BI Publisher(BIP). Could you share forum link?

Christian Pitet

Here is a forum link :
bi publisher (0 Bytes)Regards.

1 - 8

Post Details

Added on Mar 1 2022
#apex-discussions, #bip, #report, #sql
8 comments
227 views