The expression editor now includes a list of functions available to report authors, as well as Intellisense features that provide statement completion, real-time syntax checking, and context-sensitive information about inline parameters. For more information, see Edit Expression (Report Designer).

Reporting Services now supports the ability to specify data sources dynamically. This lets you to switch data sources at run time based on conditions you specify in the expression. For more information, see Connecting to a Data Source.

Report Designer includes a new query designer for creating MDX queries. You can use the integrated query designer for Analysis Services to build queries by dragging and dropping server metadata onto a report layout and then preview the results.

You can use a new data processing extension to build reports from data generated by a SQL Server Integration Services (SSIS) package. For more information, see Defining Report Datasets for Package Data from SQL Server Integration Services.

• Reports now support InteractiveHeight Element (RDL) and InteractiveWidth Element (RDL) elements so that you can specify the page size for logical page rendering extensions such as HTML. To learn more about pagination support for different rendering extensions, see Controlling Report Pagination.
  
• The ConnectString Element (RDL) element can now be an expression, enabling dynamic data source connections at run time.
  
• A FixedHeader Element (RDL) element can be specified for ColumnGrouping and RowGrouping elements in a matrix and TableColumn and TableHeader elements in a table. A fixed header remains visible on the page during scroll operations that continue off the page.
  
• Within the Chart element, a Style Element (RDL) element has been added to SeriesGrouping. The Style element defined border and background style properties for the series legend items and data points in the series.
  
• Expressions are now supported in the MajorInterval, MinorInterval, Min, and Max elements on the chart Axis element.
  
• GUID is now a supported data type for report expressions.
  

• ReportParameter now supports the Hidden Element (RDL) element so that you can define report parameters that are not displayed to users. Hidden report parameters can still be set programmatically during report processing.
  
• ReportParameter also supports the MultiValue Element (RDL) element so that you can pass multiple values to a single parameter. Multivalued parameters are accessed in expressions as zero-based arrays in the Value and Label properties. The following examples illustrate the syntax: Parameters!Cities.Value(0) and Parameters!Cities.Label(0).
  

• UserSort Element (RDL) element on a TextBox enables support for an end-user sorting of data in report. Sorting is controlled by SortExpression, SortExpressionScope, and SortTarget.
  
• SortExpression Element (RDL) specifies the expression on which to sort. It has the same restrictions as a Grouping Filter expression.
  
• SortExpressionScope Element (RDL) specifies the name of the scope (data region or grouping) in which to evaluate the SortExpression. If omitted, the expression will be evaluated and the sort will be performed independently in each detail scope within the SortTarget.
  
• SortTarget Element (RDL) specifies the Name of the data region, grouping, or dataset to which the sort is applied. If omitted, the sort applies to the instance of the current scope.
  

• CustomReportItem describes a report item that is not natively defined in RDL. In the previous version, this element supported XML data only. In this release, it provides a definition for third-party controls or any data-bound report item that is not native to a Reporting Services report.
  
• AtlReportItem specifies a report item to render instead of the CustomReportItem. This is used when the assembly specified by the custom report item is not installed on the server.
  
• CustomProperties contains the CustomProperty settings that are used when processing the custom report item control.
  
• CustomData defines the data used by the CustomReportItem. Grouping, sorting, filtering and aggregation are specified through existing DataSetName and Filters elements, and through these new elements: DataColumnGroupings, DataRowGroupings, DataRows, and DataCell.
  

When you use the Microsoft SQL Server Analysis Services as a data source type, you can set additional Field object properties. In addition to Field.Value, you can set properties like Field.Color and Field.FormattedValue using standard property syntax:

Fields!FieldName.PropertyName

The following table provides a list of the new properties that you can use. For more information about using the extended field properties, see Using Extended Field Properties for an Analysis Services Database.