Skip to main content
Solved

Report Studio Signatures

  • July 15, 2025
  • 3 replies
  • 112 views
J
Hero (Customer)
Forum|alt.badge.img+7

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. 

Best answer by jayoneil98

 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([CUSTOMER_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.

RanukaSerasinghe
F
Grzegorz Byrski

3 replies

F
Sidekick (Partner)
Forum|alt.badge.img+9
  • FPayab
  • Sidekick (Partner)
  • August 4, 2025

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.

J
Hero (Customer)
Forum|alt.badge.img+7
  • jayoneil98
  • Author
  • Hero (Customer)
  • Answer
  • August 6, 2025

 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([CUSTOMER_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.

F
T
F
Sidekick (Partner)
Forum|alt.badge.img+9
  • FPayab
  • Sidekick (Partner)
  • August 12, 2025

 

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>

Terms & ConditionsCookie settingsAccessibility statement