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)

0
votes
1answer
71 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 ...
0
votes
0answers
12 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
122 views

Report Viewer web part connected parameters not visible

I have a SSRS report with two visible parameters, Location and department. I have hosted it in a sharepoint page using Report view web part. When I connect "Location" parameter of my report viewer web ...
0
votes
0answers
200 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
296 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
1answer
113 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
75 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
73 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 ...
0
votes
0answers
102 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
20 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?
0
votes
0answers
88 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
22 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
53 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
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
67 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
0answers
253 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
1answer
213 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
0
votes
1answer
472 views

SharePoint 2013 Workflow Reports

I created a workflow in SharePoint 2013 and would like to start collecting information on how long it takes for each task to be completed. I know of ways to build this type of data into the workflow, ...
0
votes
1answer
40 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
2answers
81 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
76 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
1answer
282 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
1answer
26 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
125 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
1
vote
0answers
245 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
0
votes
1answer
35 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 ...
2
votes
1answer
272 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 ...
1
vote
0answers
161 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
0
votes
2answers
55 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
-2
votes
1answer
142 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
524 views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
1
vote
2answers
4k 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
1answer
918 views

SharePoint SSRS Report in iFrame

How can I display an SSRS Report in an iFrame? Is there some setting somewhere to enable the content to be viewed? I know bing allows their page to be viewed in an iFrame, whereas google does not. ...
1
vote
0answers
171 views

SharePoint 2013 Reporting Service Integration mode

I face a difficult problem that I don't understand. What I have: SharePoint 2013 Enterprise SQL Server 2012 with all installed SP features, but configured in NATIVE mode. Both on the same server ...
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 ...
0
votes
1answer
113 views

Adding SSRS to Farm…Do I need to install Project Server onto instance?

We have a Sharepoint farm with four servers: Admin WFE Search Workflow We installed Project onto the farm and are looking to install SSRS into the farm on its own server. As part of getting the ...
1
vote
0answers
86 views

Reporting Services Webparts not Available in SharePoint Designer 2010

Firstly, I work as a DBA and have very limited understanding about how everything hangs together in SharePoint, so apologies if this is something pretty basic. We have just recently upgraded our WSS ...
1
vote
1answer
553 views

ReportViewer.dwp not working - Session state has been disabled

I'm getting this error while try to open ReportViewer.dwp: Message : Name=Request (GET:http://xxxxxxxx/_layouts/WPPrevw.aspx?ID=64) Message : Site=/ Message : Leaving Monitored Scope ...
1
vote
2answers
3k views

Display SSRS reports in SharePoint custom webpart

I would like to display SSRS reports in my custom WebPart. I would also like to set the permissions to particular AD user for accessing those reports. How can I do it programmatically?
0
votes
0answers
4k views

SSRS SharePoint Integrated Mode: The status code returned from the server was: 12019

I am running SSRS in SharePoint Integrated Mode and just recently started receiving the following error message when viewing a long-running report: ...
0
votes
2answers
183 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
0
votes
1answer
344 views

Refused to execute script Reserved.ReportViewerControl.axd in SharePoint 2013

We are migrating our ASP.NET WebForms and MVC 3.5 Application to our new SharePoint 2013. Lots of our applications use Reporting Services which use ReportViewer Control 9.0 but when we deployed the ...
1
vote
1answer
101 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: ...
2
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 ...
0
votes
1answer
74 views

Sharepoint and reporting services, how to reuse a report in another environment?

I see some link on a SharePoint 2010 portal. When I click on the link below I need to wait for 30 seconds and then I see some report generated and is showing in the reportviewer. It shows all items ...
1
vote
1answer
360 views

Repeating Login Prompts when deploying reports using Visual Studio 2012 BIDS

I am running SharePoint 2013 integrated with SQL Server 2012 and SSRS but I've been having problems trying to deploy my reports from Visual Studio 2012 BIDS. Whenever I enter in my login credentials ...
2
votes
2answers
612 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. ---> ...
1
vote
1answer
103 views

List view threshold in reporting services integrated mode in sharepoint

In one of my sharepoint sites I have a document library with 7,000 document sets, if I count the files inside there are 21000 files in total. In the beginning we had some views, but when they growth ...
1
vote
1answer
2k views

SharePoint 2013 SSRS installation problems

I am having a nightmare of a time with the SSRS/SP integration. Let me explain what I did. First, we have: 2 web front ends (WFE) 1 App server 1 DB server I installed both SSRS components (Addin ...
0
votes
1answer
150 views

How can I test an SSRS 2012 environment on production

I have a SharePoint 2010 site with SSRS 2008 running. I'd like to dabble with SSRS 2012 to check report compatibility, etc. Can anyone advise on how I can go about standing up an SSRS 2012 instance, ...