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
1answer
600 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
894 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
998 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
30 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
595 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
1answer
854 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
630 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.
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
625 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
2answers
641 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
715 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
696 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 ...
1
vote
1answer
110 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 ...
0
votes
1answer
798 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
1
vote
1answer
37 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
27 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
2answers
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
0answers
47 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
19 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
579 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
189 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
3answers
445 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
365 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
181 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
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
63 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
28 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
3answers
2k views

Reports based on Lists for SharePoint online

One of our clients use SharePoint Online & uses a simple lists-based case management system. They want to receive weekly report in email based on the data in lists, preferably using configuration (...
3
votes
0answers
233 views

Removing leading spaces/newlines left from unchecked Multi-Select box

I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line ...
2
votes
2answers
84 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 ...
2
votes
1answer
150 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 ...
0
votes
1answer
573 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 ...
4
votes
1answer
356 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 ...
-1
votes
1answer
116 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 ...
0
votes
0answers
2k views

PartialChain: A certificate chain could not be built to a trusted root authority error in performancepoint dashboard designer

when access PerformancePoint dashboard designer I got below error message in event viewer and unable to connect to SharePoint site collection. An operation failed because the following certificate ...
1
vote
1answer
68 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 ...