Login   Register 
Receive news via our XML/RSS feed
Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles
  • Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
    Creating an SSL Certificate to ensure your confidential reports remain confidential


  •  
    Boost Data Ltd.
     
     
    SQL Reporting Services - Answers to your questions
     
    Author Thread: Report Language and Date Formatting
    bluecjh

    Report Language and Date Formatting
    Posted: Wednesday, March 24, 2010 11:06 AM (GST)

    RS 2005.
     
    Currently our report dates format by default in US format. i.e MM/DD/YY
     
    To obtain UK formats we have to apply formatting formulae in text boxes etc...,
    which is a bit cumbersome.
     
    I am aware that I can set the XML in the body of the report to English. i.e. <Language>en-US</Language>
    to
    <Language>en-GB</Language> but is there a more generic server setting, or would the issue be in the local settings for BIDS. This seems to be a commonly blogged issue, but I can find no authoritative answer for this....
     
    Many thanks for any help.

     

     

    Comments:  

    Author Thread:
    William Vaughn
    Report Language and Date Formatting
    Posted: Friday, March 26, 2010 6:51 PM (GST)
    I haven't seen anything in VS to support having this setting be made automatically. I think there is an argument for just such a feature to support a variety of settings. For example, I would like to see the ability to create a set of coded functions that could be managed centrally (like a stored procedure) and invoked by reports like the built-in functions.
    Bobghw
    Report Language and Date Formatting
    Posted: Sunday, March 28, 2010 11:03 PM (GST)
    In the properties for the report set language to English(United Kingdom) then dates will render dd/mm/yyyy

     
     
     
     
     
    Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About