SRSS format codes?

All replies

• 

  

  0

  Sign in to vote

  Reporting Services uses the .NET format codes.
  
  Here are links to numeric and date time .NET format codes:
  
  Standard numeric format strings:
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
  Custom numeric format string:
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
   
  Standard datetime format strings:
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp
  Custom datetime format strings:
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp
  
  
  HTH,
  Robert

  ---

  Robert Bruckner   http://blogs.msdn.com/robertbruckner
  This posting is provided "AS IS" with no warranties, and confers no rights.

  • Proposed as answer by Jerry Nee Monday, November 23, 2009 2:11 AM
  • Marked as answer by bpeikes Monday, November 23, 2009 2:53 PM

  Thursday, November 19, 2009 2:35 AM
• 

  

  0

  Sign in to vote

  Thanks. It turns out I thought the .Net formatting codes were not working because functions like First() appear to return a string, so you have to enclose them with a CType() function if you want a format code to work on them. For instance, if you wanted to set the format field to do date formatting to "MM/dd/yyyy" you need to set a textbox on your report to CDate(First(Fields!ReportDate.Value)), where Fields!ReportDate.Value is a field from one of your data sources, otherwise the Format property does not get applied correctly.

  Monday, November 23, 2009 2:56 PM