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
0answers
11 views

Sharepoint SSRS data driven subscription message body

when you create a data driven subscription in SSRS, on the Data-Driven Subscription Wizard, you can specify the Comment field to be a sql variable from the output of the database query that ...
0
votes
1answer
66 views

Two of the same Service instances and stuck on starting/stopping - How to remove one Instance - OnPrem SharePoint 2016

So we recently updated our SharePoint Farm (6 Servers [2 Web, 2 App, 2 Search]). Everything is working fine beside, SQL Server Repoing Service. We had some problems with getting the settings correct ...
0
votes
1answer
45 views

RDL (SSRS) in SharePoint online

Is there a way to embed and show the SSRS reports in SharePoint online? I have read in few blogs dated 3 years back, stating that SPO does not support SSRS Is there any change to that? Are there any ...
0
votes
1answer
39 views

Does SharePoint Online have plugin tools for SSRS (SQL Server Reporting Services) or is there an API for accessing and writing reports?

I've been looking around for a while and haven't found anything yet. Any help is much appreciated. Thanks.
0
votes
1answer
56 views

Report viewer web part is not loading data in report viewer in SharePoint 2019

Report viewer web part is not loading data in report viewer. Here is the error I found in browser console: "Sys.ArgumentNullException: Value cannot be null. Parameter name: id"
0
votes
1answer
31 views

SSRS for SharePoint - Configuration Issues

My team has installed SSRS in SharePoint mode with the add-in successfully. I'm seeing it as an active service on my SharePoint instance without any issues. It seems to be working fine server-side. ...
0
votes
1answer
145 views

SharePoint SSRS integrated mode

I look after a SP Farm that runs SSRS integrated and every now and then some of the scheduled SSRS subscriptions fail to run (with an error message). Recently I have seen scheduled subscription not ...
0
votes
1answer
13 views

Reporting options for 2016 - opinions?

My organization is currently using InfoPath to enter financial data into SharePoint 2010 libraries/lists. Then, this information is utilizing Crystal Reports to then aggregate the information in a ...
0
votes
1answer
96 views

ReportServerCentralAdmin Missing Feature

I have SharePoint 2013 On-Prem with a single wfe, a single app server and a dedicated SSRS application Server running SSRS in integrated mode. The DB running SSRS is SQLServer2016 SP2. This server was ...
0
votes
2answers
302 views

SharePoint workflow History 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
1answer
800 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
187 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
75 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
172 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
43 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....
1
vote
1answer
1k 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 ...
1
vote
1answer
1k 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
78 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
65 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 ...
1
vote
0answers
120 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
29 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: ...
1
vote
0answers
41 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
184 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
95 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
1k 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
731 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
186 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
175 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
672 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
106 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
383 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
47 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
145 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
76 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
58 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
3k 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
893 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
1k 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
104 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
41 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
354 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
42 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
292 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
650 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
484 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
2k 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
154 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
587 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
11k views

How can I embed SSRS reports in SharePoint online?

Any suggestions on same would be highly appreciated.
1
vote
1answer
288 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? :/ ...

1
2 3 4 5
8