Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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.

Filter by
Sorted by
Tagged with
0
votes
1answer
6 views

SharePoint workflow tasks list migration to SharePoint online

In our SharePoint 2013 on-premise environment, we have Approval workflows. Using SSRS reports, we display a report, who approved those tasks in a Grid view. Now we are migrating our complete on-...
0
votes
0answers
13 views

CAML Query all lists with same name under a site collection

We are using SP2016 on-premise. We have a site collection with over 50 subsites under it. All the subsites are created with same Site template. Therefore all of them have a list called "ContactInfo".(...
0
votes
1answer
98 views

SSRS 2016 native mode fail to connect SharePoint list datasource

We are using SP2016 with SQL 2016 standard (13.0.5026.0 SQL Server 2016 Service Pack 2 (SP2)). SSRS feature is enabled in SQL server and service started. I am able to browse the SSRS portal with http:/...
0
votes
1answer
26 views

Install SSRS SP mode after SP2016 is setup not working

We are using SP2016 on-premise with SQL 2016 enterprise edition. After everything is setup we realize we also require SQL Reporting service enable on the farm. Hence, on our application server we ...
2
votes
1answer
23 views

O365 Sharepoint integrated with on prem SSRS

I have been asked to look for products that help in the connectivity/ integration of our executive O365.SharePoint portal and our SSRS on prem infrastructure. Looking for products to solve that I ...
2
votes
0answers
25 views

Configure SSRS Report Data Source Link programmatically via PowerShell or Console Application

I require to set the data source link of SSRS reports. The SSRS Reports and the Data Source reside in a document library. I want to set the shared data source for all the SSRS reports of the ...
0
votes
1answer
24 views

Unable to View SSRS Report after Deployment

Apologies for the long post: I have a SharePoint 2013 server with Reporting Services 2014 installed in SharePoint Integrated mode, plus a document library with Reporting Services content types enabled....
0
votes
1answer
28 views

SSRS 2016 Report Builder connection to Sharepoint Online List

I was able to connect to my on prem SharePoint 2013 server list, but since we migrated to SharePoint online i no longer get it to connect. I am getting access is denied error. Account i am using has ...
0
votes
0answers
66 views

How to render/embed SSRS report in SharePoint 2019?

I am working with SharePoint on premises 2019. There are several SSRS reports developed and I would like to render them on a either classic or modern page. Can someone help me with the best way to ...
0
votes
0answers
22 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
286 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
71 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
45 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
34 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
58 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
18 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
23 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
25 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
89 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....
2
votes
0answers
36 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
805 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
270 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....
2
votes
2answers
99 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 ...
-1
votes
1answer
131 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
484 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
81 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
180 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
34 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
81 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
48 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
51 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
2k 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
529 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
693 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
73 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
40 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
186 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
28 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
231 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
381 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
405 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 ...
3
votes
1answer
1k 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
104 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
400 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
6k views

How can I embed SSRS reports in SharePoint online?

Any suggestions on same would be highly appreciated.
1
vote
1answer
193 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
71 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
206 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
2answers
181 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
357 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 ...