question

rahulmehta08 avatar image
rahulmehta08 asked

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
ssrsssrs-2008-r2
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·
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)**
0 Likes 0 ·

2 Answers

·
HaseebRiaz avatar image
HaseebRiaz answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

contact_arc avatar image
contact_arc answered
Your command should be something like below: =IIF(CountRows("DataSet1") = 0,TRUE,IIF(Globals!RenderFormat.IsInteractive= False,TRUE,FALSE)) Check this link too: http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.