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)

1
vote
2answers
3k views

SharePoint 2013 SP1 Installation Issue- SSRS Content Type Missing for New SC

Recently I have Installed SharePoint SP1 (15.0.4571.1502) I have Create a New Web application and SC with BI Center Template. Activated the Report Server integration feature and deployed PowerPivot ...
0
votes
0answers
38 views

SSRS Integration and SharePoint 2013?

I have a new SharePoint 2013 farm that is running on a SQL 2012. I have SSRS libraries working in SharePoint but we also have seperate SSRS servers (some SQL 2008 R2 and some SQL 2012). We want to ...
0
votes
1answer
70 views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
0
votes
0answers
35 views

Dropdown parameter of ssrs report in sharepoint webpart got hang when clicked

I am creating a web part which will have a SQL server report integrated into it. i have 6 parameter in the parameter box. one of the parameter have drop down in it. when i click on the drop down for ...
2
votes
1answer
42 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 ...
0
votes
0answers
22 views

Report off SharePoint List

I have a SharePoint 2013 list. This is On Prem. The list has a notes section. I run a report daily that pulls certain fields from that list, including the note section. I am having a formatting ...
0
votes
0answers
45 views

Connecting using SSRS Report SharePoint list datasource - Windows Integrated Security doesn't work

I have a report I'm building using SSRS and a SharePoint List as datasource. The report works ok only if I login with my credentials before viewing the report. My credentials do not pass automatically ...
1
vote
1answer
21 views

Impact of upgrading Sharpoint 2013 to Sharpoint 2013 Service Pack 1 on SSRS Reports

Hope you all are doing well! We have a BI System that consists of SQL server Reporting Services 2008 R2 and we have deployed the reports on Sharepoint 2013. We were planning to upgrade the Sharepoint ...
0
votes
0answers
365 views

Add ReportViewer WebPart at runtime

I am working with feature receivers in SP2010. I can successfully create web part pages and drop web part on the pages on feature activation.I was trying to add ReportViewerWeb Part (Integrated Mode) ...
0
votes
1answer
38 views

SSRS and Item-Level Permissions

Simple and straight question: Will users that access the SSRS reports I have connected to my SharePoint list inherit the permissions set for that list, including item-level permissions?
3
votes
1answer
133 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 ...
0
votes
0answers
41 views

Ad-Hoc Reports in SSRS Sharepoint 2013

Is it possible to generate models in SSRS from SharePoint Lists? When trying to create Models, through Report Builder Model as SharePoint List as datasource, following error is displayed. Data ...
0
votes
0answers
17 views

SSRS 2014 wITH SharePoint 2013 foundation

I am a SAP BI consultant and have been more than itching to get on MSBI bandwagon. I have had a major roadblock in the form of SharePoint. I have SQL Server 2014 installed on my laptop which is 16GB ...
0
votes
1answer
38 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
0
votes
0answers
20 views

Use [Me] As Parameter In SSRS Report Builder 3.0 Report

How can I roll up tasks using the SharePoint equivalent of [Me] as a parameter in a Report Builder 3.0 report?
0
votes
1answer
60 views

Item-level Security on SSRS report from SharePoint list

We have created an SSRS report from SharePoint 2010 list. We have item level permission in the source list, so the user can view only the items for which they have privilege. But in SSRS report it ...
1
vote
2answers
793 views

Reporting Services Error after doing a restore on a new farm and attempting to view a report

The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound) The source farm reports work fine, but after the restore to a new farm, some (not all) reports get this error. Looked ...
1
vote
1answer
15k 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.
0
votes
0answers
11 views

Fetch User Access permissons from SharePoint reports(.rdls)

I have a sharepoint site where DWH reports are hosted. I wanted to create a report which provides me the list of existing users having the access on each .rdl. Is there any PowerShell script or Sql ...
0
votes
0answers
113 views

HTTP 403 Forbidden on accessing layouts pages from a SharePoint 2013 app web

I have added the report content types (that comes with reporting services) to a document library in an app web. But when creating an new report by the ribbon > New document I get a 403 Forbidden ...
0
votes
1answer
176 views

Pass current user filter to ssrs hidden parameter

I have a SSRS report hosted in sharepoint (in Report Viwer Webpart).That report has a hidden parameter "username". I want to pass current user to that ssrs report. But when I tried to connect to ...
0
votes
0answers
64 views

SSRS Multi Parameter Report not working in Sharepoint 2013

I have a report which has 2 Parameters both are multi select. It works fine in SSRS Reporting Manager and Report Builder but when I host in SharePoint and try to select multiparameter it doesn't do ...
0
votes
0answers
55 views

rsItemNotFound, while adding XXX.rsds

I'm getting rsItemNotFound Error while creating Report Data Source in SP2010, Report Services is activated. Any help on this.
0
votes
0answers
62 views

Reporting Service Integration mode and Key not valid for use in specified state

I had to uninstall SharePoint Foundation 2013 and reinstall it. What I have done: I uninstalled SharePoint and after that I removed all databases. I reinstalled SharePoint Foundation 2013 and it ...
0
votes
0answers
16 views

SSRS 3.0 Reporting on Folder Inside List

How can I create a report that uses a specific folder inside a SharePoint 2013 list as a Data Set?
1
vote
3answers
20k 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 ...
0
votes
0answers
55 views

