SQL Server Reporting Services (SSRS) is server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your ...

learn more… | top users | synonyms (1)

6
votes
2answers
2k views

Performance Issues using SQL Server Reporting Services in SharePoint Integrated Mode [closed]

Does anyone have experience with the following issue? Are there any known workarounds? Official MS Statement: General overhead performance differences when you view reports in SharePoint integrated ...
6
votes
1answer
499 views

Using SharePoint UserAccountDirectoryPath with SSRS

I've got a SharePoint 2010 Enterprise multi-tenant setup integrated with a new SSRS 2008 R2 instance in SharePoint-Integrated mode and have FINALLY managed to get everything working. However, there ...
5
votes
2answers
2k views

Missing SSRS Web Services Directory

So the SQL Reporting Services Service Application is running, but from Central Administration, when I click on the service, then click "System Settings", it returns an error. Digging through ...
5
votes
3answers
5k views

Not able to deploy report to SharePoint 2010 in integrated mode

I am running SharePoint 2010 Enterprise with 2 servers in the farm (SharePoint and db server). They are both running windows server 2008 R2 and the SQL Server is also R2. I have installed the ...
4
votes
1answer
2k views

Connecting Web Parts across pages in SharePoint Designer

I am trying to connect some web parts across different pages (in the same site) and the behavior I am seeing doesn't make sense to me. I think I am missing something in my understanding. I am using ...
4
votes
5answers
1k views

Report Server Sharepoint 2013 Errors

We have Report server services in SharePoint Integrated mode and it was working up until last week but now when ever we are trying to open a report or data source we are getting the below error ...
4
votes
1answer
3k views

Reporting Services, get data from any Sharepoint List

I am trying to build an SSRS (2008R2) report based on a Sharepoint (2010) List. The main problem is that the List on which the report will run has to be a report parameter.I know what the list ...
4
votes
1answer
1k views

SSRS Managing parameters default value different behavior 2007 to 2010

Issue: After uploading a SSRS 2008 R2 RDL to SharePoint 2010, a listing of possible values of a query based parameter is not populated into a dropdown list next to the “use this value” radio button ...
4
votes
2answers
2k views

Publish SSRS report to SharePoint document library

This question is a copy of my question on stack overflow. Didnt know this forum existed until now. I cannot find a way to publish/deploy my reports to a SharePoint document library. I have exhausted ...
4
votes
1answer
2k views

Is it possible to view/edit SSRS datasets from sharepoint?

I have a bunch of shared datasets on my old report server and I want to copy them to a SharePoint Document Library. I'm running SSRS integrated mode in SharePoint 2013 and I've already created my ...
3
votes
1answer
24k views

Generate report from sharepoint 2010 list

I need to generate a report from sharepoint 2010 list using any good and easy method. Any suggestions along with the procedure are welcome.
3
votes
5answers
4k views

SharePoint 2013 Standalone VM for Development good enough?

I'm building a VM for SP 2013 development. Will be developing Solutions, WebParts, Custom forms, Dataviews, Business Data Connectivity, Custom Fields, inline Jquery, SSRS reports for deployment into ...
3
votes
1answer
1k views

SSRS SharePoint Integration on 2 Computer Deployment

I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this: My setup consists of a ...
3
votes
1answer
8k views

Programmatically set data source link for SSRS Report files

I have a scenario where I export/import a site collection with the Content Deployment Wizard. The problem is that all Reporting Services (SQL Server 2008 R2) reports (all located in the same document ...
3
votes
2answers
48 views

How to check SharePoint Installed in “SharePoint integration Mode”

Is Reporting Service Integration Mode available in the server farm or not. How to check? Environment: SharePoint 2013 Enterprice SQL Server 2008 R2
3
votes
1answer
45 views

List of all subscription

How to check all report's subscriptions on Sharepoint 2010? I know only how to check subsciption on specific report:
3
votes
2answers
174 views

Import-SPWeb - Feature 'ReportServer' is deployed but its version '14.0.0.0' is below the miniumum required version of '15.0.0.0'

I am trying to import a site from my production to test environment but am getting the error below. I've run psconfig but this hasn't upgraded the feature. Any advice on what I need to do to upgrade ...
3
votes
1answer
910 views

Connect all SSRS Reports in SharePoint library to DataSource using Powershell

We are migrating MOSS to SP2010 and have a library with hundreds of SSRS reports that use a Shared DataSource (in SharePoint Integrated mode.) Since the ReportServer database location has also ...
3
votes
1answer
179 views

What to do when SharePoint Lists and SSRS isn't enough?

I've developed a complicated InfoPath web form for reporting outages. This system will be maintained by someone with little technical skill, so in a lot of places the form populates its dropdowns from ...
3
votes
1answer
677 views

Why are web part connections in a template breaking?

We have a SharePoint site that we created based on a blank site template. We add lists, pages, webparts (including some connected web parts) and then save this site as a template (.wsp file). We ...
2
votes
3answers
1k views

Two different versions of RSViewerPage.aspx on same farm?

I have a SharePoint 2013 farm with SSRS. On this farm, I have two web-apps (A and B). When we created web-app "A", we made some branding customizations to the RSViewerPage.aspx page. The problem is ...
2
votes
1answer
7k views

The permissions granted to user 'MYDOMAIN\ryanhayes' are insufficient for performing this operation. (rsAccessDenied)

I'm getting several users getting access denied for some SSRS reports that are in a reports directory in SharePoint 2010. I have a single sharepoint group with all users in it so all users have the ...
2
votes
1answer
4k views

SSRS Parameters passed through URL not refreshed on Web Part Page

My working environment is SSRS 2008 and SharePoint 2010.I have a report with parameters running in SP 2010. I call my report page in SP 2010 from a page with all the parameters in query string. On the ...
2
votes
2answers
47 views

Where to Install Reporting Service

To use Reporting Service integrated with SharePoint, where to install Reporting Service? Suppose that SharePoint env. has two physcical servers: application and database server. Should reporting ...
2
votes
2answers
26k views

Tracking and reporting in sharepoint 2010 ? user accessing what kind of data ?

I want to track How many times a particular user has accessed what document in document library?and i need to show this in a report format. Also, i need to check what are links being accessed in the ...
2
votes
1answer
66 views

How to add SharePoint List as one of the data connection type in SSRS report?

I want to create a report with SSRS that consumes data from SharePoint list. When I add a new shared data source in the Business Intelligence Studio, all the options other than the SharePoint List are ...
2
votes
2answers
6k views

How to change Native Mode to SharePoint Integrated Mode in SQL Server 2012

I have installed SQL Server 2012 in Native Mode. How can I change it to SharePoint Integrated Mode? In the Reporting Service Configuration Manager Tool I found that there is no option to change Native ...
2
votes
1answer
1k views

SharePoint 2010 and SSRS 2012 Setup and Licensing

I am trying to setup SSRS 2012 in Integrated Mode so that I can attach my SharePoint to it. The issue that I am having is that it seems like Microsoft removed integrated mode and switch to using ...
2
votes
1answer
5k views

Create reports from SharePoint lists

We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
2
votes
2answers
680 views

Why am I receiving an error when trying to view a report in the report viewer webpart?

I am having trouble viewing reports in our company's SharePoint site using the report viewer webpart. Here are the version details: SSRS 2008, MOSS 2007, IE9, Win 7 32-bit. I can view the Sharepoint ...
2
votes
3answers
801 views

Is the Reporting Services Integration for SharePoint 2007 Really Worth the Effort?

I have had nothing but frustration with MOSS 2007 SP2 + SharePoint Reporting Services + SQL 2005 SP2. I even followed Raju Sakthivel's guide to SSRS + SharePoint Integration , but I cannot publish a ...
2
votes
1answer
81 views

Is it possible to get data from excel file and create a pie chart and display on a sharepoint site?

Can we create a pie chart using excel reporting service. I have a excel file (.xlsx) on my SharePoint document library. I want to use excel data and create a pie chart but don't want to create this ...
2
votes
2answers
53 views

Sharepoint reporting on permission

I wanted to get a report of all the user in SharePoint and know what each user has permission. I am trying to track down each user permission level for every site they have so I can identify if they ...
2
votes
1answer
153 views

Cannot create subscription in SSRS (2008) . Sharepoint 2010 as datasource(XML)

I created a report which displays sharepoint list in SSRS using XML as datasource. I can view the report but i cannot create subscription in SSRS. Here is the error Subscription cannot be created ...
2
votes
1answer
342 views

SharePoint 2013 + Reporting Services + Kerberos

How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database? I found below blog but I'm not sure about ...
2
votes
2answers
703 views

SharePoint Document Library Subscription Errors

I have SSRS 2012 setup in SharePoint Integrated mode. I am receiving the following error when trying to setup a subscription to a SharePoint Document Library. A delivery error has occurred. ---> ...
2
votes
1answer
71 views

Site Column as an SSRS Dataset

Is it possible to use a Site Column (Choice) type as a dataset for use in SSRS reports? I can use a combination of hidden parameters, VBA code and a list to effectively obtain a distinct list of ...
2
votes
1answer
767 views

How to Pass parameters from Javascript Client Object Model to Report Viewer Web Part?

I have some SQL Server Reporting Services (SSRS) reports that take parameters. I am displaying these reports via the SSRS Report Viewer Web part on a site page. I have the parameters that are needed ...
2
votes
1answer
108 views

Reporting Service on SP 2013 use a sql 2012 report server running as native mode?

Sharepoint Reporting Service Integration has to be done with a report server running on SP integration mode? Is this true in SQL2012 + SP2013? I have a SQL2012 Report server which is in Native mode ...
2
votes
1answer
282 views

SharePoint, LINQ & Reporting Services Tools

I'm new to SP and SSRS, so I want to check if my thoughts are correct. Report Builder and BIDS suck on data retrieval so I have to go deeper using code. Is it possible to write some code in C# using ...
2
votes
1answer
2k views

Adding Report Viewer Control on Custom Web Part ASCX Control

I am trying to use Report Viewer control in one of my custom web part (on ascx) of SP 2010. As I drop the report viewer control on my ascx it register its assembly on top with assembly version 10.0.0....
2
votes
1answer
770 views

Deploying reports with enabled Forms Based Authentication (FBA)

Configuration: Sharepoint 2010 Reporting Services Integrated Mode Claims Authentication with Windows Authentication (NTML) and Forms Based Authentication Enabled I can deploy reports from Visual ...
2
votes
2answers
328 views

SSRS Report Content types available in Central Administration but not in Sharepoint Site

I am trying to get Sql Reporting Service running with Sharepoint server, and I have a two computer deployment, like example 2 on this page: http://msdn.microsoft.com/en-us/library/bb677365.aspx ...
2
votes
2answers
1k views

SSRS ReportViewerWebPart Height Issue

I am working with a customized page that has an embedded ReportViewerWebPart inside of a content tag. In this case, it's inside of "PlaceHolderMain". It looks like this: <asp:Content ...
2
votes
1answer
3k views

Sharepoint 2007 Create Reports

I'm really new to sharepoint and I'm using sharepoint 2007. I need to create reports from the document libraries and lists. But i don't know how to do it. In a forum I saw I have to use "Reporting ...
2
votes
1answer
455 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...
2
votes
1answer
2k views

Grant Database Access for Reporting Services: A connection to the computer cannot be established

On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting ...
2
votes
1answer
83 views

SSRS data source: Can't use stored Windows credentials, “SharePoint does not use Windows authentication”

I'm running a single-server deployment of SharePoint 2013 and SQL Server 2014 with SSRS in SharePoint-integrated mode. When trying to set up a subscription for a new report, I get a popup saying: ...
2
votes
0answers
57 views

Report alerts still sending after alert and report was deleted

I have an SSRS report in SharePoint 2010, there was an alert set to send every minute regardless of whether the data changed. This alert was deleted, then the report was deleted, but its still sending ...
2
votes
0answers
288 views

Error on creating Report Model :Data extension does not support model generation

I'm trying to create a Report builder Model using a SP Custom List as Datasource. But it returns me the following error: Data extension does not support model generation. ---> Microsoft....