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
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 ...
6
votes
2answers
3k views

Performance Issues using SQL Server Reporting Services in SharePoint Integrated Mode [closed]

Does anyone have experience with the following issue? Are there any known workarounds? Official MS Statement: General overhead performance differences when you view reports in SharePoint integrated ...
6
votes
1answer
671 views

Using SharePoint UserAccountDirectoryPath with SSRS

I've got a SharePoint 2010 Enterprise multi-tenant setup integrated with a new SSRS 2008 R2 instance in SharePoint-Integrated mode and have FINALLY managed to get everything working. However, there ...
5
votes
2answers
3k views

Missing SSRS Web Services Directory

So the SQL Reporting Services Service Application is running, but from Central Administration, when I click on the service, then click "System Settings", it returns an error. Digging through ...
5
votes
3answers
6k views

Not able to deploy report to SharePoint 2010 in integrated mode

I am running SharePoint 2010 Enterprise with 2 servers in the farm (SharePoint and db server). They are both running windows server 2008 R2 and the SQL Server is also R2. I have installed the ...
4
votes
2answers
435 views

SharePoint SQL Services Reporting Services Report Viewer - print button option not available in Chrome Browser

I have a SharePoint 2013 site and configured SQL Reporting Services in SharePoint Integrated mode to work with SharePoint . it works fine without any issues . but the print option is not available in ...
4
votes
1answer
410 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 ...
4
votes
2answers
790 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 ...
4
votes
1answer
2k views

Connecting Web Parts across pages in SharePoint Designer

I am trying to connect some web parts across different pages (in the same site) and the behavior I am seeing doesn't make sense to me. I think I am missing something in my understanding. I am using ...
4
votes
1answer
516 views

Sharepoint 2013 - Analytics - Popularity Trends

We have been using some of the OOTB analytics such as Popularity Trends and reports. Up till a month ago we were receiving regular reliable data. It suddenly stopped. Where is my first point of call ...
4
votes
2answers
128 views

How to check SharePoint Installed in “SharePoint integration Mode”

Is Reporting Service Integration Mode available in the server farm or not. How to check? Environment: SharePoint 2013 Enterprice SQL Server 2008 R2
4
votes
2answers
258 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 ...
4
votes
3answers
711 views

Import-SPWeb - Feature 'ReportServer' is deployed but its version '14.0.0.0' is below the miniumum required version of '15.0.0.0'

I am trying to import a site from my production to test environment but am getting the error below. I've run psconfig but this hasn't upgraded the feature. Any advice on what I need to do to upgrade ...
4
votes
1answer
400 views

ows_MetaInfo field including carriage returns

I have an InfoPath 2010 form promoting fields to SP 2010. Using SSRS 2008 R2, I'm pulling those fields into a report to report off of. I'm finding that some fields in the ows_MetaInfo blob have a ...
4
votes
5answers
3k views

Report Server Sharepoint 2013 Errors

We have Report server services in SharePoint Integrated mode and it was working up until last week but now when ever we are trying to open a report or data source we are getting the below error ...
4
votes
1answer
3k views

Reporting Services, get data from any Sharepoint List

I am trying to build an SSRS (2008R2) report based on a Sharepoint (2010) List. The main problem is that the List on which the report will run has to be a report parameter.I know what the list ...
4
votes
1answer
2k views

SSRS Managing parameters default value different behavior 2007 to 2010

Issue: After uploading a SSRS 2008 R2 RDL to SharePoint 2010, a listing of possible values of a query based parameter is not populated into a dropdown list next to the “use this value” radio button ...
4
votes
2answers
7k views

Publish SSRS report to SharePoint document library

This question is a copy of my question on stack overflow. Didnt know this forum existed until now. I cannot find a way to publish/deploy my reports to a SharePoint document library. I have exhausted ...
3
votes
1answer
39k views

Generate report from sharepoint 2010 list

I need to generate a report from sharepoint 2010 list using any good and easy method. Any suggestions along with the procedure are welcome.
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?
3
votes
2answers
6k views

How can I embed SSRS reports in SharePoint online?

Any suggestions on same would be highly appreciated.
3
votes
1answer
104 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 ...
3
votes
5answers
4k views

SharePoint 2013 Standalone VM for Development good enough?

I'm building a VM for SP 2013 development. Will be developing Solutions, WebParts, Custom forms, Dataviews, Business Data Connectivity, Custom Fields, inline Jquery, SSRS reports for deployment into ...
3
votes
1answer
1k views

SSRS SharePoint Integration on 2 Computer Deployment

I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this: My setup consists of a ...
3
votes
1answer
11k views

Programmatically set data source link for SSRS Report files

