Skip to main content
Solved

How to add Report Images on Reports in Report Designer in IFS Cloud


Forum|alt.badge.img+1

We are currently trying to add additional images (additional to the normal logo) to multiple reports. 
Are there any documentations on how to use the IFS Cloud report images in the report designer? 

Best answer by NecMayuIk

Hi @flemichak 

After importing the image into the image, make the following settings for the image in the report designer
(This is the procedure I was provided by RnD.)


Please follow the below steps provided.
1. Add all images into the Graphics section in the upper left panel in the report designer tool.
2. Drag the image into the required position in the layout.
3. Select the Properties window and select the Dynamic Image stored on Database section.
4. Feed the SQL query statement according to the image type using the following syntax:

For Report Images: SELECT IMAGE FROM REPORT_IMAGES WHERE IMAGE_NAME=:1
For Logo Images: SELECT IMAGE FROM REPORT_LOGOS WHERE IMAGE_NAME=:1
For Signature Images: SELECT IMAGE FROM REPORT_SIGNATURES WHERE IMAGE_NAME=:1

Note that the image name can be fed into the Bind Variable property section, and the file name should be within single quotes. Please refer to the attached screenshot.

5. Once the layout is completed, upload the layout files into the relevant report definition.

It is important to note that the same images must be uploaded using the same name into the Report Images page relevant tab pages.


I have registered with idea in hopes of having this procedure included in the technical documentation.

https://community.ifs.com/ideas/the-procedure-for-adding-images-imported-into-ifscloud-to-the-report-designer-40288

 

View original
Did this topic help you find an answer to your question?

4 replies

hamalk
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • 222 replies
  • August 31, 2023

Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • August 31, 2023

Hi @hamalk 
thanks a lot for the link to the documentations. 
Do you know how to use the Report Images from the second link in the Report Designer? 
Best regards,
Michael 


hamalk
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • 222 replies
  • September 1, 2023

Report Images page is available in solution manager under following path. This is the page you can use to import/export images into DB in order to use in report designer operational reports. 

 


Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 18 replies
  • Answer
  • October 24, 2023

Hi @flemichak 

After importing the image into the image, make the following settings for the image in the report designer
(This is the procedure I was provided by RnD.)


Please follow the below steps provided.
1. Add all images into the Graphics section in the upper left panel in the report designer tool.
2. Drag the image into the required position in the layout.
3. Select the Properties window and select the Dynamic Image stored on Database section.
4. Feed the SQL query statement according to the image type using the following syntax:

For Report Images: SELECT IMAGE FROM REPORT_IMAGES WHERE IMAGE_NAME=:1
For Logo Images: SELECT IMAGE FROM REPORT_LOGOS WHERE IMAGE_NAME=:1
For Signature Images: SELECT IMAGE FROM REPORT_SIGNATURES WHERE IMAGE_NAME=:1

Note that the image name can be fed into the Bind Variable property section, and the file name should be within single quotes. Please refer to the attached screenshot.

5. Once the layout is completed, upload the layout files into the relevant report definition.

It is important to note that the same images must be uploaded using the same name into the Report Images page relevant tab pages.


I have registered with idea in hopes of having this procedure included in the technical documentation.

https://community.ifs.com/ideas/the-procedure-for-adding-images-imported-into-ifscloud-to-the-report-designer-40288

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings