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
8 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
11 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: ...
1
vote
1answer
598 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 ...
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
1answer
708 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
3answers
27 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
37 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 ...
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
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 ...
0
votes
1answer
17 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
13 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
25 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
14 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
28 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
18 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: ...
3
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
1answer
12 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
2answers
656 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
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
33 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
46 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
73 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
39 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
60 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
0answers
18 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
20 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
25 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
37 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
36 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
24 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
35 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
72 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
25k 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
83 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
248 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
43 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
25 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 ...
0
votes
0answers
13 views

RSViewerPage breadcrumb, where to change link

Received a request today to modify the URL for this breadcrumb on a Report (RDL). We have are using the internal ReportServer setup for SharePoint. Visual: I have looked at the RSViewerPage to see ...
0
votes
0answers
42 views

SSRS report issue inside of SharePoint 2013 reports

Win7, IE11, SP2013, SQL12, and SSRS the Printer Icon never renders for users to print a report? Have updated the ReportViewer dll, SP1 for SP2013, SP1 for SqlServer with cumulative patch 8 applied. ...
0
votes
0answers
107 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
29 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 ...
2
votes
2answers
49 views

Sharepoint reporting on permission

I wanted to get a report of all the user in SharePoint and know what each user has permission. I am trying to track down each user permission level for every site they have so I can identify if they ...
0
votes
1answer
22 views

How can i work out if my SharePoint 2010 has a Report Server set up?

I have been given a SharePoint 2010 environment, and wanting to know if a report server has been set up. Is there anyway I can tell? When I go to Set server defaults in General Application settings ...
0
votes
0answers
34 views

Error when Uploading an RSDS File to SharePoint, collection and SSRS out of synch

I have a site collection with an RSDS file in it that gets modified by a powershell script. The script downloads the rsds file, modifies it, then uploads the new copy. It works great but the file is ...
0
votes
1answer
12 views

what binaries do i need to get SP reports working on sharepoint 2010

I am configuring the report services on my sql server and am wondering what sharepoint binaries I need to install on the server to get the reports up and running.