Formatting Currency Numbers from Analaysis Services

Hi,

I'm using Reporting Services in conjunction with Analysis Services.

The problem I'm having is formatting numbers to be dollar amounts. I know how to set this in Reporting Services and when a data source was regular SQL, then everything was just fine. However, when I switch to Analysis Services the number would just stay the same.
i.e. "60.2" instead of "$60.20". The only thing I can think of is if Analysis Services is returning the number as a string for some reason, and RS won't format strings for currency.

Any thoughts? Thanks!You should be able to format measures from SSAS the same way you do this with a relational database. Can you repro your issue with the Adventure Works cube?|||I think this is the problem: the numbers that being returned are attributes not measures... which is right b/c I'm using the numbers as parameters for drill-down reports.

So the question is how do you format a number returned by AS20005 as an attribute to be a U.S. dollar amount? Thanks!|||Okay, looks like the attribute number was getting returned as a string. I used CDbl() to convert into a double and it works fine now.

Format parameter date string

I have a Analysis services dimension which is returning a date in the format
yyyy/mm/dd, I have added reporting filters (Parameters from-Date and to-Date
with datatype date to show calendar) for this date which is showing the
selected date in the format mm/dd/yyyy. How can I "format the parameter
values" or "write the expression" or "update MDX" so that the report shows
data within the filter dates?
Thanks and Regards
SridharFYI: I am using SQL Server 2005 and web-based reports using reporting
services.
--
Sridhar
>I have a Analysis services dimension which is returning a date in the
>format yyyy/mm/dd, I have added reporting filters (Parameters from-Date and
>to-Date with datatype date to show calendar) for this date which is showing
>the selected date in the format mm/dd/yyyy. How can I "format the parameter
>values" or "write the expression" or "update MDX" so that the report shows
>data within the filter dates?
>
> Thanks and Regards
> Sridhar
>