Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [reporting-services]

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 reporting functionality. Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports.

0
votes
0answers
17 views

The requested Data Feed could not be found (rrDataFeedNotFound)

we have couple of rdl files with data alerts in SharePoint from past week we are getting status as The requested Data Feed could not be found (rrDataFeedNotFound)The log file contains detailed ...
1
vote
1answer
63 views

SharePoint 2013 - SQL Server Reporting Services Service Application Error

I have 2-tier architecture i.e. SharePoint 2013 and SQL 2012 servers. I have configured the SSRS in SharePoint mode from SQL 2012 SP1 in the SharePoint server by following this link. The SSRS ...
2
votes
0answers
69 views

SSRS 2008 R2 Shared Datasource References Gone

I have a farm with SharePoint 2010 integrated mode SSRS 2008 R2. A few days ago, one night at about 02:00 AM, almost all shared data source references had gone. I couldn't find any clue at neither ...
1
vote
1answer
33 views

sp2010 to sp2016 and reporting services viewer in sharepoint 2016 error

I made a migration from sharepoint 2010 to 2016, and I'm having a problem, I'm using reporting services and I want to visualize reports from the browser without using report builder but, I cannot do ...
0
votes
0answers
22 views

TaskDriverEventArgs.EventCriticalityType error while installing Microsoft SQLServer 2012 Rs Add-in for SharePoint

HI i when I try to install Microsoft SQLServer 2012 Rs Add-in for SharePoint in one of WFE server I get following exception and installation not succeeded and i get below error in ULS logs and event ...
1
vote
0answers
40 views

Sharepoint List's Custom Field value appears empty in ssrs report when run in sharepoint integrated mode

I have a sharepoint list that contains custom field(its is developed as .wsp solution), its a file upload control and two rendering templates 'display' and 'edit' templates are defined. 'Display' ...
2
votes
1answer
15 views

Sharepoint 2010 - Exporting config settings for all lists, workflows, and libraries

Is there a way to export the design/setup of all my lists, libraries and workflows? I'm looking for something kind of like this: List 1: Permissions: Columns: Associated Workflows: Workflow 1: ...
0
votes
0answers
17 views

ReportServer -> ManageSubscription.aspx

Is it possible to add SPSubscriptionProperties.aspx properties like - CC, report format and etc -> in ManageSubscription.aspx view?
1
vote
0answers
16 views

Report Server URL on SharePoint Integrated Mode

I have a SSRS 2008R2 integrated mode SharePoint 2010 environment and this environment is not working fine. So I want to reach the report server on that farm. On native mode, http://www.example.com/...
0
votes
0answers
56 views

Object reference not set to an instance of an object. Error

I'm getting this error when I'm trying to reach sites. Also I have this error on logs. Is there any opinion? UserProfileApplicationProxy.InitializePropertyCache: System.Configuration....
1
vote
0answers
22 views

Client cannot open report builder on reports on other subsites

We have SSRS that is Sharepoint integrated. We have report builder downloadable from our sharepoint server as well when users modify rdl reports. We have one client that is able to open reports in ...
0
votes
2answers
463 views

Is it possible to connect 2016 Report Builder to a SharePoint Online List

I would like to connect 2016 Report Builder to a SharePoint Online list. Is this possible? I've seen examples with Report Builder being connected to SharePoint on premise but not to SharePoint Online. ...
1
vote
2answers
145 views

Unable to show SSRS Report from a nother page using Report Viewer WebPart

I am using the Report Viewer WebPart to show a .rdl report from another page but the error saying that it cannot find the report. Error: Microsoft.ReportingServices.Diagnostics.Utilities....
0
votes
0answers
72 views

Sharepoint Data source type is missing in visual stuido 2017

I am using Visual Studio 2017 enterprise edition to create a RDLC report. First of all my visual studio did not come with RDLC pre-installed, so I have successfully installed it via nuget package. ...
2
votes
2answers
78 views

SharePoint 2013 / SQL Server 2012 Report Server Integration Feature Disappeared / Missing

Report Server Integration Feature has disappeared from Site Collection Features (Site - Site Settings - Site collection features under Site Collection Administration). Report Builder Report, Report ...
0
votes
0answers
66 views

Retrieve SharePoint rsds Connection String Information

I have SharePoint document library titled "Data Source" which consists of reporting data source files. Below images shows list of rsds file with associated connection string on click of each rsds file....
0
votes
0answers
17 views

