Ahmed.F wrote:Didn't it occur to you that it is important to include exactly how you used the function in the report? What is the report query?
Hi, i worked with oracle apex 4.2.2 ,window 7,theme 25
i have faced the problem when i create interactive report with BLOB column ,i create sample report and i used GET_BLOB_FILE_SRC Function to show the image in report
but i face these problemsSounds like you're passing item values from the edit page to the function rather than column values from the report. See the SELECT example in the <tt>apex_file.get_blob_file_src</tt> to see how to use the function in a report. The values of <tt>p_v1</tt> (and <tt>p_v2</tt> if required) should come from report columns, not page items.
1- the images don't appear when i run the report and all images are blank
2- i must press edit on any column and go to edit page then back to report again and the image appear
3- all record have the same image ( the image with id which i pressed )
i mean when i pressed the record with ID 1 and go to edit page and then back to report the image with ID 1 appear in all record in report ,and when change the id the same issue appear . i don't know what the problem .
Why do you need to use the function at all? Using declarative BLOB formatting is recommended.
Can you explain how you got the image to show? I have a similar issue with trying to GET a blob image using RESTful web service. I am putting the BLOB field into a collection item 'BLOB001' , but I cannot figure out how to get the Image to actually render in a report with that BLOB item:
select blob001 "image_blob"
where collection_name = 'P5_DOREST_RESULTS'
The declarative Blob Column Attributes section does not accept the collection above as a table so it won't set the attributes. Is the only alternative to load the BLOB into a table and then create a report on that?
See here on working with APEX Collections from Web Services: http://www.apexninjas.com/blog/2011/05/using-rest-web-services-in-apex/
And rendering images from BLOB: http://www.apexninjas.com/blog/2011/09/uploading-and-displaying-images-in-apex/