Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_cool
Starting Member
43 Posts |
 Posted - 2006-02-17 : 03:29:17
|
| Hi allI am working on SQL reporting 2005I have my reports deployed on Machine AI am accessing this report from machine B.I have field on report that displays execution time on report.But the time that is displayed is of Machine A.How can i display time of Machine B on which the report is being executed?i tried using Date.Now() or only Now(), it didn't work.PLz help me.Waiting for reply. |
|
|
jhermiz
3564 Posts |
Posted - 2006-02-17 : 10:03:18
|
There is a global variable available to any RS report.Try:Globals!ExecutionTimeJon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2006-02-21 : 01:57:59
|
| i tried Globals!ExecutionTimebut its giving me the server time on which i have deployed reports.but i want local machine time that is accessing report.so plz help me. |
|
|
|
jhermiz
3564 Posts |
Posted - 2006-02-21 : 09:09:02
|
I am not sure this is possible considering the actual reporting db is sitting on the server. What about using SELECT GETDATE() ? Where is the actual server? Is it a remote server, is it local ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2006-02-23 : 00:11:05
|
| hii have already mentioned in my very first query that i have deployed reports on remote server.but i am accessing report from my machine.how can i display date & time of my machine on that report?plz help me. |
|
|
|
|
|
|
problem regarding displaying time