Report Designer F1 Help


SQL Server 2008 Books Online (October 2009)
Dataset Properties Dialog Box, Fields

Select Fields on the Dataset Properties dialog box to change the field collection for the report dataset. The fields list is automatically populated, but you can use Fields to add, edit, and delete query and calculated fields.

Options

Add

Add a new query field or calculated field to the dataset.

Delete

Delete the selected field from the dataset.

Field Name

Type a name for the field. The field must be unique within the dataset. For each existing field in the dataset query, the name is pre-populated.

Field Source

Enter a value for the field.

For a calculated field, the field source must be the name of an existing field retrieved by the dataset query, or an expression that you create. For example, to create a field that represents 10 times the value in the query field Sales, use the expression =10 * Fields!Sales.Value.

For a query field, the field source must be the name of an existing field retrieved by the dataset query.

Expression (fx)

Add or change an expression for the calculated field. This button only appears when you click Add and select Calculated Field.

See Also

Reference

Dataset Properties Dialog Box, Options
Dataset Properties Dialog Box, Filters
Dataset Properties Dialog Box, Parameters
Dataset Properties Dialog Box, Query

Other Resources

How to: Add, Edit, or Delete a Field in the Report Data Pane
Working with Fields in a Report Dataset
Creating a Report Dataset
Connecting To Report Data How-to Topics
Creating Report Datasets from a SQL Server Relational Database
How to: Create a Dataset (Reporting Services)
Report Designer F1 Help
Working with Report Expressions
Connecting to a Data Source (Reporting Services)

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker