FormatString (Measure Interface)
.gif "ms135481.note(zh-tw,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 = "#,###.##"