Skip to main content

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

 

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

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.

 

 

Reply


Terms & ConditionsCookie settings