FormatString (Measure Interface)

ms135481.note(zh-cn,SQL.90).gif注意:
  下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能,并尽快修改当前还在使用该功能的应用程序。

The FormatString property of the Measure interface contains the format used to display the measure values. Any format string valid for use with Microsoft® Visual Basic® is acceptable.

Applies To:clsAggregationMeasure, clsCubeMeasure, clsPartitionMeasure

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

Class type Access

clsAggregationMeasure

R

clsCubeMeasure

R/W*

clsPartitionMeasure

R

* Read-only for virtual cube measures.

示例

Use the following code to set the format string for the measure object [Sales_Facts].[Price]:

'Assume an object (dsoCubeMea) of ClassType clsCubeMeasure exists
dsoCubeMea.FormatString = "#,###.##"

请参阅

参考

Measure Interface

帮助和信息

获取 SQL Server 2005 帮助