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)

1
vote
0answers
149 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
47 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
229 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 ...
1
vote
1answer
41 views

automate reporting, create a separate report for every instance in a report via the schedule manager

is it possible to create a separate report for every instance in a report via the schedule manager in sharepoint? If not what other way is there? Thanks for your help
0
votes
2answers
170 views

SharePoint 2010 SSRS Report Manage Processing Options cannot click OK to save changes

When attempting to change Data Refresh Options for an SSRS report I'm unable to click the OK button to save changes. The button appears to press in the browser, however no event fires. Its almost as ...
0
votes
1answer
612 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 ...
1
vote
1answer
65 views

Is SSRS Required to use Report Builder 3.0

Do I need SQL Server Reporting Services configured to create reports against SharePoint 2010 Lists using Report Builder 3.0 ? I see that I can download an individual installer. Bismarck
2
votes
0answers
117 views

Package and Deploy SSRS Reports / Datasets etc

I have a VS report solution that contains around 40 reports as well as the child reports, sub reports, shared data sets, and data sources. How do I package these for SharePoint to deploy as a managed ...
0
votes
1answer
210 views

InfoPath 2013 to replace formated SSRS reports of Single SharePoint List items?

New to Infopath. Can we natually and easily use Infopath 2013 to do the following with SharePoint: Format SharePoint List Data on a sharePoint WebPart web page for a single SP List item (determined ...
1
vote
1answer
2k 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
1answer
40 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
3k 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
1answer
287 views

SSRS add 2 date time Fields

I have 2 datetime Fields in SSRS and I am summing both of them like: =TimeSpan.FromTicks(sum(Fields!Logout_Time.Value-Fields!Login_Time.Value)). The output is correct but is in hh:mm:ss format, I ...
0
votes
2answers
819 views

SSRS Dataset valid, but data does not show up in generated reports

I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder. When I hit "run query" on my dataset in the query designer, I ...
1
vote
1answer
447 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
0
votes
0answers
153 views

SharePoint 2010 multiple report viewer webparts - very slow

I have 7 report viewer webparts on one SharePoint page. It takes ages to load all of them, if I open the RDL directly, the report loads within 2 seconds. If I remove 6 web parts (thus, only 1 web part ...
1
vote
2answers
3k 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 ...
1
vote
1answer
425 views

Join multiple lists using XML web service

Implement a new XML web service, in the web service, use the SharePoint API to merge or join two or more list. Then, in SSRS, retrieve data from the XML web service using XML data source type. ...
1
vote
2answers
3k 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 ...
6
votes
1answer
340 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
187 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
610 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
2answers
824 views

SSRS 2008 R2 Querystring parameters Sharepoint Integrated Mode

I’m trying to run a report via the following url: http://portal/dashboards/hr/reports/_vti_bin/ReportServer?http://portal/dashboards/hr/reports/reports/Test.rdl However, I get a 401 Unauthorised ...
1
vote
0answers
263 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 ...
1
vote
0answers
188 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
0
votes
1answer
1k 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
2answers
2k views

Creating SSRS report in SharePoint 2010 with multiple SPLists

I have SP Lists Students: StudentID, Name, Address,Email Course: CourseID, Name, Duration, Fees StudentCourse: StudentID, CourseID How can I query these lists and create a SSRS report displaying ...
1
vote
1answer
519 views

Calling Reporting Services API from SharePoint 2013 application page

While upgrading from SharePoint 2010 to 2013 I am facing the following problem. I have an application page, from which an SSRS API call is made to get all subscriptions for a report. ...
3
votes
5answers
3k views

SharePoint 2013 Standalone VM for Development good enough?

I'm building a VM for SP 2013 development. Will be developing Solutions, WebParts, Custom forms, Dataviews, Business Data Connectivity, Custom Fields, inline Jquery, SSRS reports for deployment into ...
3
votes
1answer
526 views

Why are web part connections in a template breaking?

We have a SharePoint site that we created based on a blank site template. We add lists, pages, webparts (including some connected web parts) and then save this site as a template (.wsp file). We ...
0
votes
1answer
151 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 ...
1
vote
1answer
734 views

SSRS SharePoint Integration on 2 Computer Deployment

I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this: My setup consists of a ...
1
vote
1answer
677 views

Service accounts for database connection

We have a SharePoint web application with multiple site collections under that. We have built a new site which will be hosted under the same web application but in a new site collection. It has some ...
1
vote
1answer
2k views

Ordering Stacked Column Chart Series SSRS 2008

I am working with SQL Server Reporting 2008. I have a stacked column chart.There are around 8-10 series stacked on each other. I want my series to come in a defined order from Top to bottom. I have ...
2
votes
1answer
862 views

SharePoint 2010 and SSRS 2012 Setup and Licensing

I am trying to setup SSRS 2012 in Integrated Mode so that I can attach my SharePoint to it. The issue that I am having is that it seems like Microsoft removed integrated mode and switch to using ...
2
votes
1answer
1k views

Adding Report Viewer Control on Custom Web Part ASCX Control

I am trying to use Report Viewer control in one of my custom web part (on ascx) of SP 2010. As I drop the report viewer control on my ascx it register its assembly on top with assembly version ...
2
votes
2answers
42 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 ...
2
votes
1answer
111 views

Moving reports from sharepoint 2007 to 2010

I currently have both a sharepoint 2007 farm and a sharepoint 2010 farm, both have an SSRS server. I need to move the reports from SP 2007 to SP 2010 and I'm not sure how to do this easily.
1
vote
1answer
226 views

SharePoint2010 configured with Win, FBA and SSRS with Integrated,reports working fine but after enable the anonymous subsite reports are not working

Site Details SharePoint web application Enable Windows Authentication with NTLM Enable FBA(With appropriate setting) Reporting Services with Integrated Mode Reports configured with Trusted Account ...
0
votes
3answers
541 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
766 views

SharePoint 2010 Reporting Services Integrated Mode error on client

I am examine the different possibilities of SharePoint & Reporting Services Native Mode vs. Integrated Mode. So i set up an environment with both possibilities. I have a SharePoint farm with ...
0
votes
2answers
120 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
5
votes
2answers
2k views

Missing SSRS Web Services Directory

So the SQL Reporting Services Service Application is running, but from Central Administration, when I click on the service, then click "System Settings", it returns an error. Digging through ...
1
vote
0answers
73 views

Hide report builder link on Report Services Report Explorer web part

Is it possible to hide the "Report Builder" link that is displayed in the upper right hand corner of the Report Explorer web part? This is on SharePoint Services 3.0
1
vote
0answers
592 views

How to get current Login User Name from sharepoint in SSRS report instead of the SSRS report user name show the serviceAccount name

Currently when run SSRS in development, the user name is show correctly. But, once deploy it to sharepoint, the user name become static which means it keep display service Account name and not the ...
0
votes
0answers
707 views

passing url query string parameters to SSRS Report in SharePoint 2007 integrated mode

Is there some trick to doing this? Most guides suggest I just add the parameter to the url address, but that does not see to work. Is this a SharePoint 2007 issue?
0
votes
1answer
596 views

Upgrade failed: SQL 2008 R2 SSRS (SharePoint Integrated) to SQL 2012

I upgraded a SharePoint-integrated SQL 2008 R2 SSRS server to SQL 2012 SSRS over the weekend. The installer said that the installation succeeded, but it appears that the SSRS database upgrade* may ...
3
votes
1answer
4k views

Programmatically set data source link for SSRS Report files

I have a scenario where I export/import a site collection with the Content Deployment Wizard. The problem is that all Reporting Services (SQL Server 2008 R2) reports (all located in the same document ...
0
votes
0answers
576 views

Bind parameters to my custom reportviewerwebpart and refresh it

I'll try to explain my problem in the easiest way I can, since even for me it is difficult to understand. I've created a custom web part in which I have two columns: a datalist and a few buttons on ...
0
votes
1answer
266 views

Reporting Services Subscriptions doesn't fire Event Receivers

I have a SPItemEventReceiver on a SharePoint library which renames added files. Normally this works fine (Upload from website / WebDav). There is also a report server subscription which drops pdf's ...