Solved

How do your write an IF Expression in Reporting Services 2005

Posted on 2011-09-20
2
294 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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