Using reporting services I am trying to set the visibility on a text box using the IIF condition.
if parameter value != -1 then show report
else if parameter value = -1 and parameter value => -1 then show report
else if parameter value = -1 then hide report and show error message
Can someone please provide me with the correct syntax ?
Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
This is the current syntax I have :
=IIF(Parameters!Users.Valu
IIF(Parameters!Users.Value
IIF(Parameters!Users.Value
FALSE)))
In my report, when I select value -1, and anything greater than -1 my report returns the error message and shows the report.
if parameter value != -1 then show report
else if parameter value = -1 and parameter value => -1 then show report
else if parameter value = -1 then hide report and show error message
If my value is -1, third condition would not reach any time. How are you handling values which are less than -1?
Can you relook into your conditions.
Hi Waylon
Are you just using one parameter? Also are you designing your report in Visual studio?
I am assuming that your answer is yes to both my questions.
Looking at your statement:
if parameter value != -1 then show report
else if parameter value = -1 and parameter value => -1 then show report
else if parameter value = -1 then hide report and show error message
Basically your statement is saying:
(1st line)if the value is not equal to -1 then show the report
(2nd line) if the value is -1 or greater than or equal to -1 then show the report
(3rd line) if the value is -1 then hide the report and show an error message.
As an example, if you selected -1, then you will never reach the 3rd line because the 2nd line will run since it checks for -1there and if true then it will show the report.
Try this version in your visibility expression of your textbox:
=IIF( Parameters!Users.Value<-1 OR Parameters!Users.Value>-1,F
Which basically says, if the value isnt -1 then show else hide the textbox. How are you showing the error message? Is this another textbox? if so then you can set the visibility to show when the value is -1 else hide it.
=IIF( Parameters!Users.Value=-1,
Hope this helps
Rob
Hi Shorak,
Yes I am using only one parameter to set the visibility and I am designing the report in Visual Studio.
I apologize to for not being clearer in explaining my situation. This is what I am facing.
They want this report to have the words "<Please Select User>" pre populated on the parameter drop down list when the report is first accessed. If the user run the report but forgets to select a user and leaves the parameter "blank" then an error message will appear(using the visibility expression option on the text box) . So what I did was created a union in my stored proc.
SELECT UserKey, UserName FROM Users
UNION
SELECT '<Select User>', '-1'
=====Results======
UserKey UserName
<Select User> -1
Bob 1
Cindy 2
etc etc
The problem is that this parameter is a multi-valued parameter so there is an option to select all. Since the the "<select user> " option is in the drop down and can not be removed I need to figure out a logic to set the visibility to where if the select all option is choosen then the report will show, but not the error message.
Please advise on how I can acheive this. Any suggestion or input is welcome!
Thank you in advance
It would of been easier for me to leave the parameter default values to null so that if they forget to select a parameter then they get a system generated message....
Have you tried:
=IIF(Parameters!User
Because its a multiselect, this makes it difficult. I was looking for an 'in List' equivalent in expressions but couldnt find one.
The above may not work as I dont know how the expressions work when using multiselect. My theory is if only one value is selected and its -1 then it will hide it and if any other value is selected (or multiple values) then it will show.
Rob
Rob,
I have tried =IIF(Parameters!Users.Valu
I may have found a solution to my issue!
=iif(Parameters!Users.Valu
So if the userkey =-1 and there is only one parameter selected then show error message, else show report.
I would like to thank you guys for your valuable input and time!
Business Accounts
Answer for Membership
by: isaackhaziPosted on 2009-01-22 at 23:36:35ID: 23447079
if paramvalue <>1
show report
elseif paramvalue = -1 AND paranvalue => -1
show
elseif paramvalue = -1
hide report