Solved

How do your write an IF Expression in Reporting Services 2005

Posted on 2011-09-20
2
297 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

752 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