Report Design: How to show Boolean UDF in checkbox format on Invoice: Difference between revisions
(Created page with "'''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 check...") |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 28: | Line 28: | ||
3) In the Expression Editor, use the function <span style='color:red'> |
3) In the Expression Editor, use the function <span style='color:red'>iif</span>.<br/><br/> |
||
Go to <span style='color:red'>Functions > |
Go to <span style='color:red'>Functions > iif(, , )</span>, or <span style='color:red'>Functions > Logical > iif(, , )</span> for Version 2.0.<br/><br/> |
||
iif(Expression, TruePart, FalsePart)<br/><br/> |
|||
Apply your UDF into the Expression.<br/><br/> |
Apply your UDF into the Expression.<br/><br/> |
||
''' |
'''iif([_UDF: CUSTOMERID (IV)] == 'T',True,False)''' |
||
| Line 59: | Line 59: | ||
[[File:Checkbox10.png]] |
[[File:Checkbox10.png]] |
||
<br/><br/> |
|||
5) Preview the report and now it’s shown in checkbox format instead of T or F. |
5) Preview the report and now it’s shown in checkbox format instead of T or F. |
||
[[File:Checkbox11.png]] |
[[File:Checkbox11.png]] |
||
| Line 69: | Line 71: | ||
[[File:Checkbox12.png]] |
[[File:Checkbox12.png]] |
||
By : Jia Zheng 200226, Lay Swan 200303, P200304 |
By : Jia Zheng 200226, Lay Swan 200303, P200304 |
||
{{NavigateForUser}} |
{{NavigateForUser}} |
||
Latest revision as of 03:30, 10 March 2020
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
Answer :
This can be done by using Calculated Field in report design.
1) Right click on Invoice Master and select for Add Calculated Field.
2) Click on the calculatedField1, edit the Display Name from Property Grid, change the Field Type to Boolean, and click on the Expression.
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.
4) Drag out the calculatedField (CustomerID), and click on the small arrow to remove the Text and Save the report.
5) Preview the report and now it’s shown in checkbox format instead of T or F.
You may also key in the Text as Customer ID and remove the existing added text label for Customer ID.
By : Jia Zheng 200226, Lay Swan 200303, P200304
|
AutoCount Accounting 2.0 & 2.1
|
|
AutoCount Accounting 1.8 / 1.9
|
|
AutoCount Payroll
|
|
AutoCount POS
|
|
AutoCount On The Go
|
|
AutoCount Accounting Plug-In Documentations
|