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

4c3880db-960a-4cd4-9bc7-412ae46c86f2
Answer

looks like this strategy might get me there ... first need to know the number of bytes per row for the inBuffImg with ...

    int bytesPerRow = inBuffImg.getWidth()/8;

    if (inBuffImg.getWidth()%8>0)

        bytesPerRow+=1;

then i get bit and byte positions with

    int bytePos = y*bytesPerRow + x/8;

    int bitPos = x%8;

then i get the bit value

    pixels = ((DataBufferByte)inBuffImg.getRaster().getDataBuffer()).getData();

    return (pixels[bytePos] >> bitPos) & 1;

Marked as Answer by 4c3880db-960a-4cd4-9bc7-412ae46c86f2 · Sep 27 2020
1 - 1

Post Details

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