Stack Exchange Network

Stack Exchange network consists of 174 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.

2
votes
1answer
12 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
13 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
12 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
45 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
18 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
255 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
86 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
51 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. ...
2
votes
2answers
52 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
55 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....
0
votes
0answers
13 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 ...
0
votes
0answers
31 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/...
-1
votes
1answer
92 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
218 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
52 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
116 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
33 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?
0
votes
0answers
11 views

On a standalolne SharePoint 2013 can I still run a SSRS on it?

On a test environment VM, SP 2013 is installed on a standalone environment. Under Apps, I see a MS SQL Server 2008 R2 header and these 4 items under it: - Import and Export Data (64-bit) - SQL Server ...
0
votes
0answers
94 views

SharePoint XML Visualization

I have a SharePoint document library with about 40 XML files of the same datatype. I would like to visualize the contained data within SharePoint. The requirement is that I click on a button or link ...
1
vote
0answers
51 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
33 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
47 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
1k 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 ...
0
votes
0answers
10 views

Add an Additional Report Server to a SP2010 farm

Our firm is still use SP2010. Our production farm have 2 WFE and 2 APP. One of our APP server (APP01) have SSRS (SQL2008 R2) installed and running. We planned to add an additional SSRS server using ...
1
vote
3answers
323 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
415 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
60 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
38 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
125 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
17 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
170 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
232 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
276 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 ...
2
votes
1answer
690 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
65 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
232 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
3k views

How can I embed SSRS reports in SharePoint online?

Any suggestions on same would be highly appreciated.
1
vote
1answer
129 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
53 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
148 views

SSRS Report in SharePoint Online

Can we use the SSRS report in SharePoint online using SharePoint Provider Hosted App?
1
vote
2answers
78 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
244 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 ...
4
votes
1answer
268 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 ...
0
votes
1answer
115 views

AutoSpInstaller warning during SP2013 Install

I am installing a SP2013 Dev instance. I have SQL 2012 and SP2013 on the same machine. I don't have reporting services installed but I did add the SharePoint reports service option during SQL ...
4
votes
2answers
194 views

Reporting Services on SharePoint errror

We are using SharePoint 2013 Enterprise with SQL Server 2012. We have recently applied patches to SharePoint and SQL Server (SQL Service Pack 3). I'm not entirely sure if the updates broke ...
1
vote
0answers
420 views

ReportingService Databases running in compatibility range, upgrade recommended

We are running a stand alone SharePoint 2013 install. I have gotten the following message regarding various databases within the install on different occasions and I am always able to resolve them ...
2
votes
1answer
37 views

report user password (in the sharepoint intergrated mode) must be changed when the the AD user password changed

I am administrating my company's sharepoint server 2016 and I have developed some reports for some sharepoint website, if I want to publish these reports to sharepoint website, I have to key in my ...
3
votes
1answer
81 views

SSRS Install SharePoint 2013

I am installing SSRS on my SP 2013 farm. 2 web front ends and 2 app servers. I am confused as to what I need to install on what and if I need to install it on all servers. Run in SharePoint mode. Its ...
4
votes
2answers
525 views

Report builder Lookup function only match less then half of records

I am using SP2010 and SRSS is installed on the farm. I built a report using report builder 3.0. In my report, I have several datasets. Dataset A returns about 10,000 records and Dataset B 150,000 ...
0
votes
1answer
33 views

what is the better way of develoment report in SharePoint 2013

I having a problem with a development the a report. Currently this report are development with Open XML but it is very complicated and demand much time. I need know if exists a way diferent for ...