• Article

Dataset Properties Dialog Box, Options

Select Options on the DatasetProperties dialog box to change data options, such as collation options and subtotals, for the query. For more information, see Collation and International Terminology.

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.