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
10 views

Good quality training [on hold]

Does anyone know of good training options in Europe? I'm looking for comprehensive training on reporting services/features. Thank you
1
vote
2answers
25 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 ...
2
votes
1answer
6k 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 ...
0
votes
2answers
20 views

Configure SSRS for SharePoint 2013 with PowerShell

So I have to configure SSRS on my box and i tried to search feature name "Report Server Integration Feature" and could not found and my search lead to below two post. Installing Reporting Services In ...
0
votes
0answers
7 views

How to show report from 10 related large list in SharePoint 2013 online?

Since SSRS report is not available in SharePoint 2013 online, how can we show complex report combining data from few very large size and related lists? in case of on-prem we had used SSRS in similar ...
1
vote
2answers
4k 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
1answer
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 ...
1
vote
0answers
7 views

Report Server has encountered a SharePoint error

I'm trying to deploy a report created with SQL Business Intelligence 2008 on a Sharepoint 2007. I've done this process a lot of time, but since yesterday I receive this error when deploying: ...
1
vote
1answer
39 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 ...
1
vote
0answers
11 views

Connecting MS Access Web Database Tables and Queries

I have created MS Web Access Database (2010) and hosted in SharePoint 2010. I would like to create reports in SharePoint using MS Web Access Database Tables; possibly using SSRS. I'm able to develop ...
0
votes
1answer
31 views

Get rid of Duplicates in SQL Report Drop down Parameter (SharePoint Report embedded)

Is it possible to have a drop down parameter only show a unique value if I have multiple values? If I have 5 items with 123, I only want 123 to show up once in the drop down. Currently I have a ...
0
votes
0answers
26 views

RDL reports do not work in Mobile Devices in SharePoint 2013

RSViewerPage.aspx does not show all RDL reports in mobile devices.(IOS, Android) I have On-Premises SharePoint Farm application. It means I can change RSViewerPage.aspx if there is any need. Is ...
0
votes
1answer
163 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, ...
1
vote
1answer
22 views

How transform results of caml query to rows into columns

Can anyone tell me how to transform results of caml query to rows into columns. Caml query is returning results from sharepoint list in the below format. Column1 Column2 Column3 Value 1 Value 2 ...
3
votes
1answer
1k 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 ...
3
votes
1answer
705 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 ...
2
votes
1answer
45 views

How to add SharePoint List as one of the data connection type in SSRS report?

I want to create a report with SSRS that consumes data from SharePoint list. When I add a new shared data source in the Business Intelligence Studio, all the options other than the SharePoint List are ...
0
votes
0answers
24 views

Issue where-in User is asked to login to the sharepoint site twice (with the same credentials)

We have set up some dashboards through Team Foundation Server, using the Team Foundation Project Portal (sharepoint site) feature. For the dashboards and various charts/reports required, we have used ...
0
votes
2answers
358 views

RS Web parts title doesn't change

After installing the RSwepart that come with SQL server 2008. I noticed that the webpart title doesn't change. After i have tried changing it from Report Explorer to something else. See them here: ...
0
votes
0answers
26 views

ReportViewer toolbar buttons are disabled

I've integrated ReportViewer 9 on a SharePoint 2013. The SSRS is configured in Native Mode. I can see the report with IE 11 but all buttons of the toolbar (next page, prev page, print etc) are visible ...
0
votes
0answers
15 views

Report with all links on a site

Working in SharePoint 2013. The issue at hand is that I would like to have a list of all the links within a site collection. In SharePoint 2010 there use to be a way you can obtain a report within ...
1
vote
2answers
57 views

Report published from BIDS not trigger “new-item” workflow

SharePoint 2013, SSRS 2013 SharePoint integrated mode. Document library with correct content types for SSRS. Workflow on that library set to run on "new item" and "edit item". Workflow is set to a ...
0
votes
0answers
14 views

Calculated column used in reporting services shows #Error

I am using the following formula in a calculated column to extract the month from the "ResolvedDate" column. =""&MONTH(ResolvedDate) It works well, but now I intend to use it in reporting ...
0
votes
0answers
14 views

Share point reporting services not working?

I have installed sql server 2012 sp2 and deployed rdl files into ReportingServer, and trying to hosting in the sharepoint 2013 foundation server . I have installed SP2. I am keeping data base for ...
0
votes
0answers
13 views

install reporting services on sharepoint 2013 stand alone

Is reporting services install on sharepoint 2013 stand alone? I install sql server feature and add-in Microsoft sharepint, when I complete create service I give an error: The database engine ...
0
votes
0answers
20 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 ...
1
vote
1answer
84 views

Cannot add ReportViewer Webpart via Powershell to Page

On my SharePoint 2010 I want to automate Website-Provisioning with customized homepage. The homepage should show some SSRS ReportViewerWebparts. I get error messages, I am very surprised of and cannot ...
0
votes
0answers
20 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
0
votes
0answers
12 views

Sharepoint Workflow Email Report

Any idea how I can generate and email a SSRS report in sharepoint workflow. I have SSRS in sharepoint integration mode. Thanks.
2
votes
2answers
4k views

How to change Native Mode to SharePoint Integrated Mode in SQL Server 2012

