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)

3
votes
1answer
686 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
41 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
16 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
345 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
15 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
14 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
45 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
12 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
11 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
14 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
53 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
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 ...
0
votes
0answers
9 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
8 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
11 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
36 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
32 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
27 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
35 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
39 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
24 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
2k 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 ...
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 ...
0
votes
0answers
23 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
31 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
27 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
22 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
19 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
37 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
39 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
356 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) ...
0
votes
1answer
31 views

SSRS and Item-Level Permissions

Simple and straight question: Will users that access the SSRS reports I have connected to my SharePoint list inherit the permissions set for that list, including item-level permissions?
3
votes
1answer
121 views

What to do when SharePoint Lists and SSRS isn't enough?

I've developed a complicated InfoPath web form for reporting outages. This system will be maintained by someone with little technical skill, so in a lot of places the form populates its dropdowns from ...
0
votes
0answers
35 views

Ad-Hoc Reports in SSRS Sharepoint 2013

Is it possible to generate models in SSRS from SharePoint Lists? When trying to create Models, through Report Builder Model as SharePoint List as datasource, following error is displayed. Data ...
0
votes
0answers
11 views

SSRS 2014 wITH SharePoint 2013 foundation

I am a SAP BI consultant and have been more than itching to get on MSBI bandwagon. I have had a major roadblock in the form of SharePoint. I have SQL Server 2014 installed on my laptop which is 16GB ...
0
votes
1answer
33 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
0
votes
0answers
17 views

Use [Me] As Parameter In SSRS Report Builder 3.0 Report

How can I roll up tasks using the SharePoint equivalent of [Me] as a parameter in a Report Builder 3.0 report?
0
votes
1answer
56 views

Item-level Security on SSRS report from SharePoint list

We have created an SSRS report from SharePoint 2010 list. We have item level permission in the source list, so the user can view only the items for which they have privilege. But in SSRS report it ...
1
vote
2answers
784 views

Reporting Services Error after doing a restore on a new farm and attempting to view a report

The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound) The source farm reports work fine, but after the restore to a new farm, some (not all) reports get this error. Looked ...
1
vote
1answer
13k views

Generate report from sharepoint 2010 list

I need to generate a report from sharepoint 2010 list using any good and easy method. Any suggestions along with the procedure are welcome.
0
votes
0answers
11 views

Fetch User Access permissons from SharePoint reports(.rdls)

I have a sharepoint site where DWH reports are hosted. I wanted to create a report which provides me the list of existing users having the access on each .rdl. Is there any PowerShell script or Sql ...
0
votes
0answers
56 views

Report Viewer web part connected parameters not visible

I have a SSRS report with two visible parameters, Location and department. I have hosted it in a sharepoint page using Report view web part. When I connect "Location" parameter of my report viewer web ...
0
votes
0answers
83 views

HTTP 403 Forbidden on accessing layouts pages from a SharePoint 2013 app web

I have added the report content types (that comes with reporting services) to a document library in an app web. But when creating an new report by the ribbon > New document I get a 403 Forbidden ...
0
votes
1answer
123 views

Pass current user filter to ssrs hidden parameter

I have a SSRS report hosted in sharepoint (in Report Viwer Webpart).That report has a hidden parameter "username". I want to pass current user to that ssrs report. But when I tried to connect to ...