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

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

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!!!