Formatting numbers question

I have a datagrid with currency amounts, the default currency format "C" shows only two decimal places, I would like to show up to 4 decimal places. Useing the formula/expression editor, how would this be done?Have you tried C4? Currency with 4 numbers of precision. Just an thought, I do not know if it will work or not.|||

I do this in the expression.

=Format(Fields!ThisValue.Value, "$#.####)

Hope this helps.

|||

Both of the above are possible options.

rs12345 - put "c4" into the Format property of the textbox

guyinkalamazoo2 - apply the formatting directly tot he value in the expression of the textbox

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.

Formatting Currency (rounding)

I'm trying to show currency values rounded to the nearest thousand (i.e
$797,100.12 would display as $798. I can't seem to figure out the custom
format string. Can someone help me out?Karl wrote:
> I'm trying to show currency values rounded to the nearest thousand (i.e
> $797,100.12 would display as $798. I can't seem to figure out the custom
> format string. Can someone help me out?
Try using "Format" = "P0" for the field.
P as for Percent
0 as for 0 decimals
// Jonas Montonen|||"Jonas Montonen" wrote:
> Karl wrote:
> > I'm trying to show currency values rounded to the nearest thousand (i.e
> > $797,100.12 would display as $798. I can't seem to figure out the custom
> > format string. Can someone help me out?
> Try using "Format" = "P0" for the field.
> P as for Percent
> 0 as for 0 decimals
> // Jonas Montonen
>
That didn't really do the trick. I'm not trying to show the value as a
percentage, I'm trying to show it as currency but rounded to the nearest
thousand dollars.|||I have done this for norwegan format i used # ##0,.# to show 986000 as 986
hope this helps
"Karl" wrote:
>
> "Jonas Montonen" wrote:
> > Karl wrote:
> > > I'm trying to show currency values rounded to the nearest thousand (i.e
> > > $797,100.12 would display as $798. I can't seem to figure out the custom
> > > format string. Can someone help me out?
> >
> > Try using "Format" = "P0" for the field.
> > P as for Percent
> > 0 as for 0 decimals
> >
> > // Jonas Montonen
> >
> That didn't really do the trick. I'm not trying to show the value as a
> percentage, I'm trying to show it as currency but rounded to the nearest
> thousand dollars.|||I have done this for norwegan format, I used # ##0,.# to show 986000 as 986
or 986100 as 986,1 Hope this helps
"Karl" wrote:
>
> "Jonas Montonen" wrote:
> > Karl wrote:
> > > I'm trying to show currency values rounded to the nearest thousand (i.e
> > > $797,100.12 would display as $798. I can't seem to figure out the custom
> > > format string. Can someone help me out?
> >
> > Try using "Format" = "P0" for the field.
> > P as for Percent
> > 0 as for 0 decimals
> >
> > // Jonas Montonen
> >
> That didn't really do the trick. I'm not trying to show the value as a
> percentage, I'm trying to show it as currency but rounded to the nearest
> thousand dollars.

Formatting Currency

I'm trying to display currency with ZERO decimal places... the book that I
bought says to use "C" for currency, with formats it traditionally (with 2
decimal places)
the other option was to use D0 (D-zero), which works as far as the decimal
is concerned, but doesn't add the $
should I concatenate a "$" to a amount in DO format? gotta be a better wayuse C0 ... which is the same as D0 with the "$"
"Derek in Richmond" <DerekinRichmond@.discussions.microsoft.com> wrote in
message news:01169023-D1A9-4DF9-A628-EA21A7696539@.microsoft.com...
> I'm trying to display currency with ZERO decimal places... the book that
I
> bought says to use "C" for currency, with formats it traditionally (with 2
> decimal places)
> the other option was to use D0 (D-zero), which works as far as the decimal
> is concerned, but doesn't add the $
> should I concatenate a "$" to a amount in DO format? gotta be a better
way|||Use the format pattern "C0" instead of "C". Note: any digits to the right of
the decimal place will be rounded.
"Derek in Richmond" wrote:
> I'm trying to display currency with ZERO decimal places... the book that I
> bought says to use "C" for currency, with formats it traditionally (with 2
> decimal places)
> the other option was to use D0 (D-zero), which works as far as the decimal
> is concerned, but doesn't add the $
> should I concatenate a "$" to a amount in DO format? gotta be a better way

Formatting Currency

Hi all,
I have a currency field in my database, when I select data from that
column, I want it to right align.
Any help?This is performed in the client application. SQL Server sends back data
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<riversmithco@.hotmail.com> wrote in message
news:1110819266.183608.268260@.z14g2000cwz.googlegroups.com...
> Hi all,
> I have a currency field in my database, when I select data from that
> column, I want it to right align.
> Any help?
>|||Which software do you use to display these values to the end users? Have you
considered researching the options on the client programming language or
report writer to see if they have provisions to support such alignment &
formatting functionality?
In SQL Server, such formatting requires you to do explicit type conversions
and padding up with spaces. For instance with a value like 123.45 you would
display it right aligned using a 10 character string value as:
DECLARE @.c MONEY
SET @.c = 123.45
SELECT RIGHT( SPACE(10) + CAST( @.c AS VARCHAR ), 10 )
Anith|||Tibor Karaszi wrote:
> This is performed in the client application. SQL Server sends back
data
But what if I am not using a client app, perhaps I am just running a
report from a sql query?|||Then use Anith's suggestion. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<riversmithco@.hotmail.com> wrote in message
news:1110820375.127912.77870@.g14g2000cwa.googlegroups.com...
> Tibor Karaszi wrote:
> data
>
> But what if I am not using a client app, perhaps I am just running a
> report from a sql query?
>

Format_String Currency lost by division

Hello!

I use AS 2005 SP1.

If I create a calculated measure "C" with a currency measure ("A") and a non-currency measeasure ("B") like
C=A/B
and define the format_string for the calculated measure as currency. The result is still a non-currency value. Why?

Thanks in advance!
Ole JepsenIf you explicitly specified FORMAT_STRING='Currency' for the calculated measure C, then it will be formatted as currency.

Format Question (Currency)

I know that you can set a textbox to be of format Currency, but how
can I set the text of a textbox equal to a string that has formatted
strings within it?
What I mean is, lets say that I am getting back 2 values: MyFieldA and
MyFieldB, which are both floats (say 12.3123 and 43.2234). I want to
make the text "MyFieldA - MyFieldB", where both are formatted as
currency, so it would look like "$12.31 - $43.22".
Is there a way, with in the section where I specify
Fields!MyFieldA.Value to do something like
Fields!MyFieldA.Value.Format("C") or something like that? anyone
know?Chris,
Maybe something like this:
=(String.Format("{$###,##0.00}"),Fields!MyFieldA.Value) & " - " &
(String.Format("{$###,##0.00}"),Fields!MyFieldB.Value)
I had thought about using cdec, but I don't think that works in RS.
I'm pretty new to the RS world, so I don't know it this will help but
it doesn't hurt to try. Good Luck.
Jonathan
cmay@.walshgroup.com (Chris) wrote in message news:<44f6e099.0410261338.3f991c5@.posting.google.com>...
> I know that you can set a textbox to be of format Currency, but how
> can I set the text of a textbox equal to a string that has formatted
> strings within it?
> What I mean is, lets say that I am getting back 2 values: MyFieldA and
> MyFieldB, which are both floats (say 12.3123 and 43.2234). I want to
> make the text "MyFieldA - MyFieldB", where both are formatted as
> currency, so it would look like "$12.31 - $43.22".
> Is there a way, with in the section where I specify
> Fields!MyFieldA.Value to do something like
> Fields!MyFieldA.Value.Format("C") or something like that? anyone
> know?

Format Currency Problem - HELP! ANYBODY

I need to display a number field with commas, $, and no decimals.
I tried FormatCurrency(fieldname,0,-1,-1 but the commas don't appear.
How can I accomplish what I need?
Thanks,
Gail BeedieIf your Regional Settings in Control Panel is US, then go to the Format
property of the field in the Properties sheet and type in C0. (letter "C"
followed by a zero).
If your Regional Settings is not US, then go to the Language property of the
textbox, select English (United States) from the listbox, then in the Format
property type in C0.
Alternatively, you can just use an expression: =Format(FieldName, "$#,###").
HTH
Charles Kangai, MCT, MCDBA
"Gail Beedie" wrote:
> I need to display a number field with commas, $, and no decimals.
> I tried FormatCurrency(fieldname,0,-1,-1 but the commas don't appear.
> How can I accomplish what I need?
> Thanks,
> Gail Beedie
>

Format Currency Problem - HELP!

I need to display currency fields with a dollar sign, commas and no
decimal places. I entered
=FormatCurreny(fields!nameoffield.value,0,-1,-1)in the textbox
property's custom edit expressions box.
It drops the decimal places and adds the dollar sign just fine but,
I need the commas as well. What do I do?
I would apprectiate help here.
Thanks,
GailIf your Regional Settings in Control Panel is US, then go to the Format
property of the field in the Properties sheet and type in C0. (letter "C"
followed by a zero).
If your Regional Settings is not US, then go to the Language property of the
textbox, select English (United States) from the listbox, then in the Format
property type in C0.
Alternatively, you can just use an expression: =Format(FieldName, "$#,###").
HTH
Charles Kangai, MCT, MCDBA
"Gail Beedie" wrote:
> I need to display currency fields with a dollar sign, commas and no
> decimal places. I entered
> =FormatCurreny(fields!nameoffield.value,0,-1,-1)in the textbox
> property's custom edit expressions box.
> It drops the decimal places and adds the dollar sign just fine but,
> I need the commas as well. What do I do?
>
> I would apprectiate help here.
> Thanks,
> Gail
>|||YOU ARE MY HERO!!!!
GAIL
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message news:<B6BAD0E4-6010-4560-A59D-788C94A5640E@.microsoft.com>...
> If your Regional Settings in Control Panel is US, then go to the Format
> property of the field in the Properties sheet and type in C0. (letter "C"
> followed by a zero).
> If your Regional Settings is not US, then go to the Language property of the
> textbox, select English (United States) from the listbox, then in the Format
> property type in C0.
> Alternatively, you can just use an expression: =Format(FieldName, "$#,###").
> HTH
> Charles Kangai, MCT, MCDBA
>
> "Gail Beedie" wrote:
> > I need to display currency fields with a dollar sign, commas and no
> > decimal places. I entered
> > =FormatCurreny(fields!nameoffield.value,0,-1,-1)in the textbox
> > property's custom edit expressions box.
> >
> > It drops the decimal places and adds the dollar sign just fine but,
> > I need the commas as well. What do I do?
> >
> >
> > I would apprectiate help here.
> >
> > Thanks,
> > Gail
> >|||And mine as well. I had a different issue, but this clued me into what my
problem was. Thanks
"Gail Beedie" wrote:
> YOU ARE MY HERO!!!!
> GAIL
>
> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message news:<B6BAD0E4-6010-4560-A59D-788C94A5640E@.microsoft.com>...
> > If your Regional Settings in Control Panel is US, then go to the Format
> > property of the field in the Properties sheet and type in C0. (letter "C"
> > followed by a zero).
> >
> > If your Regional Settings is not US, then go to the Language property of the
> > textbox, select English (United States) from the listbox, then in the Format
> > property type in C0.
> >
> > Alternatively, you can just use an expression: =Format(FieldName, "$#,###").
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> >
> > "Gail Beedie" wrote:
> >
> > > I need to display currency fields with a dollar sign, commas and no
> > > decimal places. I entered
> > > =FormatCurreny(fields!nameoffield.value,0,-1,-1)in the textbox
> > > property's custom edit expressions box.
> > >
> > > It drops the decimal places and adds the dollar sign just fine but,
> > > I need the commas as well. What do I do?
> > >
> > >
> > > I would apprectiate help here.
> > >
> > > Thanks,
> > > Gail
> > >
>

Format Currency Problem

Hello,
I'm running SQL Server & Reporting Services locally on my development PC.
My regional settings are UK English (ie. currency format uses "£").
I create a new report containing a MONEY field and set the Format property
to "C". This does not work - the values are formatted with "$" not "£" as
expected.
Any ideas?
Thanks, JoeFurther information:
I forgot to say that I'm writing the report using Visual Studio .NET 2003.
Also if I specify "£#,###.00" as the value of the Format property, then it
works. However surely "C" should work.
"Joe" wrote:
> Hello,
> I'm running SQL Server & Reporting Services locally on my development PC.
> My regional settings are UK English (ie. currency format uses "£").
> I create a new report containing a MONEY field and set the Format property
> to "C". This does not work - the values are formatted with "$" not "£" as
> expected.
> Any ideas?
> Thanks, Joe|||Check that the Reports Language is set to English (United Kingdom) by
selecting the BODY of the report and looking at the properties.
It looks like all new reports default to US, ignoring the PC's regional
settings.
Dave Hughes
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> Further information:
> I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> Also if I specify "£#,###.00" as the value of the Format property, then it
> works. However surely "C" should work.
>
> "Joe" wrote:
> > Hello,
> >
> > I'm running SQL Server & Reporting Services locally on my development
PC.
> > My regional settings are UK English (ie. currency format uses "£").
> >
> > I create a new report containing a MONEY field and set the Format
property
> > to "C". This does not work - the values are formatted with "$" not "£"
as
> > expected.
> >
> > Any ideas?
> > Thanks, Joe|||David - thanks very much for your reply.
I develop my reports in Visual Studio 2003 - the report body did not have a
Language property - BUT each individual control (eg Chart or Table) did have
the Language property set to "Default". I changed this to "English (United
Kingdom)" and it works.
Thanks for your help!
"David Hughes" wrote:
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe
>
>|||Thanks David.
In VS2003 the report body did not have a Language property. But each
individual control (eg. chart, table etc) did have the Language property. I
set this as suggested & it works!
Cheers,
Joe
"David Hughes" wrote:
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe
>
>|||Actually just realised the Language property is part of the REPORT object,
not the BODY.
You should be able to simply change that one property and everything should
work
Dave
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:D929F73B-C0AE-410B-8B51-E71C21507EA3@.microsoft.com...
> David - thanks very much for your reply.
> I develop my reports in Visual Studio 2003 - the report body did not have
a
> Language property - BUT each individual control (eg Chart or Table) did
have
> the Language property set to "Default". I changed this to "English
(United
> Kingdom)" and it works.
> Thanks for your help!
>
> "David Hughes" wrote:
> > Check that the Reports Language is set to English (United Kingdom) by
> > selecting the BODY of the report and looking at the properties.
> >
> > It looks like all new reports default to US, ignoring the PC's regional
> > settings.
> >
> > Dave Hughes
> >
> > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > > Further information:
> > >
> > > I forgot to say that I'm writing the report using Visual Studio .NET
2003.
> > >
> > > Also if I specify "£#,###.00" as the value of the Format property,
then it
> > > works. However surely "C" should work.
> > >
> > >
> > >
> > > "Joe" wrote:
> > >
> > > > Hello,
> > > >
> > > > I'm running SQL Server & Reporting Services locally on my
development
> > PC.
> > > > My regional settings are UK English (ie. currency format uses "£").
> > > >
> > > > I create a new report containing a MONEY field and set the Format
> > property
> > > > to "C". This does not work - the values are formatted with "$" not
"£"
> > as
> > > > expected.
> > > >
> > > > Any ideas?
> > > > Thanks, Joe
> >
> >
> >|||Even better!
Cheers again
"David Hughes" wrote:
> Actually just realised the Language property is part of the REPORT object,
> not the BODY.
> You should be able to simply change that one property and everything should
> work
> Dave
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:D929F73B-C0AE-410B-8B51-E71C21507EA3@.microsoft.com...
> > David - thanks very much for your reply.
> >
> > I develop my reports in Visual Studio 2003 - the report body did not have
> a
> > Language property - BUT each individual control (eg Chart or Table) did
> have
> > the Language property set to "Default". I changed this to "English
> (United
> > Kingdom)" and it works.
> >
> > Thanks for your help!
> >
> >
> > "David Hughes" wrote:
> >
> > > Check that the Reports Language is set to English (United Kingdom) by
> > > selecting the BODY of the report and looking at the properties.
> > >
> > > It looks like all new reports default to US, ignoring the PC's regional
> > > settings.
> > >
> > > Dave Hughes
> > >
> > > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > > news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > > > Further information:
> > > >
> > > > I forgot to say that I'm writing the report using Visual Studio .NET
> 2003.
> > > >
> > > > Also if I specify "£#,###.00" as the value of the Format property,
> then it
> > > > works. However surely "C" should work.
> > > >
> > > >
> > > >
> > > > "Joe" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > I'm running SQL Server & Reporting Services locally on my
> development
> > > PC.
> > > > > My regional settings are UK English (ie. currency format uses "£").
> > > > >
> > > > > I create a new report containing a MONEY field and set the Format
> > > property
> > > > > to "C". This does not work - the values are formatted with "$" not
> "£"
> > > as
> > > > > expected.
> > > > >
> > > > > Any ideas?
> > > > > Thanks, Joe
> > >
> > >
> > >
>
>|||You do not seem to get the Language property when you just select the
BODY of the report. However, if you select the "View Code" icon to
view the xml of the report and scroll right to the bottom, you will
find the <Language>en-US</Language> tag as the second last line.
Change this to <Language>en-GB</Language. and it will change the
currency to £.
Regards
Wee-Lin
"David Hughes" <spamfree@.freespam.com> wrote in message news:<eaqBXOlxEHA.1296@.TK2MSFTNGP10.phx.gbl>...
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe

Format Currency - values include NaN

Hi, my report includes a calculated column which I wish to display as
currency.
Unfortunately, some of the calculated values are non-numeric. My report
shows these values as 'NaN'. I would like to display something a bit more
meaningful to the user such as '-'. Is there a way of doing this?Nic wrote:
> I would like to display
> something a bit more meaningful to the user such as '-'. Is there a
> way of doing this?
Write a piece of custom-code like this:
Function CheckValue(value as object) as object
If isnumeric(value) Then
Return FormatCurreny(value)
Else
Return "This is no numeric value"
End If
End Function
and put an expression in the field like:
=code.CheckValue(Fields!MyField.Value)
Maybe you have to play with field-property..i assumed "Standard"
regards
Frank
www.xax.de|||Frank,
Thanks for the information. However, I tried the function you suggested and
the isnumeric function appears to return true for those values which are NaN.
In any case, my report still contains NaN values, which have not been
replaced by the 'This is no numeric value' message. I know that the function
is being used, and I can change what is displayed by changing what is
returned when the isnumeric function is evaluated as true.
Any suggestions?
"Frank Matthiesen" wrote:
> Nic wrote:
> > I would like to display
> > something a bit more meaningful to the user such as '-'. Is there a
> > way of doing this?
> Write a piece of custom-code like this:
> Function CheckValue(value as object) as object
> If isnumeric(value) Then
> Return FormatCurreny(value)
> Else
> Return "This is no numeric value"
> End If
> End Function
> and put an expression in the field like:
> =code.CheckValue(Fields!MyField.Value)
> Maybe you have to play with field-property..i assumed "Standard"
> regards
> Frank
> www.xax.de
>
>
>|||Hi,
I have done a bit more investigation, and have come up with the following,
which seems to work. I would dearly like to know whether this can be
simplified, Franks suggestion seems neater, but I cannot get it to work - any
ideas why?
Function CheckValue(value as object) as object
If IsNum(value) Then
Return FormatCurrency(value)
Else
Return "-"
End If
End Function
Function IsNum(value as object) as boolean
Try
Decimal.Parse(value)
Return True
Catch
Return False
End Try
End Function
"Nic" wrote:
> Frank,
> Thanks for the information. However, I tried the function you suggested and
> the isnumeric function appears to return true for those values which are NaN.
> In any case, my report still contains NaN values, which have not been
> replaced by the 'This is no numeric value' message. I know that the function
> is being used, and I can change what is displayed by changing what is
> returned when the isnumeric function is evaluated as true.
> Any suggestions?
> "Frank Matthiesen" wrote:
> > Nic wrote:
> >
> > > I would like to display
> > > something a bit more meaningful to the user such as '-'. Is there a
> > > way of doing this?
> >
> > Write a piece of custom-code like this:
> >
> > Function CheckValue(value as object) as object
> > If isnumeric(value) Then
> > Return FormatCurreny(value)
> > Else
> > Return "This is no numeric value"
> > End If
> > End Function
> >
> > and put an expression in the field like:
> > =code.CheckValue(Fields!MyField.Value)
> >
> > Maybe you have to play with field-property..i assumed "Standard"
> >
> > regards
> >
> > Frank
> > www.xax.de
> >
> >
> >
> >
> >

Format currency - include commas to separate per 1000 multiples?

I'm using F to format currency (UK sterling) to 2 decimal places. Is it
possible to include commas to separate 1000 multiples - e.g. 5,000,000
--
FionaDMThis article should help http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx
Put something like this in the Layout / Properties / Format box (I'm
using the US Dollar sign - you would put the UK pound sign in the
appropriate place instead):
$#,##0.00;($#,##0.00);Zero
If the value were 10000 you would see: $10,000.00
If the value were .5 you would see: $0.50
If the value were -500.05 you would see: ($500.05)
If the value were 0 you would see: Zero
- C
On Oct 3, 8:07 am, FionaDM <Fion...@.discussions.microsoft.com> wrote:
> I'm using F to format currency (UK sterling) to 2 decimal places. Is it
> possible to include commas to separate 1000 multiples - e.g. 5,000,000
> --
> FionaDM|||Perfect!
--
FionaDM
"Cindy Parker" wrote:
> This article should help http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx
> Put something like this in the Layout / Properties / Format box (I'm
> using the US Dollar sign - you would put the UK pound sign in the
> appropriate place instead):
> $#,##0.00;($#,##0.00);Zero
> If the value were 10000 you would see: $10,000.00
> If the value were .5 you would see: $0.50
> If the value were -500.05 you would see: ($500.05)
> If the value were 0 you would see: Zero
> - C
> On Oct 3, 8:07 am, FionaDM <Fion...@.discussions.microsoft.com> wrote:
> > I'm using F to format currency (UK sterling) to 2 decimal places. Is it
> > possible to include commas to separate 1000 multiples - e.g. 5,000,000
> > --
> > FionaDM
>
>

Format Currency

Does anyone know how to change the currency as follows:
from: $2,332,765 to: $2.3
I've tried several combinations of ($#.#;$#.#;$0.0) and nothing seems
to work
Thanks in advance
LisaOn Jun 13, 12:19 pm, peashoe <peas...@.yahoo.com> wrote:
> Does anyone know how to change the currency as follows:
> from: $2,332,765 to: $2.3
> I've tried several combinations of ($#.#;$#.#;$0.0) and nothing seems
> to work
> Thanks in advance
> Lisa
You could try: $#.0 however, you might need to use an expression/etc
to divide the values by 1 million. (ie., =Fields!Currency.Value/
1000000) assuming that some values will not evaluate to zero. Also,
you might need to accommodate different currency ranges (ie.,
=iif(Fields!Currency.Value >= 100000, Fields!Currency.Value/1000000,
Fields!Currency.Value/100000). In this example case, if values will
fall below 0.0, then divide by a smaller value/denomination. Of
course, it would need to be based on your particular needs. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
This was EXACTLY what I needed!
Thanks,
Lisa|||On Jun 13, 1:36 pm, peashoe <peas...@.yahoo.com> wrote:
> Enrique,
> This was EXACTLY what I needed!
> Thanks,
> Lisa
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Format - currency not working

Hi,
I am using reporting services 2000. Setting the format to currency (C) is
not showing the formatted price.
Is this a known problem?What is your value expression for the textbox?
Make sure that the datatype expected for the field is a numeric value.
If the format property doesn't work, set the value of your textbox to
the following expression:
=Format(Fields!MyField.Value, "C")
or
=FormatCurrency(Fields!MyField.Value)
Regards,
Thiago Silva
Gaurav wrote:
> Hi,
> I am using reporting services 2000. Setting the format to currency (C) is
> not showing the formatted price.
> Is this a known problem?|||Thanks Thiago... I was using a Varchar. Changing to numeric did the trick!!
"tafs7" wrote:
> What is your value expression for the textbox?
> Make sure that the datatype expected for the field is a numeric value.
> If the format property doesn't work, set the value of your textbox to
> the following expression:
> =Format(Fields!MyField.Value, "C")
> or
> =FormatCurrency(Fields!MyField.Value)
> Regards,
> Thiago Silva
>
> Gaurav wrote:
> > Hi,
> >
> > I am using reporting services 2000. Setting the format to currency (C) is
> > not showing the formatted price.
> >
> > Is this a known problem?
>