p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Reporting Services (http://p2p.wrox.com/reporting-services-205/)
-   -   Format Execution time (http://p2p.wrox.com/reporting-services/45698-format-execution-time.html)

baaul July 25th, 2006 02:46 PM

Format Execution time
 
Hello,

How would you FORMAT the execution time



using the standard "Globals.ExecutionTime" I get it as 07/21/2006 9:40:15 AM.



I would like to format this to July 21, 2006



Thanks!



-Baaul

JimReid July 25th, 2006 03:06 PM

:DLook in the properties for the formatting of the field. Very easy.
:)


Alvin DSouza February 3rd, 2015 04:18 PM

In addition to the answer this can be achieved by doing the following steps in the reporting database:
1.Go to the SQL server which is hosting your Reporting Services
2.Open the SQL Server Management studio and go to a database called "ReportServer"
3.Expand database "Reportserver"
4.Expand Tables
5.Open the table called "dbo.Subscriptions" in Edit Mode...You will see a column called "Locale"

For some reports which is showing "M/d/yyyy" format the locale will be set to value "en-US".
6.Change the value to "en-GB"

Now all your reports (including old ones) using @ExecutionTime will start showing date time in "en-GB" format i.e. "dd/MM/yyyy" format

That's it... Happy Reporting!!!


All times are GMT -4. The time now is 07:00 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.