Share via


Dataset (Data Options Tab, Report Designer)

Use the Data Options tab of the Dataset dialog box to define data options for the query.

Options

  • Case sensitivity
    Select a value that determines case sensitivity. This option indicates whether the data is case-sensitive. You can set Case Sensitivity to True, False, or Auto. The default value, Auto, indicates that the report server should attempt to derive the value from the data provider when the report runs. If the value cannot be derived, the report runs as though the value were False.
  • Collation
    Select a locale that determines the collation sequence to be used for sorting data. Default indicates that the report server should attempt to derive the value from the data provider when the report runs. If the value cannot be derived, the default value is derived from the locale setting of the server.
  • Kanatype sensitivity
    Select a value that determines kanatype sensitivity. This option indicates whether the data is kanatype sensitive; it can be set to True, False, or Auto. The default value, Auto, indicates that the report server should attempt to derive the value from the data provider when the report runs. If the value cannot be derived, the report runs as though the value were False.
  • Width sensitivity
    Select a value that determines width sensitivity. This option indicates whether the data is width-sensitive and can be set to True, False, or Auto. The default value, Auto, indicates that the report server should attempt to derive the value from the data provider when the report runs. If the value cannot be derived, the report runs as though the value were False.
  • Accent sensitivity
    Select a value that determines accent sensitivity. Accent Sensitivity indicates whether the data is accent sensitive and can be set to True, False, or Auto. The default value, Auto, indicates that the report server should attempt to derive the value from the data provider when the report is run. If the value cannot be derived, the report runs as though the value were False.

See Also

Reference

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

Other Resources

Working with Data in Reporting Services
Defining Report Datasets

Help and Information

Getting SQL Server 2005 Assistance