All replies

• 

  

  2

  Sign in to vote

  BobFromArgo,

   

  I found this page in BOL

   

  http://msdn2.microsoft.com/en-us/library/ms157406.aspx

   

  Fred

  • Marked as answer by Lukasz Pawlowski -- MSMicrosoft employee Wednesday, August 26, 2009 6:04 PM

  Wednesday, July 11, 2007 5:26 PM
• 

  

  0

  Sign in to vote

  I was searching for this one too.  This question was the first hit...  this was the second:

  http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!197.entry?sa=874245451

  Nice.

  Wednesday, September 29, 2010 12:37 PM
• 

  

  2

  Sign in to vote

  this is a complete list of SSRS Expressions Tips and Tricks

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/67660/

  • Proposed as answer by pmp07 Wednesday, September 29, 2010 7:03 PM

  Wednesday, September 29, 2010 7:03 PM
• 

  

  2

  Sign in to vote

  This is what I've been using with the Format function in SSRS expressions. It has all the codes and definitions.

  User-Defined Numeric Formats (Format Function) - http://msdn.microsoft.com/en-us/library/4fb56f4y%28v=VS.80%29.aspx

   

  User-Defined Date/Time Formats (Format Function) - http://msdn.microsoft.com/en-us/library/73ctwf33%28v=VS.80%29.aspx
  

   

  Format Function - http://msdn.microsoft.com/en-us/library/59bz1f0h%28v=VS.80%29.aspx

  • Proposed as answer by Pato_link Friday, March 2, 2012 9:24 PM

  Friday, October 29, 2010 4:44 PM
• 

  

  0

  Sign in to vote

  Looking for the SSRS Format expression codes I stumbled on this forum. The way I've got around it is by setting the format I want using the text box properties, then checking the format code it sets in the Properties window (bottom right hand corner one) under "Format", copy and paste this code into your Format expression with "" as wrappers and hay presto you get the format you desire!

  • Proposed as answer by CBarron1983 Wednesday, December 4, 2013 4:04 PM

  Wednesday, December 4, 2013 4:04 PM
• 

  

  0

  Sign in to vote

  In case someone stumbles upon this thread, I wrote a couple of articles that explain in detail how SSRS formatting works and what options are available.  Here they are:

  Formatting Numbers

  Formatting Dates
  

  ---

  MCITP SQL Server 2008 (BI & DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
  Check out my articles at BI: Beer Intelligence?

  Wednesday, December 18, 2013 1:05 PM