Hello,
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:
=iif(Fields!LineCategory.Value=4,false,true)
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 :-)
0
Answers
Below the main group there is another group, "Details". There was a visibility formula in this group which suppressed lines if a certain column was blank. And that just happened to be the case in the document which gave the strange results.