Thursday, August 9, 2007

Expression Samples in SSRS

Today I come across these sites in the MSDN, which explains about the various functions and their uses in the SSRS Report expressions.

One of the important functions which we use extensively in our reports is:

=IIF (Condition1, Expr1 (Returned when Condition1 is true), Expr2 (Returned if the condition fails)

One another expression I don’t come across. I don’t know that we can use this function in the reporting services.

=Switch (
Condition1, Val1,
Condition2, Val2,
Condition3, Val3
)

1) Functions Reference in the SSRS or Expressions Examples
http://msdn2.microsoft.com/en-us/library/ms157328.aspx
2) Using Report functions in expressions – SSRS
http://msdn2.microsoft.com/en-us/library/ms159673.aspx

No comments: