Replace Values

Discussion forum about all things Report Builder (all versions).
aberndt

Replace Values

Post by aberndt » 21 Oct 2009, 06:23

I am trying to format a report in Gupta where the field returns values of B, C or P. I'd like to display these fields as Billed, Collect or Prepaid. Is there a function that will do that??? Thank you in advance for your help.

aberndt

Re: Replace Values

Post by aberndt » 21 Oct 2009, 07:14

I think I figure it out...

StrTranslate( CO_FREIGHT_TERMS, 'B,C,P', 'Billed, Collect, Prepaid') seems to work

Return to “General Discussion Report Builder”

Who is online

Users browsing this forum: [Ccbot] and 1 guest