Skip to main content

Hello,

 

I was hoping to dynamically change the signature based off the user id in report studio. I was looking through the documentation and found a DB Image function. This is the syntax: DBImage(‘report_logo_’,’image_data’,’item_id=âItemID]’)

 

When I tried it with this: DBImage('report_signatures','IMAGE' ,'image_name=JONEIL.jpg'), it took the syntax but it doesn’t work. I was wondering if there was something I was missing? Could this also be utilized for customer orders? For example, let’s say I wanted to print the signature of the salesperson. Could that function be utilized? Thank you. 

Unfortunately, there is very less information on this functionality. i am trying to achieve this by using the Report rules based on the authorizer of the Purchase Order, but until now i am not successful to do so.

 I found another way to do this in Report Studio. I found I was able to concatenate who printed the report like shown below to grab the signature:

 

Signature(Concat(tCUSTOMER_ORDER_CONF_REP_REQUEST.PROCESSING_INFO.PROCESSING_ATTRIBUTES.PRINTED_BY], '.jpg')) - this syntax will print the signature based off who printed the order conf. 

 

I imagine this would work for a purchase order authorizer as well as long as the signature is loaded in the report images and the field exists on the purchase order report.

 

The authorizer is picked correctly but the report displays the ifsapp signature. 

<PURCH_AUTHORIZE>

<NAME>IFS Application Owner</NAME>

<TITLE>IFSAPP</TITLE>

<TITLE_DESCRIP xsi:nil="1"/>

<SIGN>ifsapp.png</SIGN>

<AUTH_DATE>08/11/2025</AUTH_DATE>

</PURCH_AUTHORIZE>

<PURCH_AUTHORIZE>

<NAME>MF-Person 1</NAME>

<TITLE>MFU1</TITLE>

<TITLE_DESCRIP>Project Manager</TITLE_DESCRIP>

<SIGN>mfu1.png</SIGN>

<AUTH_DATE>08/12/2025</AUTH_DATE>

</PURCH_AUTHORIZE>

Reply


Terms & ConditionsCookie settings