There are quite a few circumstances when shopper wants to supply quite a few copies of the invoices to their prospects, the place they should segregate quite a few copies into distinctive and duplicate. So we have given risk on the report for these shopper the place on the header half Distinctive and Duplicate confirm bins are given. So if the actual invoice is printing for the first time then Distinctive checkbox should be ticked and whether or not it’s printing for higher than as quickly as then the checkbox for duplicate should be ticked.
To achieve this working in Crystal report please refer the underneath steps:
Create subreport using underneath SQL query and add that subreport into important report.
As an illustration, your report code is ZSINVOICE i.e. for Product sales Invoice Report. Add our subreport on this important report.
Refer underneath screenshot for SQL Query snippet:-
The place variable “NUMDEB” holds the Invoice Amount and variable “FOLDER” holds the determine of the Sage X3 folder whereby you could be working.
Insert 2 ticked and a few unticked confirm subject photographs in report headers like underneath screenshot:-
Add suppress scenario for every of the header sections using Half Educated.
Below is the State of affairs for ‘Report header a’ half :-
Below is the State of affairs for ‘Report header b’ half :-
At any time when particular person tries to print the Product sales Invoice report from Sage X3, it is going to current checkbox ticked based on the counter.
Refer underneath screenshot of the sample output.
On this fashion anyone can decide whether or not or not the invoice copy is exclusive or duplicate by checkbox.