Using If...............End IF in SSRS

Question

0.00/5 (No votes)

See more:

, +

Hi,
I have a filed displayed on my report. But I want to make it visible or invisible, depending on user's choice. My form, that initiates the report, contains a check box, the value of the check box is stored in variable, say vrIfChecked.
I want to make the field hidden if the value in the variable is false
can I use something like

VB

if vrIfChecked="Checked" then
txtHeader.visible=true
else
txtHeader.visible=false
endif

If yes, where to write code and how to call it. Please give me complete steps for this.

Thanks a lot.
With best regards,
Furqan

Posted 7-Feb-11 23:37pm

Furqan Sehgal

Updated 7-Feb-11 23:41pm

Prerak Patel

v4

Add a Solution

1 solution

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)

Umair Feroze · Answer 1 · 2011-02-08T00:10:00

This can be done in the following order:
1. Create a boolean report parameter in your SSRS Report.
2. On the textbox which is to be hiden, right click on it and click on propreties.
3. From there click on Visibility tab.
4. In it select expression and put the following expression:

=Iif(Parameters!Report_Parameter_0.Value = true, True, False)

Replace Report_Parameter_0 with the name of the parameter you declared in the report.
5. Now from the web page, set this variable and it will work for you.

Hope this answer your question.