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
40 views

FBA site cant open report in report builder

I have created a FBA sharepoint 2013 site. I copied some reports from another site that uses windows authentication into the new FBA site's report library. Now I would like to edit the reports using ...
0
votes
0answers
238 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
92 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 ...
1
vote
1answer
46 views

Updated contents of SSRS reports on SP 2013

hoping you must be fit and fine... i want to ask one question regarding SQL Server Reporting Services Reports that has been deployed on SP 2013. i have a BI machine that consists of SQL Server ...
2
votes
1answer
70 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
1answer
131 views

Adding Report Viewer Web Part to Default page programmatically

I am new to Sharepoint. I need to know the best way to add a ReportViewWebPart to a page through C# code behind. I have tried accessing the web part from WebPartCatalog. It leads me to the ...
1
vote
0answers
95 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
314 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 ...
0
votes
0answers
559 views

Getting “Report Server has encountered a SharePoint error. (rsSharePointError) User cannot be found” error

I am getting "Report Server has encountered a SharePoint error. (rsSharePointError) User cannot be found." error while opening SSRS report on SharePoint site. Getting this error only for few ...
1
vote
0answers
33 views

sharepoint ssrs report get query strings

I have a reporting service in sharepoint integrated mode. How could I get report parameters via query strings? please explain it with some examples! Thanks a lot in advanced!
0
votes
1answer
119 views

Connecting with SSRS using XML Data Source leads to 401 Unauthorized

I am currently working on Report Builder 2.0 with Reporting Services 2008 and am trying to connect to a SharePoint 2013 site using an XML data source query. SharePoint and Report Builder/Services are ...
1
vote
0answers
83 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 ...
0
votes
0answers
13 views

Multiple Reporting in SharePoint from excel files

My requirement is: data comes from many sites and gets stored in the excel file say in 14 tables. From here onwards multiple reports should be generated. How to do this in SharePoint?
1
vote
0answers
60 views

No email attachments to Document library when using data driven subscriptions

We have recently migrated to SharePoint 2013 and setup document libraries to publish reports to. When we send an email with an attachment to the document library from a users mailbox, the document ...
1
vote
1answer
242 views

How to create sharepoint 2013 statistical reports in SSRS?

I wanna to create statistical reports for my sharepoint sites in SSRS. My sharepoint farm is 2013. for wxample I try to create reports about how many user login in every site today, or last week, … or ...
0
votes
1answer
139 views

filtering on a multivalue choice field in Report Builder

In my List I have a Choice column that allows for multiple values via checkbox. Using Like is the only way I have found that successfully filters. Is there a better way? Also, this does not work, ...
0
votes
0answers
64 views

Track User through reporting in SharePoint 2010

Is there a way to track what users and the number of times they click on a specific link in SharePoint 2010? The goal is to maintain an anounomous survey, so we dont want to attach the responses to a ...
1
vote
1answer
58 views

SharePoint Reporting Services NLB Configuration Problems with Routing

I have a problem with Reporting Service Integration on my environment. We have 2 WFE's. Reporting services is configured on both. However, on the SharePoint Central Admin under reporting services ...
1
vote
1answer
69 views

SSRS Intermittant Exceptions

Someone assisted me this morning with one issue related to Reporting Services in SharePoint Integrated mode: SharePoint Reporting Services - NLB issue Now I seem to have another issue. The post ...
0
votes
1answer
103 views

SharePoint Reporting Services - NLB issue

I have a problem which I suspect is due to incorrectly configured NLBs. Scneario: 2 Web front end servers: SERVER01, SERVER02 SQL Reporting Services (SharePoint Integrated Mode) is installed ON ...
0
votes
1answer
399 views

New SQL Server Report Data Source Type

I am trying to create a Report Data Source to connect a traditional relational database for reporting. The connection is successful but when I try to create a Power View report, it gives me an error ...
0
votes
1answer
348 views

SharePoint 2013 Manage Reporting Services Application crashing

I had integrated reporting services working nicely, then I changed something and when I go into Manage Reporting Services Application -> System Settings this happens: Sorry, something went wrong The ...
1
vote
0answers
87 views

Anonymous proxy authentication

So I was just reading How to set Anonymous User as a Specific User and I am not sure exactly how to implement and if it will fully cover my situation. I am trying to tunnel users from Salesforce into ...
0
votes
1answer
180 views

Reports based on Lists for SharePoint online

One of our clients use SharePoint Online & uses a simple lists-based case management system. They want to receive weekly report in email based on the data in lists, preferably using configuration ...
1
vote
0answers
151 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
100 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
40 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
120 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
38 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
114 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
418 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
61 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
107 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
165 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 ...
0
votes
1answer
1k 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
35 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
1answer
194 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
404 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
259 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
128 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
2k 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
1answer
313 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
2k 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 ...
5
votes
1answer
268 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
159 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
373 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
539 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
211 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
149 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 ...