What account(s) to use for SPD workflow that changes item approval status?

I have a custom SPD Workflow (2010 workflow on 2013) which mimics the OOTB Publishing Approval Workflow. The only difference is that if the files are in a certain subfolder in the library, the file ...
0
votes
0answers
38 views

CAML Query to Limit Lookup Field

I am creating an SSRS report based on a SharePoint 2016 list using the following query: <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/...
-1
votes
1answer
109 views

Dynamically pass sharepoint list name in ssrs report

I want to pass Dynamic SharePoint list name. I want to give access to users to provide the parameter value in ssrs report for SharePoint list and get the data. So, to dynamically pass the data i am ...
1
vote
2answers
308 views

Install Reporting Service in SharePoint 2016 is not supports SSRS 2014

we are using SharePoint Server 2016 Farm with 2-WFE,2-Application with Search, and a Database Server (SQL Server 2014). Now I want to Integrate SSRS to SharePoint. Now, MSDN says that SharePoint ...
1
vote
1answer
64 views

SSRS Report From SharePoint 2013 List

I've created a SSRS report from a SharePoint list. The list has about 65000 records. When I ran this report, all SharePoint web applications and all sites stuck on loading. After report finished ...
2
votes
1answer
134 views

How to have SSRS subscription delivery trigger workflow in a document library

