Creating Dynamic Image URLs in BI Publisher
In this blog post, we will explore how to create dynamic image URLs in BI Publisher to display images based on custom parameters.
Introduction
BI Publisher is a powerful reporting tool that allows you to generate customized reports with dynamic content. One common requirement is to include images in the reports, but sometimes the image URLs need to be constructed dynamically based on specific parameters.
Adding Dynamic Image URLs
To add a dynamic image URL in BI Publisher, follow these steps:
- Open your report template in BI Publisher.
- Locate the section where you want to display the image.
- Insert the following code snippet:
<fo:external-graphic src="{concat($uuu_p_urlF, 'companyRegistry=', $uuu_p_companyRegistryF, '&sessionId=', $uuu_p_sessionIdF, '&id=', K__UE_PRS_IMAGE1IP)}" content-width="100%" content-height="auto"/>
In the above code, replace the placeholders with the actual variable names and parameters specific to your setup. This code will construct the dynamic image URL using the ‘uuu_p_urlF’ variable and other parameters.
Testing and Finalizing
Once you have added the dynamic image URL, test your report in BI Publisher to verify that the image is rendered correctly. Make any necessary adjustments to the template or variables if needed.
Finally, save your report template and generate the report with the dynamic image URLs based on the provided parameters. You should now see the images rendered dynamically in your report.
Conclusion
Creating dynamic image URLs in BI Publisher allows you to display customized images based on specific parameters. By leveraging the power of XSLT and variable concatenation, you can generate dynamic image URLs that enhance the flexibility and customization of your reports.
For more information and detailed examples, refer to the official documentation of BI Publisher.
We hope this blog post has provided you with insights into creating dynamic image URLs in BI Publisher. Stay tuned for more BI Publisher tips and tricks!
Hi,
I can’t ge this to work for me. Can you explain how I can construct the code where I store the fully-formed URL of an image that is stored in the IMAGE_URL column of my query please?
Thanks in advance.
Pete
Hi Pete,
Could you please elaborate, the issues you’re facing with the solution mentioned in this blog.
Thanks,
Aruna Malla