Hello all,
Is it possible to print attached media files on a report designer report? Specifically in this case we are trying to print the media receipts on to the IFS report designer expense report.
Thanks,
Rich
Hello all,
Is it possible to print attached media files on a report designer report? Specifically in this case we are trying to print the media receipts on to the IFS report designer expense report.
Thanks,
Rich
Hi
It is possible to print the media files on a report designer report. You’ll have to write the code in your RDL file (PL/SQL code) to extract the blob data and make it available to the report designer. Have a look at the Media_Library_API and Media_Library_Item_API to see the functions and procedures available to you. If you have access to the built in report sources you can look at CustomerOrderConf.rdf (Customer Order Confirmation Report) you’ll see how they retrieve media images associated with the part catalog and print them on the customer order confirmation.
For example to see if any media files are available at the logical unit ExpenseHeader you’d write something like below.
library_id_ VARCHAR2(200);
library_id_ := Media_Library_Item_API.Media_Library_Item_Exist('ExpenseHeader', expense_id_);
IF (library_id_ IS NOT NULL) THEN
// Extract media file.
END IF;
Regards,
William Klotz
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.