MEASURE PROPERTIES

I have a report that has multiple measures coming from an OLAP data source.
Some of these measures are counts, some are % and some are $. How can I set
the format property for each. Thanks.
--
Michael Hardy
ETL Developer
Visit our web pages:
www.atlantis.com
www.oceanclub.com
www.oneandonlyresorts.com
www.kerzner.comIn RS 2000, you have to set format codes on the textboxes where you show the
field values.
E.g. P0 for percentages without decimals, P2 for percentages with two
decimals, C for currency values, etc. More information on format codes is
available on MSDN:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
NOTE: format codes only have an effect if the contents of the textbox is not
a string, but a numeric data type. You might need to use conversion
functions to make sure the value is a numeric value. Common conversion
functions are listed here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vagrptypeconversion.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Opuspocus" <Michael.Hardy@.Kerzner.Com> wrote in message
news:427B1A97-96CB-48F7-B7F0-3A88F79B50E5@.microsoft.com...
> I have a report that has multiple measures coming from an OLAP data
source.
> Some of these measures are counts, some are % and some are $. How can I
set
> the format property for each. Thanks.
> --
> Michael Hardy
> ETL Developer
> Visit our web pages:
> www.atlantis.com
> www.oceanclub.com
> www.oneandonlyresorts.com
> www.kerzner.com
>