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