SSRS hide textbox based on tablix

(0) Share

Report

Posted on by Community Member

Hi all

I thought this would be easy but i can't seem to get it to work. I'm trying to hide a text box based if a table has a 0 count. This is what i thought would work but it doesn't

= Iif (CountRows("Tablix20") > 0, false, true)

Regards

Dan

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Thomas David Dayman 11,323 on at

Like (0)

Report
Have you put the expression into:

Properties of TextBox>Visibility>Hidden

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

Hi,

I'm not sure, but you may have to pass a dataset there.. not a tablix.. tablix may have some rows either way (headers etc)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

Thank you for your replies. I thought that might be the case. But I've had a think the tablix has a filter to get data based on if the dataset has a certain value in a field so I will just use similar logic to hide the textbox

Regards

Dan

Was this reply helpful? Yes No
Thomas David Dayman 11,323 on at

Like (0)

Report

This thread could help: [View:http://stackoverflow.com/questions/6279704/how-do-i-set-the-visibility-of-a-text-box-in-ssrs-using-an-expression:750:50]

Have your tried formatting your expression like this: =Iif ((CountRows("Tablix20") > 0), false, true)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Based on Dataset might be a better approach.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Use the CountRows function. For example

=IIf((CountRows("MyDataset") > 0),False,True)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi all

Thank you for your replies. I have been looking at this and can't seem to get it to work at all. in the tablix with the rowcount and even creating a new dataset that returns nothing it will not hide the text box below is what i'm using for the text box and will use the same on the tablix once working

=iif((countrows("EPHide")>1),false,true)

Any ideas why this won't work i'm using VS2012 for the reports

Regards

Dan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I guess we need to see your design, wonder if you putting the expression to the correct box...

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi.

On the textbox properties I click on visibility and then expression. I think this is the correct place

Regards

Dan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you try put TRUE and see what happens?

Was this reply helpful? Yes No