Currency Formatting

Is there a way to format currency for check print using the reporting
services software? For example, instead of displaying $32,469.68, I could
display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
--
K. ThomasI would use a UDF on the SQL side to return this as a string
"K. Thomas" wrote:
> Is there a way to format currency for check print using the reporting
> services software? For example, instead of displaying $32,469.68, I could
> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
> --
> K. Thomas|||Or you could write code and put in a custom assembly. In RS Books Online
look for "assembly references" in the index.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
>I would use a UDF on the SQL side to return this as a string
> "K. Thomas" wrote:
>> Is there a way to format currency for check print using the reporting
>> services software? For example, instead of displaying $32,469.68, I
>> could
>> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
>> --
>> K. Thomas|||Jeff,
In terms of efficiency, I stand well corrected,
Thanks,
Tony
"Jeff A. Stucker" wrote:
> Or you could write code and put in a custom assembly. In RS Books Online
> look for "assembly references" in the index.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
> news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
> >I would use a UDF on the SQL side to return this as a string
> >
> > "K. Thomas" wrote:
> >
> >> Is there a way to format currency for check print using the reporting
> >> services software? For example, instead of displaying $32,469.68, I
> >> could
> >> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
> >> --
> >> K. Thomas
>
>|||I have no idea which would be more efficient, I just like knowing there are
multiple options... ;-)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
news:2C1B882D-A985-4CD0-B791-46A4BF12F8B3@.microsoft.com...
> Jeff,
> In terms of efficiency, I stand well corrected,
> Thanks,
> Tony
> "Jeff A. Stucker" wrote:
>> Or you could write code and put in a custom assembly. In RS Books Online
>> look for "assembly references" in the index.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
>> news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
>> >I would use a UDF on the SQL side to return this as a string
>> >
>> > "K. Thomas" wrote:
>> >
>> >> Is there a way to format currency for check print using the reporting
>> >> services software? For example, instead of displaying $32,469.68, I
>> >> could
>> >> display "thirty-two thousand four hundred sixty-nine and 68/100
>> >> dollars".
>> >> --
>> >> K. Thomas
>>

Currency being rounded up in Report

I am displaying an amount of money to two decimal places in a field in a report.

If I run the stored procedure in sql server the amounts are displayed to two decimal places like so €31.75.

But when I run the report the amount is returned as so €32.00, it is being rounded up to the nearest euro.

Anyone any ideas how to solve this?

macca

Figured this out myself.

cube measure only displays one total

I did something to my cube where it is only displaying a much smaller value for

the sales amount measure than it should.

I have a project with two dimensions and one measure.

After deploying the cube i browsed it and pulled the sales amount into the

details field area. normally i should end up with some 400 + million in dollars instead i get 90+ thousand. It seems as if the cube is not processing fully or the browser tab is somehow being filtered. I checked and there is nothing in the subcube or any other field.

Can someone direct me on how best to debug this?

thanks

I found the problem and thought I would share what I did.

I'm surprised it works this way maybe it is a bug. Perhaps the pros here could add some info to this.

here is what I did.

I have a field called "Rate" which is multiplied by the "Qty" to come up the "Sales Amount" measure. This is done in the DSV as a "Named Calculation" in the measures table.

This same table is also used as a dimension table. In here i considered the "Rate" field to be non-Aggregatable or (IsAggregatable = false). Since i would never add up the rates for a total.

Apparently SSAS does not like this and hence things got really messed up. Switching it back to (IsAggregatable = true) fixed everything.

Hopefully my hair will grow back soon.