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
5 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
30 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
35 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
66 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
16 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
48 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
645 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, ...
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
12 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
3answers
1k 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
0answers
23 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 ...
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
0answers
34 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
2answers
632 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
32 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
4 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
22 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
29 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
67 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
55 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
244 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
37 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
21 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
33 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
97 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
26 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
47 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
17 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
31 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.
1
vote
0answers
20 views

Error when setting up Reporting Services

I'm trying to set up Reporting Services on my SharePoint farm however I am getting this error when I try to access the URL: The configuration parameter SharePointIntegrated is set to True but Share ...
0
votes
1answer
75 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
1
vote
0answers
32 views

Can't find the cause of user credential prompts in SharePoint site

I have a SharePoint 2013 instance that runs our company intranet site. This past weekend we moved our site to a new set of servers and we also set the site up use SSL (https). Since this move, some, ...
0
votes
0answers
34 views

SSRS multi parameters problem in sharepoint 2013

I have a reports which has 5 Parameters are multi select. It works fine in SSRS Reporting Manager and Report Builder but when I host in SharePoint and try to select multiparameter it doesn't do ...
0
votes
1answer
130 views

SSRS Multi Parameter Report not working in Sharepoint 2013

I have a report which has 2 Parameters both are multi select. It works fine in SSRS Reporting Manager and Report Builder but when I host in SharePoint and try to select multiparameter it doesn't do ...
0
votes
0answers
36 views

How to enable MS Project Server Web App Reporting in MS Project server 2013?

I have MS Project server 2013, I want to enable reporting I have followed steps given in (https://technet.microsoft.com/en-us/library/ee662106.aspx ) but still when I click first it opens excel and ...
0
votes
0answers
8 views

Removing an SSRS Server

We have a server in our SharePoint 2010 farm that runs SSRS in "integrated mode". We would like to remove this server from our farm and run it in "Native mode". How can this be accomplished? Do I ...
1
vote
1answer
23 views

Separating SharePoint instance from Reporting Services (currently shared instance)

Currently we are running SharePoint 2007 and Reporting Services on the same server. Our reporting group would like to decouple this integrated environment. I've found several sources on how to ...
0
votes
1answer
540 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?
1
vote
1answer
23 views

SQL Report Builder 3- build report from different lists dynamically

I have an script that automatically creates a SharePoint list for each new SiteCollection in my WebApplication, so I have many different lists each contains the same columns. The lists name matches to ...
0
votes
1answer
41 views

Usage Reports of SharePoint 2013 site are showing empty data. Yet Timerjobs are running properly

I am working on SharePoint 2013 usage reports. And I need to check that at how many times the users have hit the SharePoint 2013 SSRS reports in the document library on monthly and daily basis. I have ...
1
vote
0answers
183 views

Mail won't send - specified string is not in the form required for an e-mail address - SSRS Subscriptions

I am running SharePoint 2013. We use Exchange Online for e-mail. Because we have this set to require SSL, and SharePoint won't send mail with SSL, I have a local SMTP relay set up on the SharePoint ...
0
votes
0answers
29 views

Can't access SSRS reports on SharePoint 2007 farm

We get this error in the Report Server logs when trying to access a report on the SSRS server: security!ReportServer_0-7!20c0!12/22/2015-10:41:11:: i INFO: Exception while running with ...
2
votes
1answer
66 views

Is it possible to get data from excel file and create a pie chart and display on a sharepoint site?

Can we create a pie chart using excel reporting service. I have a excel file (.xlsx) on my SharePoint document library. I want to use excel data and create a pie chart but don't want to create this ...
3
votes
2answers
45 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
0
votes
1answer
93 views

Manipulate Report Viewer Webpart Parameters via PowerShell on a SharePoint 2010 WebpartPage?

I want to set the parameters of a SSRS report which is displayed through the ReportViewerWebPart by PowerShell, all on SharePoint 2010 WebpartPage. Right now, I'm confused by the documentation of the ...