Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 45, comments - 91, trackbacks - 0

My Links

SQLTeam.com Links

News

Add to Technorati Favorites


Archives

Post Categories

About me

Formatting strings

I just completed teaching a Microsoft SQL Server Reporting Services class in Charlotte, North Carolina - a wonderful and beautiful place to visit!

In a couple of the demonstrations, we used some predefined formatting strings to customize the way a user can see a value in a report. For example, we used C0 to display a currency value with no numbers to the right of a decimal point.

One question that almost always comes up during the class is: where can I find a list of those predefined formatting strings?

Microsoft has them on the MSDN Library site, but the are buried and rather difficult to find. So, I thought I'd share them with you here. These links are for v2.0 of the .NET Framework, however these pages include links to other versions including v1.1, v3.0, and v3.5 of the .NET Framework.


Enjoy!

Joe
kick it on DotNetKicks.com

Print | posted on Wednesday, March 12, 2008 5:46 PM

Feedback

# re: Formatting strings

I made those into cheat sheets: http://john-sheehan.com/blog/index.php/net-cheat-sheets/
3/13/2008 1:16 AM | John S.

# re: Formatting strings

Good stuff, Joe, this will help those who somehow feel that it is just "easier" to format via converting everything to VARCHAR within the database!
3/15/2008 1:37 PM | Jeff

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 2 and 3 and type the answer here:

Powered by: