p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Reporting Services (http://p2p.wrox.com/forumdisplay.php?f=205)
-   -   Format Execution time (http://p2p.wrox.com/showthread.php?t=45698)

baaul July 25th, 2006 01:46 PM

Format Execution time

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



JimReid July 25th, 2006 02: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 05:10 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.