SSRS multiple condition on textbox

Question

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)

Answer 1

Try this chages

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