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
593 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
0answers
57 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 ...
0
votes
0answers
152 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
79 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
385 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
67 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
122 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
74 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
53 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
71 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
174 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
73 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
391 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
129 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
98 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
92 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
257 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
643 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
47 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
87 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
82 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
348 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
1answer
29 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
144 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
279 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
35 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
312 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
196 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
579 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
191 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
119 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
97 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 ...
1
vote
1answer
621 views

ReportViewer.dwp not working - Session state has been disabled

I'm getting this error while try to open ReportViewer.dwp: Message : Name=Request (GET:http://xxxxxxxx/_layouts/WPPrevw.aspx?ID=64) Message : Site=/ Message : Leaving Monitored Scope ...
1
vote
2answers
4k views

Display SSRS reports in SharePoint custom webpart

I would like to display SSRS reports in my custom WebPart. I would also like to set the permissions to particular AD user for accessing those reports. How can I do it programmatically?
0
votes
0answers
4k views

SSRS SharePoint Integrated Mode: The status code returned from the server was: 12019

I am running SSRS in SharePoint Integrated Mode and just recently started receiving the following error message when viewing a long-running report: ...
0
votes
2answers
202 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
0
votes
1answer
415 views

Refused to execute script Reserved.ReportViewerControl.axd in SharePoint 2013

We are migrating our ASP.NET WebForms and MVC 3.5 Application to our new SharePoint 2013. Lots of our applications use Reporting Services which use ReportViewer Control 9.0 but when we deployed the ...
1
vote
1answer
123 views

Dates returned as #error in SRSS report from SharePoint list

I have connected an SRSS report (in SQL Reporting Services 2012) to a SharePoint 2013 list. Date fields all return #error, but other fields return data successfully. May query looks like this: ...
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
75 views

Sharepoint and reporting services, how to reuse a report in another environment?

I see some link on a SharePoint 2010 portal. When I click on the link below I need to wait for 30 seconds and then I see some report generated and is showing in the reportviewer. It shows all items ...
1
vote
1answer
381 views

Repeating Login Prompts when deploying reports using Visual Studio 2012 BIDS

I am running SharePoint 2013 integrated with SQL Server 2012 and SSRS but I've been having problems trying to deploy my reports from Visual Studio 2012 BIDS. Whenever I enter in my login credentials ...
2
votes
2answers
670 views

SharePoint Document Library Subscription Errors

I have SSRS 2012 setup in SharePoint Integrated mode. I am receiving the following error when trying to setup a subscription to a SharePoint Document Library. A delivery error has occurred. ---> ...