I am stuck in ssrs scenario where i have to show the textbox when it is exported to excel or pdf also I have to hide that if count of a particular dataset is 0.
Below is the expression I am using in hidden property of textbox
=IIF( (Globals!RenderFormat.IsInteractive) , IIf(CountRows("dataset") > 0 , True, False), False)
Please let me know where I am wrong in the above expression. Thanks in advance
asked Jul 27, 2016 at 10:13 AM in Default
Your command should be something like below: =IIF(CountRows("DataSet1") = 0,TRUE,IIF(Globals!RenderFormat.IsInteractive= False,TRUE,FALSE))
Check this link too:
answered Jul 19, 2017 at 07:16 AM