+3Hi,
Can someone guide me on how to use an image stored in the database table in an operational report?
I have stored the image as a blob in the database.
And I was trying to fetch the image using a select statement.
But, it is not showing the image even though it shows the value of the string when trying to preview the report.
Therefore, any idea on how can we call an image stored in the database in the report?
Regards,
Sachinthani.
Hi Sachinthani,
Maybe this can help you, I am not sure if you mean just one image on a specific report or a logotype...
Br
Karolina
+1Hi Sachinthani,
IFS does not use tables directly. You should use Views.
CREATE OR REPLACE VIEW WQ_COMPANY_LOGO_VW AS
SELECT COMPANY_ID,
STAMP,
IDENTITY_LABEL
FROM WQ_COMPANY_LOGO
WITH READ ONLY;
COMMENT ON TABLE WQ_COMPANY_LOGO_VW IS 'LU=SomethingUtil^PROMPT=Something All Media^MODULE=SMTHG^';
GRANT SELECT ON WQ_COMPANY_LOGO_VW TO "IFSSYS";
Sql Query Statement: SELECT STAMP FROM WQ_COMPANY_LOGO_VW WHERE COMPANY_ID=:1
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
