?
Solved

How do your write an IF Expression in Reporting Services 2005

Posted on 2011-09-20
2
Medium Priority
?
305 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 2000 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

621 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