Invalid URL Error when deploying rdl to SharePoint 2010

Has anyone come across the following error when trying to deploy a .rdl file onto SharePoint 2010? Report Server has encountered a SharePoint error. ---> ...
1
vote
1answer
19 views

Sharepoint reports showing up as xml

We recently installed PowerPivot into our SharePoint environment and it started causing issues with our reports(.rdl) which are now displaying as XML. Any ideas what might cause this?
0
votes
0answers
25 views

How can I display remote SSRS reports

We have a new installation of SharePoint 2013 on-premis using SQL Server 2012 R2 database. We have not installed or setup SSRS in this SharePoint environment, and we hope to not have to. This ...
0
votes
0answers
11 views

Query to get name of document, which modified in given time line

I am creating the SSRS reports in Visual Studio 2008 using SharePoint 2010 list as Data source. Structure of list is: When users select the region and timeframe, it should go the associated ...
1
vote
1answer
54 views

Is there a way to log specific clicks?

I need to log when users click on specific links on our SharePoint site. Something like: bob@company.com - Clicked Special Link #1 - 02/13/2015 14:41 joe@company.com - Clicked Special Link #7 ...
0
votes
2answers
907 views

Why are Reports returning a 504 Gateway error?

I've created some reports in BIDS and uploaded the .rdl and .rds files to a SharePoint Report Library. Attempting to access the reports leads to a 504 Gateway Time-out The server didn't respond in ...
0
votes
0answers
103 views

Generate automatically SSRS reports via SharePoint Workflow

I have developed SSRS reports (.rdl) and I want when a user subscribes to a report, this one will be generated by a workflow periodically, how can i do that on SharePoint 2010 ?
0
votes
0answers
132 views

Printing Report Crashes IE - SP Integrated SSRS / SP2010

Scenario: A SharePoint 2010 Site dedicated to SSRS Reports When a user navigates to a report and clicks on the report name, the report opens fine When a user selects the "Print" option from the ...
0
votes
2answers
66 views

PerformancePoint webpart showing report from Reporting Service, but is showing cached content!

I am using sharepoint 2010. I have created some reporting service report. On some page, I have created the PerformancePoint webpart to show the reporting service report. It works and shows content. ...
0
votes
1answer
33 views

SharePoint 2013 and ReportingServices2010 CreateDataSource Example

Can anybody help me with how to use CreateDataSource with SharePoint 2013 to Create a Data Connection in C# code?
0
votes
1answer
34 views

Create a ReportingServices data source and upload to a data connection library

I have installed reporting services 2012 in SharePoint 2013 integrated mode. I need to create a report data source and upload it to a data connection library using C#. As I know it uses the ...
0
votes
0answers
57 views

SSRS Web Part Page - HTTP 400 Bad Request

I have several pages that have a single instance of an SSRS ReportViewer web part. Switching between pages or simply refreshing the page adds a new Reserved.ReportViewerWebPart.axd request cookie. ...
1
vote
1answer
652 views

SharePoint 2013 Manage Reporting Services Application crashing

I had integrated reporting services working nicely, then I changed something and when I go into Manage Reporting Services Application -> System Settings this happens: Sorry, something went wrong The ...
0
votes
1answer
53 views

What is the best practice to create some SSRS report to show info from a list, and show in a webpart in SP 2010?

I am using SP2010. I have a list with some important info. I would like to generate some report in SSRS. What is the best practice to create a SSRS report with the source from a SharePoint list? I ...
0
votes
0answers
48 views

CAML query reporting services, date field

I am using reporting service to query (with CAML) a list on SharePoint. The list has an external content type, my problem is that just the Date field is not rendered fine. This is my result: ...
-2
votes
1answer
131 views

SharePoint WCF SOAP, Rest, AJAX [closed]

I need to know the following things: How is SharePoint used with WCF, REST and SOAP.
0
votes
0answers
36 views

Reporting server issue - external content type list

I created a new report with Report Builder, it is working fine into the client but when I open it in SharePoint I get this error: The shim execution failed unexpectedly - Proxy creation failed. ...
0
votes
1answer
129 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
0answers
25 views

Connect to Report Server from SharePoint 2010 in Native Mode

I have a SharePoint 2010 installation in Native mode. As per company rules, I cannot have Integrated mode for this solution. I need to connect to a report server containing SSRS reports so that I can ...
0
votes
2answers
98 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
0
votes
1answer
21 views

SharePoint reporting services integration

I am using the SharePoint report services integration. I deployed a report to a document library, but when I try to view the report (form SP), I receive this error: login failed for user 'nt ...
0
votes
2answers
2k views

SSRS Dataset valid, but data does not show up in generated reports

I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder. When I hit "run query" on my dataset in the query designer, I ...
0
votes
0answers
117 views

SharePoint Foundation 2013 - report / chart / Graph for Employee vacation

In SharePoint Foundation 2013 I want to create a report / chart / Graph for Employee (Employee Id,Employee Name & Department) which will show month wise from which date to which date Employee are ...
1
vote
1answer
77 views

Dates returned as #error in SRSS report from SharePoint list

I have connected an SRSS report (in SQL Reporting Services 2012) to a SharePoint 2013 list. Date fields all return #error, but other fields return data successfully. May query looks like this: ...