FormatString (Measure Interface)
[!NOTA]
Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
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.
Ejemplo
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 = "#,###.##"