I have a scenario where I export/import a site collection with the Content Deployment Wizard. The problem is that all Reporting Services (SQL Server 2008 R2) reports (all located in the same document ...
3
votes
1answer
50 views

SQL Data into SP Online and access on mobile

As my title states, I'm looking for some help/resources on how I can pull data from SQL server and display it on SP Online. The added kicker is, we'd like this data to be view-able on mobile devices. ...
3
votes
1answer
900 views

Retrieving recurrent event from a SharePoint Calendar using a CAML query in Reporting Services

I'm building a report using SSRS, for a report ran within a SharePoint site (integrated mode). I'm using the "SharePoint List" as the data source (not a web service). My dataset retrieves events from ...
3
votes
1answer
543 views

List of all subscription

How to check all report's subscriptions on Sharepoint 2010? I know only how to check subsciption on specific report:
3
votes
1answer
2k views

Connect all SSRS Reports in SharePoint library to DataSource using Powershell

We are migrating MOSS to SP2010 and have a library with hundreds of SSRS reports that use a Shared DataSource (in SharePoint Integrated mode.) Since the ReportServer database location has also ...
3
votes
2answers
59 views

Installing SSRS on SharePoint 2013

I have a 3 tier farm with Central Admin on the wfe (HA - everthing x2). I'm looking at the best way to install SSRS. What parts need to be installed where. From what I have worked out Reporting ...
3
votes
1answer
462 views

Date Format On SharePoint 2013 Reports

I have Reporting Services reports and Excel Services files published in Sharepoint 2013. The date format of the regional configuration has been changed to Colombia by Date format DD / MM / YYYY. ...
3
votes
1answer
283 views

What to do when SharePoint Lists and SSRS isn't enough?

I've developed a complicated InfoPath web form for reporting outages. This system will be maintained by someone with little technical skill, so in a lot of places the form populates its dropdowns from ...
3
votes
1answer
817 views

Why are web part connections in a template breaking?

We have a SharePoint site that we created based on a blank site template. We add lists, pages, webparts (including some connected web parts) and then save this site as a template (.wsp file). We ...
3
votes
1answer
304 views

Infopath, sharepoint list and SSRS

I have a challenging question from my manager. In InfoPath/SharePoint, he is trying to capture the time spent by his team on various activities via SharePoint. Using an infopath form, each week his ...
3
votes
1answer
2k views

Grant Database Access for Reporting Services: A connection to the computer cannot be established

On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting ...
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

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
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 ...
3
votes
1answer
3k views

Is it possible to view/edit SSRS datasets from sharepoint?

I have a bunch of shared datasets on my old report server and I want to copy them to a SharePoint Document Library. I'm running SSRS integrated mode in SharePoint 2013 and I've already created my ...
2
votes
2answers
1k views

Installing SSRS on the Sharepoint Box as opposed to the SQL Box?

We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases. We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
2
votes
2answers
3k views

Powershell Script to find URL's on content pages, lists and libraries that point to a specific url in SharePoint 2010

I'm trying to search through SharePoint 2010 to find links that point to a broken URL using PowerShell. Is there an easier way?
2
votes
1answer
673 views

Conditional subtraction

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6. My first field is ...
2
votes
3answers
2k views

Two different versions of RSViewerPage.aspx on same farm?

I have a SharePoint 2013 farm with SSRS. On this farm, I have two web-apps (A and B). When we created web-app "A", we made some branding customizations to the RSViewerPage.aspx page. The problem is ...
2
votes
1answer
9k views

The permissions granted to user 'MYDOMAIN\ryanhayes' are insufficient for performing this operation. (rsAccessDenied)

I'm getting several users getting access denied for some SSRS reports that are in a reports directory in SharePoint 2010. I have a single sharepoint group with all users in it so all users have the ...
2
votes
3answers
2k views

Can I download an rdl file from a SharePoint list?

I wonder if I can download an RDL file that was uploaded to a Sharepoint list. I want to upload it to our QA server, but I don't seem to find it anywhere since it was done by the developer before me.
2
votes
1answer
6k views

SSRS Parameters passed through URL not refreshed on Web Part Page

My working environment is SSRS 2008 and SharePoint 2010.I have a report with parameters running in SP 2010. I call my report page in SP 2010 from a page with all the parameters in query string. On the ...
2
votes
2answers
52 views

Where to Install Reporting Service

To use Reporting Service integrated with SharePoint, where to install Reporting Service? Suppose that SharePoint env. has two physcical servers: application and database server. Should reporting ...
2
votes
2answers
32k views

Tracking and reporting in sharepoint 2010 ? user accessing what kind of data ?

I want to track How many times a particular user has accessed what document in document library?and i need to show this in a report format. Also, i need to check what are links being accessed in the ...
2
votes
1answer
17 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: ...