how to hide a column using hide expression ssrs

Question

0.00/5 (No votes)

See more:

Hi,

I had a question, like I had a table with like 6 rows and a textbox in my report for which I am getting the values from two different DataSets one for table and other for textbox The table has columns B T M C.

What I want here is if my textbox says B my final report should hide all the columns except B automatically, is it possible to achieve? If so can some give me some idea?

Thanks

Posted 16-Mar-11 11:24am

makwith9789

Updated 16-Mar-11 12:15pm

Dalek Dave

v2

Add a Solution

2 solutions

Solution 2

1. Select the table.
2. In the grouping pane, click the triangle button and check “Advanced Mode”.
3. In the Column Groups, select the (Static) item which is corresponding to the B column in the table.
4. Specify the Hidden property to the expression like
=NOT (ReportItems!Textbox1.Value="B")
5. Repeat step 3 step 4 to change the Hidden property of the other columns.

Posted 17-Mar-11 3:14am

makwith9789

Comments

srinivaskumar.m 27-Sep-17 11:55am

Thanks makwith9789!!!

Useful in Column Group of Matrix ,to hide if that column value is something as per condition.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

luisnike19 · Accepted Answer · 2011-03-16T13:46:00

I didn't understand very well your problem, but If you want to hide a control depending an expression, follow the next steps.

Right click over your control -> Properties -> Visibility -> Expression
And then do the conditions you want to do to hide it.

Also check this link.

SQL Reporting Services with Dynamic Column Reports[^]

If you want to hide it by always, Initial visibility = Hidden