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

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

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

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint


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




View Complete Post

More Related Resource Links

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

How to Schedule SSRS Report from SharePoint

I don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty. Technology - SQL Server 2008 R2 - SharePoint 2010     

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

Sharepoint + SSRS -Report Security??? An unexpected error occurred while connecting to the report s


I am able to deploy reports and run them as the farm admin that I did the Grant entry for in CA > App Mgt > Reporting Services > Grant DB access.


However, my AD personal user that has Local admin on every server has integrated SA security to the SSRS and Sharepoint Database is a Farm admin get's this error trying to run the reoprts.


An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.


Now if I log in as the farm admin ( the user I did the grant on) I can run and add the reports to the SSRS webpart... Am I going to have to add every user through that Grant feature? With integrated Sharepoint security there is no /reports virtual to decide what users can run  what reports so I'm not sure..


Some  other details.. I'm using Kerberos security, and CA > App mgt > Reporting Services > Manage integration mode is set to Trusted (not Windows).. otherwise .. I can't pull up Default settings under that Reporting Services section of CA.


I also d

I'm getting exception while running Report builder 2.0 for SSRS Reports

I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.


Pictures from SSRS report not displaying in Sharepoint



I am using the Page Viewer Web Part to display a Reporting Services report in SharePoint. It was working fine until I tried caching the report in Report Manager. Now, when running the report in SharePoint, the Dundas Charts and Map that are in the report aren't displaying. It's just the typical red x instead of the pic. If I right click and do Show Picture it works, but that won't work for end users obviously. I do have a regular SSRS table at the top of the report, and that displays fine every time.

Does anyone know what is causing this? I'm thinking it must have something to do with caching the report and/or Dundas, because again, everything was fine until I set it to cache.

Thanks for your help.

SSRS Reports Not updating in Sharepoint 2007


Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.


I figure it is a caching issue but how to get around? HELP!

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

how to distinct values of sharepoint custom list using SSRS (new from http://social.msdn.microsoft.c


i hope jin chen would read this.

i followed his instruction from the link above(in the title)

i still got an error message :

System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42105] Function 'RemoveDups' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.’.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetReportDefinition(String Report, Byte[] Definition, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

could anybody tell me what's wrong?

and by the way,

i'm using ssrs 2008 r2

i use report builder(content type) to create reports from sharepoint lists.

thx in advance.



SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

SSRS 2000 reports when upgraded to 2005 report with subreport really really slow


We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.

The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.

Both in the BIDS environment as well as the report site the report is very slow.

We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.

Can anyone please help me here?

Regarding the Subscription of SSRS reports from the Sharepoint Portal.



         At present, I am having some SSRS reports hosted on share point portal and For one report, I am subscribing thorugh manage subscription by mentioning the dropdown values (The Selections which are required for the report) as parameters. So that, I am going get a mail for the report for the selection which I made from the report.

Now The Issue is, for every combination I should need to select the parameters and need to subscribe for that. Is it possible to mention all the selection crieteria at once and run it in one shot?

Can we write any backgroud job to complete all the selection criterias at once?

Please help me on this.

Thank you!!



Sharepoint & SSRS 2008 "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft


my environment as below:

1- SERVER A (SQL server DB 2008 sp1)
2- Server A (SSRS 2008 sp)
3- SERVER B MOSS 2007 sp1
I configured the SSRS to be sharepoint intergated mode but when i  hit the Web Service URL i got the error below:

Reporting Services Error

  • The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled)

    SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


    Hi All,

    I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

    My Data Source Properties are as per below

    Use this user and Password

      user name: domain\myadminuser


    Selected: use as win auth

    Selected: Impersonate


    How Can I get rid of prompt?






SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser


Selected: use as win auth

Selected: Impersonate


How Can I get rid of prompt?





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