- Design the report that you wish to make a label invisible if the data associated with that label is empty
- Click on the label you wish to hide. For this example we will be using sales document number.
- Click on the little arrow in the upper right corner of the control
- Click on the gear icon
- Scroll down to the visible setting and right click and click Expression.
- Make the expression Iif(Len([SalesDocumentNumber])<1, false, true)
- If the field is something other than sales document number, find that field in the Fields list shown in the list below the expression editor and double click to add it to the expression)
- When you print this report if the Sales Document Number is empty the label will hide as well!
Using QES - Hiding a label on a report if the data is empty blank or NULL Print
Modified on: Sat, 20 Jun, 2020 at 7:08 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.