Customizing Your Data after Running a Wizard (Report Builder 2.0)
In Report Builder 2.0, the most convenient way to display report data is to use a wizard to add a table, matrix, or chart. Use this topic to find more information about common tasks that you might want to use to modify the default appearance or behavior these data regions after you add them to your report.
Change the default data type for an existing parameter. For example, specify a date range.
Working with Data Types in Expressions (Report Builder 2.0)Change a parameter to accept more than one value. For example, allow the user to select more than one product.
Using Single-Value and Multivalue Parameters (Report Builder 2.0)Specify a default value for a parameter. For example, specify the last 7 days
How to: Add, Change, or Delete Default Values for a Report Parameter (Report Builder 2.0)Populate a list of available values for a parameter. For example, display a list of customer names.
How to: Add, Change, or Delete Available Values for a Report Parameter (Report Builder 2.0)Add or change the group expression for a table, matrix, or chart. For example, add row or column groups to a table or matrix or add series or category groups to a chart.
Examples of Group Expressions (Report Builder 2.0)Add or change the sort expression for a dataset, table, matrix, chart, or group. For example, in a table, sort rows or columns within a group; in a chart, change the colors for category groups.
How to: Sort Data in a Data Region (Report Builder 2.0)Add or change a filter on a dataset, table, matrix, chart, or a group. For example, remove NULL or blank values for a table or a chart.
How to: Add a Filter (Report Builder 2.0)Change the default aggregate expression for calculations for a table, matrix, chart, or group. For example, change [SUM(Sales)] to MAX(Sales)]; or calculate the percentage (%) of total for a group compared to the entire dataset.
Using Built-in Report and Aggregate Functions in Expressions (Report Builder 2.0)Add built-in fields. For example, display the report name.
Using Built-in Field References in Expressions (Report Builder 2.0)Change the format for a dataset field. For example, display a value as currency or date.
Expression Examples (Report Builder 2.0)Filtering data after it is retrieved for a report. For example, filter data that is returned from running a stored procedure, when you can not filter the data on the data source.
How to: Add a Filter (Report Builder 2.0)