How to add Comment Text from transaction screen to the Crystal Report

In Sage X3, person have an possibility to add remark towards each transaction screen on proper panel after attachment image. On this remark subject person can enter an extra data as per the necessities for e.g. description, phrases & circumstances, declaration, word and so forth. This remark subject is taken into account as a header remark subject which is relevant for that individual transaction. A few of our purchasers has a requirement to print this remark subject on the customary or customized report.

Refer the under screenshot for Comment subject.

New Stuff: How to solve if added tab in window is not visible after global validation of window

Comment Option

Comment Choice

By clicking on highlighted image you’ll get a window the place person enters textual content, as proven in the under screenshot:

Comment Window

Comment Window

For instance, If person have one report identify as “Buy Order Report” and he wished to print this remark subject into this report then we now have to observe the steps talked about under:

Step 1: Refer under screenshot for SQL Question snippet:

SQL Query

SQL Question

Step 2: After including question for ‘ACLOB’ desk in the report we want to add that ‘CLOB’ subject (the CLOB subject holds the precise remark) into this report wherever we wish to add, as proven in the under screenshot.

Crystal Report

Crystal Report

Step 3: if the CLOB sort is RTF (Wealthy Text), proper click on the subject added to the report (CLOB_0), choose “Format Subject”, then choose the Paragraph tab, and choose the “Text Interpretation” as “RTF Text” and click on on “OK” button. Refer under screenshot.

Format Field

Format Subject

After following above steps, person will ready to see these feedback in the report no matter person has added into the remark part on transaction stage.

Refer under screenshot of the pattern output.



By following above steps in the crystal report, we shall be ready to print the remark subject from any screen on the specific report.

About Us

Greytrix – a globally acknowledged and one among the oldest Sage Growth Accomplice is a one-stop resolution supplier for Sage ERP and Sage CRM organizational wants. Being acknowledged and rewarded for multi-man years of expertise, we convey full end-to-end help in your technical consultations, product customizations, information migration, system integrations, third-party add-on improvement and implementation competence.

Greytrix caters to a variety of Sage X3, a Sage Enterprise Cloud Resolution, choices. Our distinctive GUMU™ integrations embody Sage X3 for Sage, Dynamics 365 CRM and Magento eCommerce together with Implementation and Technical Assist worldwide for Sage X3. At present we’re Sage X3 Implementation Accomplice in East Africa, Center East, Australia, Asia, US, UK. We additionally provide best-in-class Sage X3 customization and development services, built-in functions equivalent to POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons equivalent to Catch – Weight  and Letter of Credit and India Laws for Sage X3 to Sage enterprise companions, finish customers and Sage PSG worldwide.

Greytrix is a acknowledged Sage champion ISV Accomplice for GUMU™ Sage X3 – Sage CRM integration additionally listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For extra data on Sage X3 Integration and Companies, please contact us at, We are going to like to hear from you.

Related posts

Leave a Comment