November 15, 2016 at 3:37 pm
In an ssrs 2008 report, there is the following IIF expression on the visibility property of a tablix:
=iif((CountRows("SrvyRespondents") < 1 ), True, False).
The "SrvyRespondents" is the name of the dataset that is accessed by the tablix.
Somehow the true and false portions determine if the tablix will display or not.
Thus would you tell me what the iif statement means? Would you tell me what each part means so that I know what the expression means in the future?
November 15, 2016 at 5:43 pm
It basically says if there are no rows, hide the tablix. In general, visibility expressions are formatted "IF X, Do this, Otherwise do that." True means hide, False means don't hide. The format "=IFF X, True, False" means the default is to display the tablix, but only hide it if X. The format "=IFF X, False, True" means the default is to hide the tablix, and only show it if X.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply