sql server reporting services: How to Write Expression -- sql server reporting services

RE: How to Write Expression

Nick P.
12/1/2005 11:32:03 AM

You can use the "IIF" function as the expression for the text box. In your
case the =iif(Fields!Correct.Value < 11, "Failed", "Passed") should do the
trick. You can look up information for the "IIF" function in help for Visual
Basic.

[quoted text, click to view]

Re: How to Write Expression

Dom
12/1/2005 12:31:56 PM

For the bonus, I believe the list of operators and functions you are
looking for is.....

"Using Expressions in Reporting Services"
-http://msdn2.microsoft.com/en-us/library/ms159238.aspx should also be
handy

"Expressions Commonly Used in Reporting Services"
(http://msdn2.microsoft.com/en-us/library/ms157328.aspx) says "Many
expressions within a report contain functions. You can write
expressions that use functions from the Microsoft.VisualBasic,
System.Convert, and System.Math namespaces, or you can add references
to other assemblies or custom code. You can also use classes from the
Microsoft .NET Framework. For more information, see the .NET Framework
Class Library documentation."

for the list of functions in Microsoft.VisualBasic, see "Visual Basic
Run-Time Library Members"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp

HTH!
Dominique

Re: How to Write Expression

Wayne Wengert
12/1/2005 2:47:42 PM

Thanks guys - exactly what I needed

Wayne

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.