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 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

more ▼

asked Jul 27, 2016 at 10:13 AM in Default

avatar image

1 3

If you are manipulating the Hidden property of the textbox then the hidden property has to be true when CountRows("dataset") = 0, not when CountRows("dataset") > 0. That is the inner IIF should read IIf(CountRows("dataset") = 0 , True, False)

Jul 28, 2016 at 02:50 PM Oleg
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hi, I am applying condition on textbox, the field data type is enum becuse it is checkbox field. Senerio: If field is Checked or True display YES, other wise No. Thanks

more ▼

answered Jun 20 at 07:58 AM

avatar image


(comments are locked)
10|1200 characters needed characters left

Your command should be something like below: =IIF(CountRows("DataSet1") = 0,TRUE,IIF(Globals!RenderFormat.IsInteractive= False,TRUE,FALSE))

Check this link too:


more ▼

answered Jul 19 at 07:16 AM

avatar image

1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 27, 2016 at 10:13 AM

Seen: 119 times

Last Updated: Jul 19 at 07:16 AM

Copyright 2017 Redgate Software. Privacy Policy