Report Writer syntax

(0) Share

Report

Posted on by Kumar_Sat

1,146

How should I create a calculated field for Vendor (VendorID):?

Here Vendor is the text (string) and VendorID is the GP field. Final result should be something like "ABC Company (123):". I am trying with string vendor ID and strip Vendor ID but it is not working. Any idea?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

David Musgrave MVP ... 13,913 Most Valuable Professional on at

Like (1)

Report

RE: Report Writer syntax

Create a string calculated field of STRIP(Vendor Name) # ( # STRIP(Vendor ID) # )

Where # is the CAT (concatenate) button.

and the ( and ) are string constants

Regards

David