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)

Don't you have to turn it around? Right now you are saying to show the textbox when using an interactive renderer. Excel or pdf, is not an interactive renderer — DenStudent, Jul 27 '16 at 10:22

score 0 · Accepted Answer · answered Jul 27 '16 at 10:26

0

Try this chages

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

answered Jul 27 '16 at 10:26

Sanjay Radadiya

1 Answers1