Skip to main content
Solved

Dynamic Logo not working in Report Designer Layout

  • March 9, 2023
  • 2 replies
  • 468 views
B
Do Gooder (Customer)
Forum|alt.badge.img+4

Hello,

I created a report designer layout with some data and logo in header. My requirement to display image from a database table. So I wrote the query in SQL Query Statement field as shown in Picture below and passing tns:IMAGE_NO bind variable. When I previewed the report in designer tool or in IFS Application, Logo is not printing in the report. But when I pass hard code value in bind variable instead of tns:IMAGE_NO, the report is printing the logo properly. 

I checked that tns:IMAGE_NO element is printing the value in report. But when I pass it as bind variable to display the logo, it is not working.

IFS Application Version: IFS 10 UPD13

Report Designer Tool Version : 200.2.0000

 

Best answer by EDOMMISSE

We stored the logo's in the media items and retrieved it from there

sql:

select media_object from media_item where description =upper(:1) and name =upper(:2)

 

Bind variables 

tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:PO_HEADER/tns:CF_COMPANY;'COMPANY_LOGO'

 

Where the first variable represents the company number and the second variable represents the image type:  'COMPANY_LOGO'

 

Upload the image into the media item page by using the browse functionality.

 

 

2 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

Have you tried fully qualifying the path of the IMAGE_NO attribute?

 

For example:

tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:PO_HEADER/tns:ORDER_NO

E
Do Gooder (Customer)
Forum|alt.badge.img+2
  • EDOMMISSE
  • Do Gooder (Customer)
  • Answer
  • March 13, 2023

We stored the logo's in the media items and retrieved it from there

sql:

select media_object from media_item where description =upper(:1) and name =upper(:2)

 

Bind variables 

tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:PO_HEADER/tns:CF_COMPANY;'COMPANY_LOGO'

 

Where the first variable represents the company number and the second variable represents the image type:  'COMPANY_LOGO'

 

Upload the image into the media item page by using the browse functionality.

 

 

C
Terms & ConditionsCookie settingsAccessibility statement