I am creating a report in Business Central, using Microsoft SQL Server Report Builder. The report has a tablix where it iterates lines. The lines have a field called "Line category". There is a repeater and for every line I want to control if the line gets displayed or not. I therefore select a row and select the property "Visibility". For the visibility, I select the option "Show or hide based on an expression". I want the lines to be displayed if the category is = 4, so my expression for "Hidden" is:
For some documents it works, but suddenly I have a document where the document lines are not displayed although their category is = 4.
Could there be some property I have missed which suppresses the display of the lines?
Thx for any good suggestions :-)