I have SSRS running in SharePoint Integrated Mode in SharePoint 2013. I have a subscription on a report set up to deliver to a document library that has a publishing approval workflow (SharePoint 2010 ...
1
vote
1answer
33 views

whats difference between xml query with sql query?

I need to know advantages and disadvantages XML query and SQL query for SharePoint report.when we have large data which one has best performance? which one is faster?
1
vote
0answers
62 views

Failing sending mail: Report Server has encountered a SharePoint error.Mail will not be resent

I am using SharePoint to schedule subscriptions for SSRS reports. I have one report that has roughly 40 subscriptions and has been working perfectly for 6 months up until last week. Last week all of ...
1
vote
0answers
37 views

Some pages in SharePoint not accessible with FQDN

My customer's network is designed to enforce business users to only access web applications with FQDN. Business users can only access SharePoint site with FQDN example: http://abc-intranet.abc.local ...
1
vote
1answer
50 views

Report Builder 2016 Problem

I'm using Reporting Service with SharePoint Mode (Not native mode). I've a document library with folders, subfolders and files. But the Report Builder can not retrieve files and subfolder, it gets ...
0
votes
2answers
1k views

How to show SSRS 2016 report in iFrame at another SharePoint farm?

I'm trying to show an SharePoint 2016 integrated mode SSRS 2016 report in a SharePoint 2013 farm but I'm getting this error. These farms are at same domain. I don't want to allow iFrames at ...
1
vote
3answers
401 views

Cannot embed SSRS 2016 on SharePoint Online and Onprem WSS 3.0 and 2010

Normally we can embed SSRS 2012 or later reports from SharePoint WSS 3.0 to 2013 Site but now when we tried the new SSRS 2016 it displays below error even in SharePoint Online. Is there any way we ...
0
votes
1answer
522 views

“Report Server Central Administration Feature” is missing in Central Administration Site collection features

I am using SharePoint Server 2016 and SQL Server 2016 SP1. I installed "Reporting Services - SharePoint" feature on the Application server(Custom Role) and "Reporting Services Add-in for SharePoint ...
1
vote
0answers
69 views

SSRS hosted on SharePoint 2013 Export to Excel unable to open the exported Excel file

We have a SSRS Report hosted on SharePoint 2013. The problem is when we export it in Excel and try to open it Excel gives us an Error that "Excel found unreadable content in this file". Strange part ...
1
vote
1answer
38 views

Set Default Report Library to save report in Report Builder

I would like to set default library in Report Builder to save report(.rdl) without users selecting Report library to save report. Is this possible ? Please advise. Things i have tried, Having library ...
1
vote
1answer
151 views

Cannot register SQL Reporting Service in SharePoint 2016

I am using SharePoint 2016 farm with min roles (Front End with Distributed cache and Application with Search). I am using SQL Server 2014 SP 2 on the database Server. I ran below commands to ...
2
votes
1answer
20 views

SharePoint using SQL Report Server Manager outside of SharePoint farm

Can we have SharePoint use SQL Report Server which is already set up outside of SharePoint Farm? The SQL Server which would be having this SQL Report Server Manager will not have Configuration ...
0
votes
1answer
198 views

Error while creating Report Data Source and SSRS Report in SharePoint 2016

I have a SharePoint Server 2016 Enterprise Edition farm with SQL Server 2016 Standard edition as the DB server. I successfully installed the SQL Server 2016 Reporting Service Add-in for SharePoint ...
2
votes
1answer
298 views

Error occurred during report processing. Report server is unable to access encrypted data. Apply backup key or delete all encrypted content

I have migrated the SQL Server Reporting Sevices from SharePoint 2010 to SharePoint 2013. I followed Migrating SharePoint 2010 Reporting Services To SharePoint 2013 to migrate SQL Server Reporting ...
1
vote
1answer
325 views

SharePoint 2016 SOAP Query Not Returning ViewFields

I'm using SQL Server Report Builder to migrate an old report from MOSS 2007 to SharePoint Server 2016, and, in this report there are 3 data sets. I've changed out the view GUIDs to the new values they ...
2
votes
1answer
939 views

SharePoint report viewer error There are no addresses available for this application

i have single server (sql 2016 +all SharePoint 2016 role) when i click on a report to run (uploaded rdl file) SharePoint give me error There are no addresses available for this application and in ...
1
vote
1answer
81 views

How do I prevent a publishing workflow from running in certain subfolders in a library?

I have a library in SharePoint set up with a basic "publishing workflow" so the folder owner has to approve new documents that are added. This works fine. I'm also running SSRS in SharePoint ...
0
votes
1answer
289 views

How to open SSRS report anonymously in sharepoint integrated mode?

We have deployed one ssrs report on sharepoint server. For accessing that report anonymously, we have configured anonymous access on reports document library. But the following error is showing on ...
3
votes
2answers
4k views

How can I embed SSRS reports in SharePoint online?

Any suggestions on same would be highly appreciated.
1
vote
1answer
155 views

PowerPivot Data Refresh Error: Please try again in a little while

I scheduled data refresh on a power pivot but I'm getting this error. Here is ULS logs. How can I solve this issue? Any suggestion? What does "Please try again in a little while" means? :/ ...
0
votes
1answer
62 views

How can I use a multichoice managed metadata field as a parameter filter in SSRS report?

I have a SharePoint list and one of the columns is a Managed Metadata field for users to tag items with one or more tags. The users want a report that will allow them to filter by this keyword column. ...
2
votes
0answers
177 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
2answers
100 views

View or log to see who has run a report

The client has SP 2013 with SSRS reporting integrated. I have built some reports for them and they work great. On one of the reports, the client would like to be able to see who has run the report as ...
2
votes
1answer
287 views

Installing SQL Server 2014 RS Add-ins for SharePoint 2013 in Multiple Server Farms

I am currently working with a multiple-servers SharePoint Farm (1 Database server, 1 Web Front End server, and 1 Application Server), and I have already installed SQL Server 2014 Reporting Services ...
4
votes
1answer
319 views

How to Use SSRS to get all items inside sharepoint document library

I want to create a SSRS report of the item sitting inside a SharePoint document library. Inside my SharePoint document library, we have multiple folders where the document is saved. When I run SSRS ...
0
votes
1answer
123 views

AutoSpInstaller warning during SP2013 Install

I am installing a SP2013 Dev instance. I have SQL 2012 and SP2013 on the same machine. I don't have reporting services installed but I did add the SharePoint reports service option during SQL ...
4
votes
2answers
222 views

Reporting Services on SharePoint errror

We are using SharePoint 2013 Enterprise with SQL Server 2012. We have recently applied patches to SharePoint and SQL Server (SQL Service Pack 3). I'm not entirely sure if the updates broke ...
1
vote
0answers
464 views

ReportingService Databases running in compatibility range, upgrade recommended

We are running a stand alone SharePoint 2013 install. I have gotten the following message regarding various databases within the install on different occasions and I am always able to resolve them ...
2
votes
1answer
37 views

report user password (in the sharepoint intergrated mode) must be changed when the the AD user password changed

I am administrating my company's sharepoint server 2016 and I have developed some reports for some sharepoint website, if I want to publish these reports to sharepoint website, I have to key in my ...