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 ...

learn more… | top users | synonyms (1)

0
votes
1answer
24 views

How to write Query in SQL Reporting Services query designer to get current sharepoint Login user?

I Want to create a report using SQL Server Reporting Services. In Visual Studio I created a report to get SharePoint data from a list. I want to get the current logged in user in SharePoint and check ...
0
votes
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
3answers
6k 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 ...
4
votes
1answer
2k 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 ...
0
votes
0answers
24 views

SQL Server Reporting Services in SharePoint 2013

Please any one can help me in the following problem: When i try to working with SQL Server Reporting Service in SharePoint site the following issue faced me: Notes: All configuration steps 100% ...
0
votes
3answers
730 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 (...
2
votes
2answers
74 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?
0
votes
1answer
41 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
0answers
38 views

Sharepoint Server 2013: SSRS Reports always keep refreshing on iphone

Scenario: I have added report viewer web part on page and displaying RDL report. Report working fine on desktop and on android devices as well as on ipad tablets also. Problem: Whenever i open ...
0
votes
1answer
856 views

SharePoint 2013 Workflow Reports

I created a workflow in SharePoint 2013 and would like to start collecting information on how long it takes for each task to be completed. I know of ways to build this type of data into the workflow, ...
0
votes
0answers
17 views

Can no longer Manage subscriptions for reports in SharePoint

We are running SharePoint 2013 with SQL Server Reporting in integrated mode. Recently we were having issues with our search service running so we ran the Psconfig -cmd secureresources command in ...
1
vote
1answer
734 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 ...
1
vote
1answer
23 views

Report Server Integrated 401 unauthorised error

I have set up Report Server in Integrated mode, using the Service Account as Network Service. On the report server I can log onto the web service using my credentials just fine. However when I try and ...
0
votes
3answers
4k views

SSRS Dataset valid, but data does not show up in generated reports

I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder. When I hit "run query" on my dataset in the query designer, I ...
2
votes
2answers
334 views

SSRS Report Content types available in Central Administration but not in Sharepoint Site

I am trying to get Sql Reporting Service running with Sharepoint server, and I have a two computer deployment, like example 2 on this page: http://msdn.microsoft.com/en-us/library/bb677365.aspx ...
1
vote
2answers
17 views

Rendering SSRS Report located in _layouts folder?

Does anyone have any knowledge on how to load an SSRS report located in the _layouts folder? I am able to load it if it's in a document library and here is the URL that it has: http://mysite/...
0
votes
0answers
125 views

SSRS integrated Sharepoint Actions Menu Data Fetch Error

In our environment, we have SSRS 2012 integrated with SharePoint 2013. One of our report we get error when we click on Actions menu An error has occured with the data fetch. Please refresh the ...
0
votes
0answers
17 views

SharePoint Subscriptions - Stored credentials issue

When I was trying to subscribe a report I was getting the following error : Subscriptions cannot be created because credentials used to run this report are not stored. Provide credentials for the ...
0
votes
0answers
20 views

Can SharePoint perform full-text indexing on SSRS reports?

We have installed SSRS on SP2013 on-premise. The report files (*.rdl) can be opened by users but the content are not being indexed. May I know is it possible to setup indexing on SSRS content? P.S. ...
2
votes
1answer
135 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
44 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
0answers
10 views

SharePoint 2010 Report Server URL not liking my credentials

So I have recently set up a report server, in the configuration management I have added my credentials in use another account but when I go to the web service URL I get prompted for my credentials 3 ...
0
votes
3answers
34 views

Auto updating chart from a list in SharePoint 2010

I have a SharePoint list and I want to show it in a tabular table in home page of SharePoint and data be online in which by changing data in the list the data of the table change automatically. What ...
0
votes
0answers
55 views

SharePoint 2010 and Reporting Services 2008 in IE 11 problems

we are using Reporting Services in integrated mode in a SharePoint 2010 environment. We are facing issues when trying to view reports in IE 11 with compatibility mode disabled. The loading gif of the ...
0
votes
1answer
58 views

SSRS How can I create a Parameter to Filter on a SharePoint Multichoice Column

I am using a SharePoint list as my data source for an SSRS report. I have a multi-choice column named "Office". When a task applies to an office we check the box. Most of the time a task applies to ...
0
votes
0answers
15 views

Sys.WebForms.PageRequestManagerParserErrorException: The message received from the serve

I deployed a PerformancePoint dashboard to a SharePoint site , this dashboard has SSRS Report and Performance Point Filter , When we browse this site from internet i saw below error; for internet ...
1
vote
1answer
21 views

“RS Add-In for SharePoint” Server Consistency

I just noticed on a SP2010 Farm that I am working on some servers have the "Microsoft SQL Server 2012 RS Add-in for SharePoint" installed while others do not . That feature is not being used in this ...
0
votes
0answers
41 views

SSRS report and performance point filter issue in sharepoint 2013

Deployed a dashboard in a sharepoint site this dashboard it has a Performance point filter which is get data from report database and it has a performance point report it is connected with a report ...
0
votes
0answers
9 views

Reports rendering without button images

One of those hard to describe problems but a picture is worth a 1000 words: We're using SharePoint 2013 with SQL 2012 Reporting Services in integrated mode. So it's just very strange that the image ...
0
votes
0answers
16 views

Report not rendered in browser in SharePoint Integration Mode

How to deploy reports in SharePoint Site? we have two urls for our External Web Application. Default Zone: https://interneturl.com Intranet zone: http://intraneturl.com ( extended to Intranet zone) ...
0
votes
0answers
83 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 ...
0
votes
0answers
21 views

Deploy Reporting Services to external site

When we deploy Reporting Services in our internet site it's not loaded, We have two urls for external web application. Default Zone: https://samplesite.com Intranet zone: http://sampleintranetsite....
0
votes
1answer
28 views

Access Oracle View to Generate reports in SharePoint 2013

I have one view created in oracle database and I need to display some reports based on it on a SharePoint 2013 enterprise farm. I want to know which approach is preferable, should I create a BCS ...
0
votes
0answers
9 views

Can SharePoint 2013 SSRS Integrated Mode be referenced from another program?

We have a 3rd party system with a reporting module. It can generate it's own custom reports (non-SSRS) and also has the ability to generate RDL files to be ported into SSRS. There's not much ...
0
votes
1answer
58 views

Difference between SharePoint Integration mode and Native mode in SSRS

In SharePoint 2013, which one is best practise to configure Reporting Services in SharePoint Integration mode or Native mode? Based on which consideration we can choose? Which mode is best and what ...
1
vote
1answer
65 views

Using Powershell, can I run a report, export to PDF and save in Shared Documents Automatically?

I'm trying to determine how difficult it is to automate a process using Powershell. Using Report Builder, I created a simple report with a single parameter, the ID number of the list I use as a ...
0
votes
2answers
96 views

Unable to run any SSRS report last modified by this user

When I try to run any report by one of our previous SharePoint admins, I'm getting error. Report Server has encountered a SharePoint error. (rsSharePointError) Object reference not set to an ...
0
votes
0answers
80 views

SSRS Report Parameter Issue: Report Viewer Webpart Sharepoint Server 2013

I have added multiple ssrs reports on multiple pages using report viewer webpart. On small reports, I can change parameters and report are working fine as per changed parameters. But big reports are ...
1
vote
1answer
72 views

Skill Matrix using SharePoint 2013 List

I want to create the Skill Matrix in SharePoint 2013. How to create the skill matrix using SharePoint List? Matrix that contains all the development skills of the Employee in different departments. ...
0
votes
1answer
25 views

Reporting server configuration in a sharepoint farm?

For configuration of SQL SERVER Reporting server in SharePoint mode is can we install reporting services add-in for SharePoint in all servers in a SharePoint farm? I did installed reporting server ...
0
votes
0answers
30 views

How to integrate sql server reporting services in sharepoint?

how to integrate SQL SERVER REPORTING Services in sharepoint 2013, I have a sharepoint test farm with one app server , one wfe server and one sql server. I prepared a new windows server 2012 R2 ...
0
votes
0answers
45 views

SSRS Multi Parameter selecting is not working

I have a report which has 2 date parameters and 1 drop down parameter. It works fine without drop down parameter, but with drop down it shows error Error occurred during local report processing. ...
0
votes
0answers
45 views

how to pass ID field in Source expression in SSRS report

I am preparing SSRS report for my SharePoint site. I have two lists interconnected with lookup using internal ID column. While preparing SSRS report, I referred the below syntax to get lookup field ...
0
votes
1answer
19 views

Deploying User Profile Application - My Sites

I need to use specific features available when deploying UPA. Hence I need to create a "my sites" site collection because I need to use the "Site feed" feature. I need to know if deploying the my ...
0
votes
0answers
5 views

Added server to MOSS 2007 farm and it is redirecting to first one

I installed MOSS 2007 on a new 2008 R2 server and added it to the farm successfully. When I go to the server name in a browser it redirects me to the old server, if I use fiddler I see it do a 302 ...
1
vote
2answers
25 views

Configure Reporting Services on SharePoint backend SQL server

So currently I have an Integration mode installation of Reporting Services on my SharePoint backend SQL server, however this cannot be configured because the SharePoint backend SQL server must be ...
1
vote
1answer
47 views

Can we rollback SSRS installation on SharePoint 2013 on-premise?

Recently we got a request to install SSRS on our SharePoint 2013 on-premise environment to perform some prove of concept experiment. My concern is, the environment is our development farm, we need it ...
0
votes
0answers
85 views

SP2013 Analytics - user visits per page

wondering if anyone can help with a few questions I have on SP13, and the OOTB functionality (or there is any third part tools) that produce the following stats... Page views by user (i.e. a list ...
2
votes
2answers
26k 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 ...
0
votes
1answer
133 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 ...