Share via

Dataset Properties Dialog Box, Options (Report Builder)

  • Article

Select Options on the Dataset Properties dialog box to change data options, such as collation options and treating subtotals as detail data, for the query. For more information about collations, see Collation and Unicode Support in SQL Server Books Online.

Data options that are part of a shared dataset definition on the report server affect all reports that use the shared dataset. You can override options for the shared dataset after it is added to a report. These changes affect only the report in which they are defined.

Data options for an embedded dataset affect only the report in which they are defined.

For more information, see Report Embedded Datasets and Shared Datasets (Report Builder and SSRS).

Options

  • 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 computer.

  • 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 data provider does not support the case-sensitivity type, the report runs as though the value were False. If you know the value and you know it is supported, choose True.

  • 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 data provider does not support the accent sensitivity type, the report runs as though the value were False. If you know the value and you know it is supported, choose True.

  • 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 data provider does not support the kanatype sensitivity type, the report runs as though the value were False. If you know the value and you know it is supported, choose True.

  • 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 data provider does not support the width sensitivity type, the report runs as though the value were False. If you know the value and you know it is supported, choose True.

  • Interpret subtotals as detail rows
    Select a value that indicates whether you want subtotal rows to be interpreted as detail rows instead of aggregate rows. The default value, Auto, indicates that the subtotal rows should be treated as detail rows if the report does not use the Aggregate() function to access any fields in the data set. If you want subtotal rows to be interpreted as aggregate rows, choose False. If you want the subtotal rows to be interpreted as detail rows and you know that they do not use the Aggregate() function, choose True.

See Also

Reference

Aggregate Function (Report Builder and SSRS)

Dataset Properties Dialog Box, Query (Report Builder)

Concepts

Report Builder Help for Dialog Boxes, Panes, and Wizards

Filter, Group, and Sort Data (Report Builder and SSRS)

Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)