Codejock Developer Community : .Format Currency http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:05:51 +0000 Fri, 10 Dec 2010 03:56:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17403 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[.Format Currency : You should set the properties...]]> http://forum.codejock.com/forum_posts.asp?TID=17403&PID=61759&title=format-currency#61759 Author: Baldur
Subject: 17403
Posted: 10 December 2010 at 3:56am

You should set the properties .Value for the unformatted value and the .Caption for the formatted value.
The .Format-Property excepts also VB-Formats like "$#,##0.00;$-#,##0.00"
]]> Fri, 10 Dec 2010 03:56:15 +0000 http://forum.codejock.com/forum_posts.asp?TID=17403&PID=61759&title=format-currency#61759 <![CDATA[.Format Currency : Hi mar72vin. I prefer to do the...]]> http://forum.codejock.com/forum_posts.asp?TID=17403&PID=61201&title=format-currency#61201 Author: CapoPezzio
Subject: 17403
Posted: 29 October 2010 at 6:14am

Hi mar72vin. I prefer to do the formatting on the Metrics in the BeforeDrawRow-event.

Metrics.Text =string.Format("{0:0.00}",_value).

Then I leave the .value and .caption "untouched" and the groupFormulas are working fine
]]> Fri, 29 Oct 2010 06:14:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=17403&PID=61201&title=format-currency#61201 <![CDATA[.Format Currency : Thanks Aaron! Unfortunately I...]]> http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60834&title=format-currency#60834 Author: mar72vin
Subject: 17403
Posted: 12 October 2010 at 5:34pm

Thanks Aaron! Unfortunately I already tried this and after reading the docs I realize why. Only the "%s" type is supported with the Format method.  This means that the Format method will only format strings and treats all numeric values as strings.

I am experimenting with converting my decimal to a string prior to adding it to the report with string.Format("{0:0.00}",_value).

I would prefer to be able to supply the decimal value to the report control and allow it to do the formatting.

Strangely I have also noticed that when a format is applied the groupformulas SUMSUB does not work. Does this mean that I need to supply values for both the .Value and .Caption of each item so that the groupFormulas are working on an un-formatted value. Is there a better way to do this?
]]> Tue, 12 Oct 2010 17:34:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60834&title=format-currency#60834 <![CDATA[.Format Currency : Hi, Try this: .Format = &#034;$...]]> http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60828&title=format-currency#60828 Author: Aaron
Subject: 17403
Posted: 12 October 2010 at 4:25pm

Hi,
 
Try this:

    .Format = "$ %.2f"
 

 
 
]]> Tue, 12 Oct 2010 16:25:38 +0000 http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60828&title=format-currency#60828 <![CDATA[.Format Currency : Hi Guys,I am currently using (Item.Format...]]> http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60797&title=format-currency#60797 Author: mar72vin
Subject: 17403
Posted: 11 October 2010 at 6:55pm

Hi Guys,
I am currently using (Item.Format = "$ %s") to format my data as currency. This is fine except that my data is stored in a decimal value and the report control shows 4 0's. i.e. "$ 100.0000".

What format can I use to only show 2 decimal places?
]]> Mon, 11 Oct 2010 18:55:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=17403&PID=60797&title=format-currency#60797