Search code examples
reporting-servicesssrs-2008-r2ssrs-tablix

SSRS multiple condition on textbox

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 in count("dataset") = 0

Below is the expression I am using in hidden property of textbox

=IIF( (Globals!RenderFormat.IsInteractive) , IIf(CountRows("dataset") > 0 , True, False), False)
Solution

  • Try this chages

    =IIF(Globals!RenderFormat.IsInteractive,True,IIf(CountRows("dataset") > 0 , False, True))