0
votes
0answers
8 views

SharePoint 2010 Reporting Services Integration - No Report Servers Were Found

I have a 3-server farm with SharePoint 2010. There is SQL Server 2008 R2 installed on database server and SQLServer2012 installed on application server. And there is SQL Server 2008 R2 installed on ...
1
vote
1answer
60 views

Reporting Services Service Application Authentication Error?

I have "inherited" a small SharePoint farm with an App SP server and a database. The cilent wish to use PowerView and Reporting Services seems to be configured correctly (but apparently isn't). When ...
0
votes
1answer
77 views

Collect data from SharePoint and make from that a report

I want to create a report , the data source will be a SharePoint list . I tried to use the PowerBI (unfortunately , its configuration is not going so well) , then I thought about Excel (a combination ...
0
votes
0answers
67 views

SSRS and SharePoint list - The remote server returned an error: (401) Unauthorized. (rsXmlDataProviderError)

I'm trying to use reporting services 2012 to connect to SharePoint list. Using : http://sharepointserver/_vti_bin/lists.asmx as a connection string But i keep getting error: Failed to execute web ...
0
votes
1answer
657 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.
2
votes
1answer
30 views

Reporting Services - SharePoint 2010 Integrated mode

E-Mail subscriptions couldn't send, all e-mail subscriptions are in "Pending" status. Some e-mails sent but some don't. Is there anybody know anything about it? Why are they all in pending status? How ...
0
votes
0answers
25 views

Customized User and Graphical Interface for reports's website

If I have about 80 reports from SSRS that need to be applied to different website at SharePoint's intranet. Let's say about 20 for a webpage, 50 for a another webpage and 10 reports in a another ...
1
vote
0answers
70 views

Permission are insufficient after Migrating SSRS from Native mode to SharePoint 2013 Integration Mode

I have some SSRS reports which are in native mode on reporting server. The reports have 2 kinds of data sources: database connection and report model. I can run/view the report using my account ...
2
votes
1answer
58 views

Reporting Service on SP 2013 use a sql 2012 report server running as native mode?

Sharepoint Reporting Service Integration has to be done with a report server running on SP integration mode? Is this true in SQL2012 + SP2013? I have a SQL2012 Report server which is in Native mode ...
1
vote
0answers
67 views

Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException

I'm getting following error in the General Application Settings-->Reporting Services-->Set Server Defaults section and also viewing reports on SharePoint. The version of the report server database is ...
0
votes
1answer
216 views

SharePoint 2010 Reporting Services Integration Set Server Defaults Error

We are using one FrontEnd server and one DataBase server on our current farm with reporting services integration. We need to change your farm to on FrontEnd server, one Application server and one ...
1
vote
0answers
65 views

SSRS Report Designer and SharePoint 2010 Mixed-mode Authentication

We have a SharePoint 2010 installation that connects to a SQL Server 2008 R2 reporting server which is running in SharePoint Integrated Mode. Initially, our web application was using Classic Mode ...
1
vote
0answers
74 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 ...
0
votes
1answer
30 views

How is SSRS report Deployed to remote server in SharePoint 2010

How is SSRS report deployed in the remote production server where there will be no connection between prod/ staging & production server? you can only send some staff to prod server. What are the ...
0
votes
1answer
84 views

Unable to view SQL RS Services on Server or add new SQL Service Application

I have the following SharePoint 2010 Environment: 2 - WFE 3 - SharePoint Application Servers 1 - SharePoint Database Server with 2008R2 One of the Application Servers has SQL2012 SP1 installed ...
0
votes
1answer
336 views

Set SSRS Report Parameter Through JavaScript

I am running SSRS 2008 in SP2010. I want to set some report parameters through JavaScript. Is it possible if yes then how. Basically I read some values from the page itself and then set the report ...
0
votes
1answer
963 views

SSRS Parameters passed through URL not refreshed on Web Part Page

My working environment is SSRS 2008 and SharePoint 2010.I have a report with parameters running in SP 2010. I call my report page in SP 2010 from a page with all the parameters in query string. On the ...
0
votes
0answers
91 views

Deploying SSRS report from BIDS to SharePoint 2010

I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
251 views

Is it possible to use Powerview with SharePoint 2010 SP1 on SQL Server 2008 R2

I have a SharePoint 2010 SP1 environment configured over SQL Server2008 R2. I have an Analysis Server running on a separate physical server which is also SQL 2k8 R2. I want to create a powerview ...
0
votes
1answer
29 views

SharePoint 2010: How to determine in what mode SQL Server Reporting Services is installed

SharePoint 2010 Standard farm. How can I determine in what mode the SQL Server Reporting Services is installed? When installing SQL Server Reporting Services (SSRS), you must choose the mode in ...
0
votes
1answer
2k views

SQL Server Reporting Services: The remote server returned an error: (500) Internal Server Error

I'm running a SharePoint 2010 Standard farm. I have 2 Web Front-end Servers, an application server running SSRS and 2 Database servers. SSRS is installed using the Microsoft SQL Server 2012 RS Add-In ...
0
votes
0answers
180 views

Convert Local Time (SSRS datetime parameter) to UTC Time

I am working with SSRS 2008 and SP 2010. My report has 2 parameters 1. TimeZone this parameter is read from SharePoint site (timezone of the site as per regional settings) the other is simple datetime ...
0
votes
0answers
57 views

PerformancePoint data source from Oracle

I have a requirement to create KPI and dashboard for which all data comes from Oracle. I am looking for getting this data into PerformancePoint to create KPIs.. Can anybody point me to the right ...
5
votes
1answer
232 views

Using SharePoint UserAccountDirectoryPath with SSRS

I've got a SharePoint 2010 Enterprise multi-tenant setup integrated with a new SSRS 2008 R2 instance in SharePoint-Integrated mode and have FINALLY managed to get everything working. However, there ...
1
vote
1answer
140 views

SharePoint, LINQ & Reporting Services Tools

I'm new to SP and SSRS, so I want to check if my thoughts are correct. Report Builder and BIDS suck on data retrieval so I have to go deeper using code. Is it possible to write some code in C# using ...
0
votes
1answer
244 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
168 views

“Actions” menu hidden in Report Viewer web part?

The Actions menu which allows for export to excel, pdf and other functions is hidden in all of my report viewer web parts. I did try to browse to the web part galleries to see if I can set it up ...
0
votes
1answer
884 views

How to scale out Reporting Services on SharePoint Integrated Mode over NLB

I have a SharePoint 2010 Enterprise farm with the following topology :- 2 WFE SERVER (behind NLB 1) 1 APP SERVER (used for Search) 1 APP SERVER (used for other service applications) 1 DB Cluster ...
0
votes
1answer
89 views

Causes for really long page Request times?

We have a sharepoint portal running SSRS reports for our customers. The reports themselves dont take that long to render, however the page requests take over 10-15 seconds which is simply ...
2
votes
2answers
37 views

Where to Install Reporting Service

To use Reporting Service integrated with SharePoint, where to install Reporting Service? Suppose that SharePoint env. has two physcical servers: application and database server. Should reporting ...
0
votes
3answers
328 views

Issue with SSRS and Sharepoint2010

I am adding a SQL Server Reporting Service Report Viewer Webpart onto a webpart page and i place a report generated using SSRS in the document library. I have two reports one with no parameter and one ...
0
votes
2answers
218 views

What do I have to do prior to site creation of a “Report center” template?

I have a SSRS service installed, I have Sharepoint 2010 Enterprise Edition. As I read on the internet, I should activate the Report Server Central Administration Feature in site settings > Manage ...
0
votes
1answer
112 views

Report Toolbar in SharePoint 2010

I have a SharePoint farm using SQL Server 2008 R2 and SharePoint 2010. In my production environment, my SSRS report within a Performance Point dashboard renders with the "old school" toolbar, which is ...
1
vote
1answer
310 views

SSRS reports not visible to all users in spite of permissions?

I have added a SSRS report to one of my department home pages and two things concern me: It is very slow - almost a minute to render and any slicing takes a minute as well. Reporting services ...
1
vote
2answers
856 views

Installing SSRS on the Sharepoint Box as opposed to the SQL Box?

We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases. We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
0
votes
2answers
55 views

Reporting Server Integration with Sharepoint Server 2010

I have a Sharepoint server 2010 Enterprise in a public domain and a SQL2008 standard in a local domain (with an installation of sharepoint 2010 to support report integration). Does Microsoft support ...
0
votes
1answer
99 views

SharePoint 2007 integration Reporting Services 2005 having error!

Previously the reporting services in SharePoint 2007 are working fine. Suddenly it appear an error as below:- The request failed with HTTP status 401: Unauthorized. at ...