Dataset (Fields Tab, Report Designer)

Use the Fields tab of the Dataset dialog box to display and modify the fields for the dataset. The fields list is automatically populated, but you use this tab to add, edit, and delete fields.

Options

  • Field Name
    Type a name for the field. The field must be unique within the dataset.
  • Type
    Select the field type: Database Field or Calculated Field.
  • Value
    Type a value for the field. If Type is Database Field, Value must be the name of a field that is returned by the query. If Type is Calculated Field, Value can be an expression to return calculated data.

See Also

Reference

Report Designer F1 Help
Dataset (Data Options Tab, Report Designer)
Dataset (Filters Tab, Report Designer)
Dataset (Parameters Tab, Report Designer)
Dataset (Query Tab, Report Designer)

Other Resources

Defining Report Datasets
Using Expressions in Reporting Services
Connecting to a Data Source

Help and Information

Getting SQL Server 2005 Assistance