Categories
Dynamic Images in BIP report
Hello,
our goal is to create a BIP report publisher with different logos for our customers. We tried to include in our data model (created using logical queries) a BLOB variable that contains our images. In the data section we can see the BLOB variable, but when we try to open the BIP report we see an error, even if we didn't use the variable in the report. On the web, we found different videos that explain how to include dynamic images, but all of them use the rtf model, something we would like to avoid given the complexity of the model in its entirety.
As integration here one of the links that we followed:
We tried also to include dynamic images using url, stored as a column in the database, but this is the error we find:
Is there a way to include dynamic images without the rtf model, only using the BIP template?
Thanks
Best Answer
-
Hi @August 7,
"Add BLOB Image"
You can add a Binary Large Object (BLOB) image in an RTF or XPT template. Usage of an RTF template is recommended for BLOB images.
To add a BLOB image in XPT layout:
- Specify the data column type as Binary Large Object (BLOB).
- Insert the image in the BLOB column, and then select the BLOB column data element to display as image.
To add multiple BLOB data rows in tabular format, use Repeating Group. Include a Layout Grid to create a tabular format, and add the BLOB column in the Layout grid. - In the column preceding the BLOB image, type "data:image/jpeg;base64," along with the quotes.
For your reference, please review:
Thank you,
Simona
2
Answers
-
Very helpful information.
Thank you very much @Simonab-Oracle!
1 -
Hi @Simonab-Oracle , is this also possible using a image in base64 format in a CLOB field?
0 -
No the image has to be in a BLOB column, not CLOB.
Rgds,
Kevin
0
