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
31 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
22 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
27 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
1answer
97 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
2answers
116 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
258 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 ...
1
vote
1answer
369 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
28 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.
0
votes
0answers
20 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
27 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
143 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 ...
0
votes
1answer
36 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
1answer
172 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
2answers
33 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
624 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
426 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 ...
2
votes
1answer
140 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
26 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
1answer
78 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 ...
1
vote
1answer
25 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
1answer
57 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?
0
votes
1answer
76 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 ...
3
votes
1answer
178 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
1answer
74 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 ...
0
votes
1answer
431 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 ...
0
votes
1answer
132 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
100 views

Invalid URL Error when deploying rdl to SharePoint 2010

Has anyone come across the following error when trying to deploy a .rdl file onto SharePoint 2010? Report Server has encountered a SharePoint error. ---> ...
1
vote
1answer
22 views

Sharepoint reports showing up as xml

We recently installed PowerPivot into our SharePoint environment and it started causing issues with our reports(.rdl) which are now displaying as XML. Any ideas what might cause this?
1
vote
1answer
95 views

Is there a way to log specific clicks?

I need to log when users click on specific links on our SharePoint site. Something like: bob@company.com - Clicked Special Link #1 - 02/13/2015 14:41 joe@company.com - Clicked Special Link #7 ...
0
votes
1answer
275 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
0
votes
1answer
700 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
1answer
50 views

SharePoint 2013 and ReportingServices2010 CreateDataSource Example

Can anybody help me with how to use CreateDataSource with SharePoint 2013 to Create a Data Connection in C# code?
0
votes
2answers
92 views

PerformancePoint webpart showing report from Reporting Service, but is showing cached content!

I am using sharepoint 2010. I have created some reporting service report. On some page, I have created the PerformancePoint webpart to show the reporting service report. It works and shows content. ...
0
votes
1answer
85 views

What is the best practice to create some SSRS report to show info from a list, and show in a webpart in SP 2010?

I am using SP2010. I have a list with some important info. I would like to generate some report in SSRS. What is the best practice to create a SSRS report with the source from a SharePoint list? I ...
0
votes
1answer
366 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
1answer
30 views

SharePoint reporting services integration

I am using the SharePoint report services integration. I deployed a report to a document library, but when I try to view the report (form SP), I receive this error: login failed for user 'nt ...
0
votes
2answers
147 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
1
vote
0answers
289 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
0
votes
1answer
36 views

Create a ReportingServices data source and upload to a data connection library

I have installed reporting services 2012 in SharePoint 2013 integrated mode. I need to create a report data source and upload it to a data connection library using C#. As I know it uses the ...
2
votes
1answer
326 views

SharePoint 2013 + Reporting Services + Kerberos

How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database? I found below blog but I'm not sure about ...
1
vote
0answers
204 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
0
votes
2answers
57 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
-2
votes
1answer
147 views

SharePoint WCF SOAP, Rest, AJAX [closed]

I need to know the following things: How is SharePoint used with WCF, REST and SOAP.
0
votes
0answers
589 views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
1
vote
2answers
5k 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
1answer
1k views

SharePoint SSRS Report in iFrame

How can I display an SSRS Report in an iFrame? Is there some setting somewhere to enable the content to be viewed? I know bing allows their page to be viewed in an iFrame, whereas google does not. ...
1
vote
0answers
197 views

SharePoint 2013 Reporting Service Integration mode

I face a difficult problem that I don't understand. What I have: SharePoint 2013 Enterprise SQL Server 2012 with all installed SP features, but configured in NATIVE mode. Both on the same server ...
4
votes
5answers
1k views

Report Server Sharepoint 2013 Errors

We have Report server services in SharePoint Integrated mode and it was working up until last week but now when ever we are trying to open a report or data source we are getting the below error ...
0
votes
1answer
121 views

Adding SSRS to Farm…Do I need to install Project Server onto instance?

We have a Sharepoint farm with four servers: Admin WFE Search Workflow We installed Project onto the farm and are looking to install SSRS into the farm on its own server. As part of getting the ...
1
vote
0answers
99 views

Reporting Services Webparts not Available in SharePoint Designer 2010

Firstly, I work as a DBA and have very limited understanding about how everything hangs together in SharePoint, so apologies if this is something pretty basic. We have just recently upgraded our WSS ...