I have an issue with the download/printing of images (pdf, xls, html) where i use a join(left) on a master-child. The child records have blobs (images). Not all master records have a child record (ref. attachments). The report displays fine (including the images), however when I download (pdf), the blob/image gets “repeated” on the master records that have no childs.
I have setup a reproduceable case:
https://apex.oracle.com/pls/apex/r/lowcode_cert/reporting-download/home
account : demo
password: lowcode_cert_#45@576
I created the IR (Interactive Report) with the following query (a simplified version - just for the reproduceable case):
select
l.id,
h.id as header_id,
h.description,
l.filename,
dbms_lob.getlength(l.file_content) as image
from demo_header h
left join demo_lines l
ON l.header_id = h.id
order by h.description
You will see that the IR report is fine (> not showing the image on the 03-Header, which has no child), however when download (pdf, xls, html) you will see an image on the 03-Header row.
Please advise.