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 - 2005-12-22 : 00:19:25
|
| Hi can i display processing time in reports developed using SQl Server reporting services?(I do not mean Execution time)What i mean by processing time is that the time that is displayed at rightmost side on Google search result page , which is usually some fraction of second.Can i display such processing time on my reports?If yes plz tell me hoe to do it? |
|
|
jhermiz
3564 Posts |
Posted - 2005-12-22 : 09:12:29
|
The ReportServer has nifty tables that store this information. Please read the second article in my blog located: http://weblogs.sqlteam.com/jhermizAnyhow back to your question, because a report depends on its dataset you will need to do two things: 1)Create your original report with its own dataset2)Insert another object into this report (by object I mean table, matrix, list, etc) and set its data set to something totally different than the 1st datasetSo you will need two datasets. The first one of course I cannot help you with since this is your own business report. The second one answers your question about processing time. Run the following in Query Analyzer:USE ReportServerGOSELECT c.Name, e.TimeEnd-e.TimeStart, --because processing time is slow we cant use: -- DateDiff(d, e.TimeStart, e.TimeEnd) e.TimeProcessing, e.TimeDataRetrieval FROM ExecutionLog e INNER JOIN Catalog c ON c.ItemID = e.ReportIDGO
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Displaying processing time in reports