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
0answers
29 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
800 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
13 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
695 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
22 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
328 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
3answers
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 ...
2
votes
2answers
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 ...
0
votes
0answers
115 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 ...
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
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
3answers
686 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 (...
0
votes
0answers
15 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
85 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
28 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
30 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
50 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
32 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
14 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
33 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
55 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
20 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
22 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
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
42 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
51 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
88 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
54 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
63 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
21 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
28 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
40 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
40 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
76 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
119 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 ...
2
votes
1answer
258 views

SSRS reports deployment in production server

We have 50 SSRS report created in SharePoint 2010 integrated mode. Now we want to move these 50 SSRS reports to production server. Do we need to create script for this deployment (of report in ...
3
votes
1answer
45 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:
0
votes
0answers
29 views

unable to load client print control error while printing

in our sharepoint 2007 farm . we are facing print issue in SSRS and users are getting errors "unable to load client print control" . with the help of our DBA's we found out that the issue is in the '...