Report Designer

Report designer_Optimum

How to create Calculated field to SUM in Report Designer?
I have created additional column in transactions details, I sum all columns at bottom  In report format, I sum for total Labour Cost, Total Material Cost...
Tue, 20 Oct, 2020 at 4:46 PM
Insert digital signature into invoice format
1. Go to Maintenance > User  2. Double click on the Signature box and select your Digital Signature image file 3. Click Save and Close  4. Go to Sales...
Thu, 15 Oct, 2020 at 3:27 PM
How to Grouping in Report Designer?
In Sales Invoice user update same stock code few times    When preview report, user wants to display the total QTY for same item Solution :  Step ...
Sat, 24 Oct, 2020 at 7:39 AM
How to use IsNullOrEmpty ?
Scenario: User has created additional fields in Purchase order. review PO, user wants to display result as below since Allocation 4 is updated     ...
Fri, 18 Sep, 2020 at 5:21 PM
How to customize Sales invoice format empty unit price to ‘wording’ [Free of charge]
Scenario  Example: In Standard format unit price will display blank, If user did not insert any of unit price. Maybe this 2 item are free of charge. ...
Fri, 23 Oct, 2020 at 9:02 AM
How to customize report format payment detail with row numbering.
    Solution Step 1 - Go to Report Designer Step 2 - Select Table Cell Tasks > Summary  Step 3 - Select option as below: ...
Mon, 7 Sep, 2020 at 11:58 AM
How to mask credit card number show last 4 digits only in report?
Issue a Point Of Sales transaction and payment is made via a credit card. The credit card number is entered into the transaction, user request to mask and d...
Mon, 7 Sep, 2020 at 3:08 PM
How to set Print Count/ Page Break Item in Optimum
Note : For this tutorial, I’m using Sales -> Batch Reports -> Sales Invoice.   Step 1 - Go to design and amend <SR>01 report format. Step 2 -...
Mon, 28 Mar, 2022 at 9:32 AM
How to Displaying Row Number / Numbering in a Report ?
How to customize report format payment detail with row numbering.   Step 1:  Go To Report Designer Step 2:  Select Table Cell Tasks > Summa...
Mon, 7 Sep, 2020 at 3:27 PM
How to merge 2 fields into 1 field in Report designer?
How to merge two field into one (Report customization) eg. company name & GST Reg No.   Step 1: Go to Report Designer > right click to ‘Add C...
Mon, 7 Sep, 2020 at 3:37 PM