How to add checkbox in Crystal Report

By | July 31, 2020

There are many instances when client wants to give multiple copies of the invoices to their customers, where they must segregate multiple copies into original and duplicate. So we have given option on the report for those client where at the header part Original and Duplicate check boxes are given. So if the specific invoice is printing for the first time then Original checkbox should be ticked and if it is printing for more than once then the checkbox for duplicate should be ticked.

To achieve this working in Crystal report please refer the below steps:

Step 1:-
Create subreport using below SQL query and add that subreport into main report.
For example, your report code is ZSINVOICE i.e. for Sales Invoice Report. Add our subreport in this main report.

Refer below screenshot for SQL Query snippet:-

New Stuff: How to solve if new field added in inquiry screen and still not visible after global validation of window

Sample Script

Where variable “NUMDEB” holds the Invoice Number and variable “FOLDER” holds the name of the Sage X3 folder in which you are working.

Step 2:-
Insert 2 ticked and 2 unticked check box images in report headers like below screenshot:-

Sample Report header

Step 3:-
Add suppress condition for both of the header sections using Section Expert.

Report header section

Below is the Condition for ‘Report header a’ section :-
{Command.COUNT}=1

Below is the Condition for ‘Report header b’ section :-
{Command.COUNT}<>1

Whenever user tries to print the Sales Invoice report from Sage X3, it will show checkbox ticked based on the counter.

Refer below screenshot of the sample output.

Sample report output

In this way anyone can identify whether the invoice copy is original or duplicate by looking at checkbox.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence.

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also 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 more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We will like to hear from you.