I have installed SQL Server 2012 in Native Mode. How can I change it to SharePoint Integrated Mode? In the Reporting Service Configuration Manager Tool I found that there is no option to change Native ...
0
votes
0answers
16 views

SSRS breadCrumbs SharePoint 2010 Problem

I have SSRS Library in that I have one folder called UATReports and in that I have test.rdl SSRS report.When I try to open that test.rdl file I need to view breadCrumbs like below For read access ...
0
votes
0answers
12 views

Mutiple rows and columns SSRS report

I am working with SQL Server Reporting Services 2012 and have a requirement to design a report as shown below. But I am not sure in which control this kind of report will fit in.(Tablix/Matrix/List) ...
0
votes
0answers
45 views

Calculated field in SSRS dataset

I'm making an SSRS report using a SharePoint list as a data source and I want to create a calculated field in my data set. I want to use one field in my data set line type to determine the value of ...
0
votes
0answers
49 views

“Add Data Driven Subscription” missing in SSRS sharepoint mode

I'm using sharepoint 2013 with SQL server 2012 Enterprise Edition SP2. I am using SSRS in sharepoint integrated mode. When I hover over report options I see the "Manage Subscriptions" option and when ...
2
votes
2answers
1k views

SSRS ReportViewerWebPart Height Issue

I am working with a customized page that has an embedded ReportViewerWebPart inside of a content tag. In this case, it's inside of "PlaceHolderMain". It looks like this: <asp:Content ...
0
votes
1answer
18 views

Sharepoint - Customizing Reports

I've recently been given the task of customizing our reports on sharepoint. Being brand new to sharepoint, I'm kinda walking through the dark. I was wondering, is there a way to take the reports ...
0
votes
2answers
28 views

Error while configuring Reporting Services Integration

I am trying to configure Reporting services with SharePoint via central admin -> General Setting -> Reporting Services Integration Error is as shown below. What is the problem?
0
votes
1answer
82 views

SharePoint error after adding SQL Server Reporting Services Report Viewer webpart

We created a new wiki page. Then, we add a new webpart to this page -> SQL Server Reporting Services Report Viewer webpart. Now the page gives error. What could be the problem?
0
votes
1answer
52 views

What is difference between SQL Report viewer webpart and showing the report via page viewer webpart?

We have not yet configured Reporting integration on our SharePoint site. Currently the way we show TFS reports are by adding the page viewer webpart to the SharePoint dashboard and then pointing this ...
0
votes
0answers
25 views

Displaying all versions of a field in a list on a report

I use SharePoint 2010 and SQL Report Builder 3.0. I am creating a new report whereby I want to display all the versions of a data field on the report. One of the fields I need to report on is called ...
1
vote
2answers
3k views

SharePoint 2013 SP1 Installation Issue- SSRS Content Type Missing for New SC

Recently I have Installed SharePoint SP1 (15.0.4571.1502) I have Create a New Web application and SC with BI Center Template. Activated the Report Server integration feature and deployed PowerPivot ...
0
votes
0answers
30 views

SSRS Integration and SharePoint 2013?

I have a new SharePoint 2013 farm that is running on a SQL 2012. I have SSRS libraries working in SharePoint but we also have seperate SSRS servers (some SQL 2008 R2 and some SQL 2012). We want to ...
0
votes
1answer
50 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 ...
0
votes
0answers
31 views

Dropdown parameter of ssrs report in sharepoint webpart got hang when clicked

I am creating a web part which will have a SQL server report integrated into it. i have 6 parameter in the parameter box. one of the parameter have drop down in it. when i click on the drop down for ...
2
votes
1answer
37 views

Cannot create subscription in SSRS (2008) . Sharepoint 2010 as datasource(XML)

I created a report which displays sharepoint list in SSRS using XML as datasource. I can view the report but i cannot create subscription in SSRS. Here is the error Subscription cannot be created ...
0
votes
0answers
20 views

Report off SharePoint List

I have a SharePoint 2013 list. This is On Prem. The list has a notes section. I run a report daily that pulls certain fields from that list, including the note section. I am having a formatting ...
1
vote
0answers
43 views

SSRS Code Behind and SharePoint

I have a couple of general questions about using VB code with SSRS reports in SharePoint. I have noticed that when I use an expression on my report, the expression only talks to the data that is in ...
0
votes
0answers
43 views

Connecting using SSRS Report SharePoint list datasource - Windows Integrated Security doesn't work

I have a report I'm building using SSRS and a SharePoint List as datasource. The report works ok only if I login with my credentials before viewing the report. My credentials do not pass automatically ...
1
vote
1answer
19 views

Impact of upgrading Sharpoint 2013 to Sharpoint 2013 Service Pack 1 on SSRS Reports

Hope you all are doing well! We have a BI System that consists of SQL server Reporting Services 2008 R2 and we have deployed the reports on Sharepoint 2013. We were planning to upgrade the Sharepoint ...
0
votes
0answers
358 views

Add ReportViewer WebPart at runtime

I am working with feature receivers in SP2010. I can successfully create web part pages and drop web part on the pages on feature activation.I was trying to add ReportViewerWeb Part (Integrated Mode) ...