Since migrating Reporting Services from SQL 2005 to SQL 2008, the Last Run date, visible on the Details view of reports in a folder under Report Manager, has been blank. I would hope that this is supposed to be populated and equivalent to the "When Run" date visible in the 2005 version of Report Manager. Does anyone know of any setting that needs to be configured in order for this to show, or if this has been reported as a bug?
The "Last Run Date" of the report is stored in the Report Server database in the execution log table. Are you purging data? Otherwise this only saves for 60 days by default. When pulling from this table you'll have to pull the "Max(lastrundate)" to get the date.
I am not referring to a table or a date column which I would have to query on my own. My question is in regard to the Report Manager web application, and, specifically, the Details View of a folder in Report Manager. This view has a column with the heading "Last Run", which is followed by a column headed "Modified Date": there are actual dates and times under the latter column; however, the column underneath "Last Run" is empty. I would expect Report Manager to populate this column by default, but, that does not seem to be the case.
Is there any way to attach an image of the browser application to this posting, so that I can better illustrate the issue?
Hi Tim Peters,
I am sorry for misunderstanding your requirement, after your detailed information. I get your meaning completely. It does exist one clumn called "Last run" on report manager, however this column is relevant to SubScription, if you create a subscription and set a schedule for a report. After the schedule time, you will see a value in the "Last run" column. If you want to view the Last execution time, you could achieve this requirement on report, there is a build-in datafield called Globals!ExecutionTime, you could add a textbox on the report then type in the expression =Globals!ExecutionTime. Then you could see the execution time when some body open the report.
Challen Fu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
When one is viewing the Subscriptions Page for a report, there is. indeed. a column labeled "Last Run", and, for those reports for which we've defined subscriptions, that column on that page is populated.
However, when one is viewing the Detail view of reports in a folder (i.e. the Contents Page), there is a column there that is also labeled "Last Run"; however, one would expect that column to contain a value relative to the context in which the page operates; that is, a Last Run, or Last Execution, date for that report. This column contains no value (neither a last subscription execution date, or a last execution date), despite the report having been executed regularly on a schedule.
I'm not clear on how to use a built-in field called Globals!ExecutionTime to correct what appears to be, to me anyway, a bug in the Report Manager application.
This is a known issue with the new Report Manager layout in 2008 R2 and is being looked at for a future release. You can monitor the progress on this issue at the MS Connect site where the issue has been submitted. You can also vote on the issue to show that it is an important fix for you.
Josh Gerszewski, MSFT
- Edited by Josh GerszewskiMicrosoft employee Thursday, January 19, 2012 9:26 PM
Anyone anywhere got any latest update around this bug ?? Or is it still pending resolution ? I am also struggling with this issue as the business users would ideally like to see this field populated.
Can someone please update this thread accordingly.
Thanks in advance !!