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