In the Sage X3, we have numerous basic reports for nearly every screen which are established in Crystal Report. Likewise we can establish brand-new personalized crystal report according to the customer’s requirement.
For among our customer we have actually established a report which contains all the details associated to Work Orders (report is printing in stand out format) and there was a requirement from the customer that if the Operation Status is closed for the previous line then the Planned Qty of the previous line need to be printed in a “ Previous Operation Qty” field of present line.
For this requirement, we have actually utilized the Previous() function in Crystal Report formula.
To attain the above requirement follow the listed below actions:
Action 1: Produce a formula ‘ fm_close‘ for previous line’s status (whether it is close or not)
New Things: How to conditionally format fields utilizing the Highlighting Professional in Crystal Report
Action 2: Produce another formula ‘ Pre_Op_Qty‘ to obtain the last line’s prepared qty (if the status is closed for last line else print 0)
Action 3: Drag and drop this formula ‘Pre_Op_Qty’ anywhere you wish to include report.
Refer the above screenshot in which you can examine, by utilizing previous function, we have actually printed organized amount of previous line in the next line just if the operation status of previous line is “Closed”.