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
1answer
591 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
826 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
619 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
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
623 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
635 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
688 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
687 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
65 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
796 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
2
votes
1answer
945 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
833 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 ...
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
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
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' ...
0
votes
1answer
983 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 ...
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
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 ...
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:...
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
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: ...
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 ...
0
votes
2answers
467 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
177 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
3answers
403 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
311 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
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
67 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....
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
57 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
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
232 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
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
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. ...
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 ...
2
votes
1answer
136 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
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/...
0
votes
1answer
523 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
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 ...
-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 ...
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 ...