Question :
How to hide 0.00 when the value is 0? I don’t want to show it if it is 0.
Solution :
We can use Formatting Rule Function to control it in report design. To do so,
1a.(POS 5.0)Go to Front End > More Function > Configuration Setting > Receipt > Design Receipt > Select your report > Design
1b.(POS 3.1) Go to Front End > More Function > Configuration Setting > Receipt > Design Receipt under Xtra Report > Select your report > Design
1c.(F&B) Go to Front End > More Function > Setting > Configuration Settingv > Receipt > Design Receipt > Select your report > Design
2.At Designer tab > highlight all field you want to hide > Behavior (Gear icon) under Properties > untick Visible
3. Click the field > top right small arrow > click ‘…’ at Formatting Rules > Edit Rule Sheet…
4. Go to click ‘+’ > make sure Data Member is correct > click ‘…’ under Condition > Fields > find & double click your correct field (Rounding Adjustment) > at Condition Editor add a command ( != ‘0.00’) > OK
5. Visible set to Yes > Close
6. Select your formatting rule > click right arrow (>) > OK
7.Click 2nd field > top right small arrow > click ‘…’ at Formatting Rules > select your formatting rule > click right arrow (>) > OK
8.Click Preview tab (check result) > File > Save As… > set new name > Save
9. You should be able to hide it.