Monday, February 23, 2009

Expressions & Functions


Displaying Data on a Report



  • When you drag a field onto a section of a report, SSRS places it within a TextBox

  • TextBoxes can be bound to a field or to a member of a global collection



Expressions



  • Reporting Services uses VB-like expressions

  • You can use standard +. -, *, /, mod operators

  • String concatenation with & (don’t use +)

    • =Fields!City.Value & ", " & Fields!Country.Value





  • Aggregate functions:

    • Sum, Count, Avg, Min, Max, First, Last, etc.




  • Also supported:

    • IIf(), Len(), Switch() New for





No comments: