.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Report that list what reports have been run

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Using SQL Server 2008 R2 Is it possible to run a report that lists (1) What reports have been run, (2) who has run the report, (3) number of times a given report has been run, and (4) when was the last time the report was run. Thanks for your help. I look forward to hearing your comments!

View Complete Post

More Related Resource Links

How to enumerate/list all Reports in a Report Library (to Delete)


What is the suggested Method for enumerating all Reports in a SharePoint Report Library? These reports have been rendered to PDF and stored in the Report Library. The intention is to get the [list] to perform a Delete operation if they are outdated/incorrect.

I need to do this with .Net, ASP.Net using the ReportingService2006.asmx web service.

I need to get the list to present an on screen ASP.Net UI with a Checkbox option to execute the DeleteReport() method.

Thanks everyone,

Crystal report with dataset and list - please help


Hi Guys;

i'm new in reporting so thanks to be patient with me,

here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.

i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed Cry

looking for yor help


SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




One report >> Multiple Linked Reports in different folders?

I love Linked Reports in SSRS because of my ability to change one report in one project and post changes to one location on my SSRS server and then have those changes take effect in my linked report.  Today however I was asked to make one of those reports which is already liniked elsewhere to be linked to two locations and I was dismayed to find out that there is a chance that its limited to one linked report for any source report. Can someone tell me this isn't so and show me a way around this?  I don't want to have to post my RDL to multiple locations unless its absolutely necessary. I'm using SQL Server 2008, SSRS2008, Standard Edition. Thanks, Keith

How to diable the scrool bar on reports in Report Manager

Hi, I deployed some reports unto report manager.  When opening them, I noticed that all of them by default had scroll bars around them. Is there anyway I can set the scroll bar adjustable or disable the scroll bars? thanks !  

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

Report Builder 2.0: duplicate rows do not show on reports

Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

set the Report URL property to a specific report dynamically based on the selection in the list.

Hi I want to use  embedding the Report Viewer Web Part in a Web page, and I know we  should set the Report URL property to a specific report. but  is there a way by which we can set the url  dynamically based on the selection of the report  from  the list How can I customize this  feature Any Help on this is appreciated. Thanks

Rendering reports in crystal report viewer

I am trying to put a crystal report viewer into MVC. When I point a report to the viewer, this is what I get.The report is able to display however there are these box surronding the textfield objects of the crystal report. The attached image is what is being displayed when I view my report on a view.

Two crystal reports in a single report viewer

hi...to alli want to generate the two crystal reports one is employee and another is project.now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer..can anybody help me.. plz

Using Sub reports and dynamic crystal report generation

Hi..........friends,         I am working on crystal reports to generate Ration card details.My form  consists of the fields like Address details of the ration card owner,existing ration card details and family members details.in these Family Details i have to generate dynamically according to the count of the family members.I am new to crystal reports.I am confusingabout whether i have to use sub reports or formula fields.................               Plz help me                                                                    Thanks in advance      

rdlc report list inside another list

HiI created a list that will show several lines of data in a report, but each of those lines have between 1 to 5 records of another table in the DB. So, what i would like to know if it is possible to add a list inside another list. And if it is, how can the child list get the correspondent id from the mother list.Small example of what i want to do:Can anyone help me?

Sharepoint list as Report Data Source

My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?  

Cannot Deploy Reports to Report server - Times Out

I have SQL Server 2008 Developer SP1 on XP Pro SP3 to become familiar with its capabilities.  I installed the AdventureWorks sample database and was able to generate a cube, but I have not had the same success with reports.  I am trying to publish the sample reports to Report Server, but every report fails.  The errors says that the operation timed out.  However, the data sourse appears to publish correctly.  When I go to Report Manager, the data source is in the Data Sources folder and I see the AdventureWorks 2008 Sample Reports folder, but it's empty.  I tried loading the rdl file from within Report Manager, but it also fails.  Eventually, it gives me an empty dialog box for a username and password, but I configured Report Services to use a built-in account so I do not have a username or password to provide.  I have been searching forums for the past week, but cannot find anyone with a similar issue. Here is the portion of the log dealing with the deployment error: library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/AdventureWorks 2008 Sample Reports). library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/Data Sources). library!ReportServer_0-2!a44!06/06/2010-04:16:24:: Call to GetItemTypeAction(/Data Sources/AdventureWorks2008). library!ReportServer_0-2!a44

"Load Report failed " after migration of VS 2008 to VS2010 with SAP crystal reports installed

i have migrated VS 2008 application in VS2010  including crystal report. i have installed SAP crystal reports to support  crystal reports in VS 2010. how can i migrate the old reports into SAP crystal reports please suggest me.

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user


Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend