Start a conversation

Using QES - Hiding a label on a report if the data is empty blank or NULL

  1. Design the report that you wish to make a label invisible if the data associated with that label is empty
  2. Click on the label you wish to hide
  3. Click on the blue arrow in the upper right corner of the control which causes a menu to appear
  4. Click the ... on formatting rules
  5. Click Edit Rules sheet button at the bottom of the Formatting Rules Editor window that appears
  6. Click the Green + sign to add a new rule
  7. Under the Design Group give the rule a name
    1. We suggest formattingRule_Labelnametohide
    2. For example formattingRule_ExternalItemNumberLabel
  8. Under the Behavior Group set the Visible to "No"
  9. Under the Behavior Group click on the ... in the condition field
  10. Click on fields in the Condition Editor window that opens
  11. We now want to build the formula that tells the system to hide the label.
  12. Double Click the database field that is related to the label you are hiding.  This will add it to the white area above.
    1. Please note that there are a lot of extra items that are XYZcolumn,  ignore those and don't use them.
    2. Usually you have to scroll down until the + signs stop appearing to find the database field you need to add
  13. Then type ==?
  14. So the final text in the white box above is [SalesDocumentNumber] == ? because we are hiding the sales document label in our example.
  15. Click OK
  16. Click Close
  17. You should now be at the formatting rules editor.
  18. Click on the formatting rule you just created
  19. Click on the >> button to move it from the left to the right side.
  20. Click OK
  21. You have now added your formatting rule to the label on the report.
  22. When you print this report if the Sales Document Number is empty the label will hide as well!
Choose files or drag and drop files
Was this article helpful?
  1. Jaydel Gluckie

  2. Posted
  3. Updated