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
2 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
0answers
29 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
15 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 ...
1
vote
3answers
5k 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 ...
1
vote
1answer
594 views

using SSRS to generate a report based on a Calendar in Sharepoint 2013

We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
2
votes
1answer
18 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 ...
1
vote
1answer
897 views

SP2016, SSRS - The connection string is not valid

I installed SSRS 2016 instance on the SP2016 server. Trying to create a Data Source (from the SharePoint page or Report Builder app) by selecting type: Microsoft SharePoint List and connection string ...
0
votes
1answer
651 views

SharePoint image list item how to display in SSRS report using Report Builder?

Creating SSRS report using SharePoint site as a data source how to display SharePoint list image item URL in SSRS Report display image.
2
votes
0answers
18 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
2answers
649 views

Configure SSRS for SharePoint 2013 with PowerShell

So I have to configure SSRS on my box and i tried to search feature name "Report Server Integration Feature" and could not found and my search lead to below two post. Installing Reporting Services In ...
0
votes
1answer
635 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
1answer
629 views

Adding Report Viewer Web Part to Default page programmatically

I am new to Sharepoint. I need to know the best way to add a ReportViewWebPart to a page through C# code behind. I have tried accessing the web part from WebPartCatalog. It leads me to the ...
0
votes
1answer
14 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
1answer
743 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
1answer
20 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
712 views

Windows Authentication with SSRS Subscriptions

We're starting to develop some SSRS reports using SSRS in SharePoint integrated mode. Environment consists of SharePoint 2013 with SQL Server 2012. Things are working great, except for using ...
0
votes
1answer
609 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
2
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
947 views

SharePoint error Report Server has encountered

I am trying to configure SSRS 2008 R2 using SharePoint Integration mode on SharePoint 2010 server, I have followed some blogs including MSDN to configure SSRS in Integrated mode. But once I click on ...
0
votes
1answer
1k views

SSRS add 2 date time Fields

I have 2 datetime Fields in SSRS and I am summing both of them like: =TimeSpan.FromTicks(sum(Fields!Logout_Time.Value-Fields!Login_Time.Value)). The output is correct but is in hh:mm:ss format, I ...
1
vote
1answer
1k 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 ...
0
votes
0answers
44 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 ...
1
vote
1answer
2k views

How to get current Login User Name from sharepoint in SSRS report instead of the SSRS report user name show the serviceAccount name

Currently when run SSRS in development, the user name is show correctly. But, once deploy it to sharepoint, the user name become static which means it keep display service Account name and not the ...
8
votes
4answers
7k views

Report Viewer Web Part Alternatives in SP2013

We have a need to upgrade from SP2010+PWA to SP2013+PWA. Our database server will be SQL Server 2008 R2. According to Technet, the SQL 2008 R2 Reporting Services add-in for SharePoint isn't ...
1
vote
2answers
2k views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
3
votes
1answer
2k views

SharePoint 2013 SQL Reporting Services 2014 500 error

We have a 3 server farm: 2 WFE, 1 App. SharePoint Enterprise license The App server has the SQL 2014 reporting services integrated SharePoint with the add in installed. The WFEs all have the Add in ...
3
votes
1answer
2k 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 ...
3
votes
1answer
4k views

SSRS data source: Can't use stored Windows credentials, “SharePoint does not use Windows authentication”

I'm running a single-server deployment of SharePoint 2013 and SQL Server 2014 with SSRS in SharePoint-integrated mode. When trying to set up a subscription for a new report, I get a popup saying: ...
0
votes
1answer
604 views

SSRS bar-chart do not show the x-axis name when value is zero

We have a Dashboard implemented by SSRS in SharePoint 2010 and data source is a SharePoint list. We have a bar table in which the x-axis is month but when data is zero it doesn't show the month name ...
0
votes
1answer
36 views

Show MS Excel sheet in SharePoint list

I have an Excel document where we track team projects' travel periods. Preview Info: Users are ordered in 1st column. Bellow is Projects coloring legend. Team members are on site like User1, 20.11....
0
votes
0answers
20 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
180 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 ...
0
votes
1answer
801 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
1
vote
1answer
41 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
32 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
51 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
16 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
21 views

ReportServer -> ManageSubscription.aspx

Is it possible to add SPSubscriptionProperties.aspx properties like - CC, report format and etc -> in ManageSubscription.aspx view?
0
votes
2answers
4k views

How can I have SSRS report subscriptions go to a SharePoint folder when not in integrated mode?

I am using SSRS with SQL 2012, and have SharePoint 2010. SSRS is not in SP integrated mode. I would like to create a subscription to send reports to a SharePoint folder. When I use the web path (http:...
0
votes
2answers
685 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. ...
3
votes
3answers
13k views

SSRS reporting in SharePoint Online

Can we Create SSRS Reports in SharePoint Online? https://community.office365.com/en-us/f/154/t/239208 This article states that we cannot, but the information is old, What's the latest on this?
2
votes
0answers
200 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
3answers
490 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 ...
1
vote
2answers
411 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
2answers
217 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....
1
vote
0answers
20 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
76 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
32 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 ...