Solved

How do your write an IF Expression in Reporting Services 2005

Posted on 2011-09-20
2
295 Views
Last Modified: 2012-06-22
Expert:
I am clicking  fx expression... to bring on the popup to write expressions. I have an expression that includes and reads  & " My Test Number:"  & Parameters ! number_c.Value

When Parameters ! number_c.Value  is greater then the number 20  
I want "Parameters ! number_c.Value" to read "Max Number" in my report.
Could some show me the correct expression to do this?
thanks

How do you do this
0
Comment
Question by:tcmmaxt
  • 2
2 Comments
 
LVL 11

Expert Comment

by:rajvja
ID: 36567926
=IIF(MAX(Parameters ! number_c.Value, "Datasetname"))>20,true value, falsevalue)
0
 
LVL 11

Accepted Solution

by:
rajvja earned 500 total points
ID: 36567939
Hi,

    MAX can be used only on dataset not on parameters. Paramers collection will have only value that is passed to it.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question