Report Design: How to show Boolean UDF in checkbox format on Invoice

From AutoCount Resource Center
Jump to navigation Jump to search

Question : I have an UDF in Boolean type and I have dragged out the UDF in report design. But when preview the report it shows in T or F. How can I show the UDF in checkbox format?


Version : 1.8 / 1.9 / 2.0


Checkbox1.png


Answer :

This can be done by using Calculated Field in report design.


1) Right click on Invoice Master and select for Add Calculated Field.


Checkbox2a.png


Checkbox3a.png


2) Click on the calculatedField1, edit the Display Name from Property Grid, change the Field Type to Boolean, and click on the Expression.

Checkbox4a.png


3) In the Expression Editor, use the function iif.

Go to Functions > iif(, , ), or Functions > Logical > iif(, , ) for Version 2.0.

iif(Expression, TruePart, FalsePart)

Apply your UDF into the Expression.

iif([_UDF: CUSTOMERID (IV)] == 'T',True,False)


Then, click on OK.


Checkbox5.png


Checkbox6.png


Checkbox7.png


Checkbox8.png


4) Drag out the calculatedField (CustomerID), and click on the small arrow to remove the Text and Save the report.

Checkbox9.png

Checkbox10.png



5) Preview the report and now it’s shown in checkbox format instead of T or F.

Checkbox11.png


You may also key in the Text as Customer ID and remove the existing added text label for Customer ID.


Checkbox12.png



By : Jia Zheng 200226, Lay Swan 200303, P200304



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations