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
2answers
127 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 ...
2
votes
0answers
62 views

Issue with SSRS Loading Report from Definition From Assembly

I am using SharePoint 2010. I created web-part where there is report viewer control. On the page load of the control. I am writing below codes to load report from definition. Web part is not giving ...
1
vote
0answers
133 views

SSRS report on sharepoint becomes blank when clicking back

We're displaying SSRS reports using report viewer webpart. On Internet Explorer, we face a quite strange problem. Normally, reports display just fine. However, sometimes (yes, sometimes, not always), ...
1
vote
0answers
106 views

SSRS 2012 .rdl exposed in aspx page hosted as a web part in SharePoint Online 2013

From what I've read, there's no standard option for adding SSRS 2012 reports to SharePoint Online 2013. Instead, would it be possible to expose a report rdl in an aspx page hosted in SharePoint Online ...
0
votes
1answer
322 views

How can I have SSRS report subscriptions go to a SharePoint folder when not in integrated mode?

I am using SSRS with SQL 2012, and have SharePoint 2010. SSRS is not in SP integrated mode. I would like to create a subscription to send reports to a SharePoint folder. When I use the web path ...
2
votes
1answer
246 views

How to Pass parameters from Javascript Client Object Model to Report Viewer Web Part?

I have some SQL Server Reporting Services (SSRS) reports that take parameters. I am displaying these reports via the SSRS Report Viewer Web part on a site page. I have the parameters that are needed ...
0
votes
1answer
94 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
132 views

sharepoint and ssrs report error with xml datasource

I have a sharepoint 2013 farm with sql server 2012 installed in sharepoint integrated mode. reporting service is running on web front end server. I create reports that contains data sources from sql ...
1
vote
2answers
247 views

Font symbol (Wingdings3) not working within SSRS ReportViewer Webpart

We have an SSRS report that uses the Wingdings3 font for rendering arrow signs in a table. In the SSRS Preview pane, the table renders fine: However, on the Sharepoint page where the report is ...
2
votes
3answers
411 views

Two different versions of RSViewerPage.aspx on same farm?

I have a SharePoint 2013 farm with SSRS. On this farm, I have two web-apps (A and B). When we created web-app "A", we made some branding customizations to the RSViewerPage.aspx page. The problem is ...
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
3answers
4k views

Why '401: unauthorized' when configuring ssrs in integration mode?

I'm trying to setup SSRS in integration mode, but when I attempt to navigate to 'reporting services' -> 'set server defaults' in sharepoint central administration I get the following error: An ...
0
votes
0answers
192 views

The SharePoint list query is not valid: The required root XML element <RSSharePointList> is missing from the query

I'm trying to query Sharepoint Lists from Lists.asmx. But when inject my CAML query into Query designer it returns me the following error: The SharePoint list query is not valid: The required ...
0
votes
0answers
174 views

sql server reporting services web url not getting resolved

I have installed "sql reporting services in sharepoing integrated mode" on my SharePoint dev server.I have set the service account for the reporting services to be my admin/farm account . The ...
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 ...
0
votes
1answer
217 views

Print report button missing on embedded Report Viewer Web Part

The print button is missing on my report viewer web part. When I try to configure the web part in Site Settings -> Galleries -> Web Parts (ReportViewer.dwp) to see if I can somehow re-enable showing ...
0
votes
0answers
144 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
0answers
66 views

Can I use sharepoint survey list as a datasource in SSRS

I would like to build a report based on a SharePoint survey list using SSRS. But when I try to add the survey list URL it doesn't work. Any ideas, and how can I build a report from the data? Cheers ...
2
votes
1answer
35 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 ...
2
votes
0answers
93 views

What is the ConsumerConnectionPointID to use when adding an SSRS Report Viewer Web part declaratively?

I'm having trouble connecting my custom web part to my report viewer web part when using XML markup. My custom web part implements ITransformableFilterValues, so in order to pass values to the SSRS ...
0
votes
0answers
27 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
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 ...
0
votes
0answers
45 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 ...
1
vote
0answers
99 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
0answers
270 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 ...
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 ...
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 ...
2
votes
1answer
73 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
100 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
48 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 ...
0
votes
1answer
354 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
621 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
34 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
126 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
86 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 ...
4
votes
1answer
511 views

SSRS Managing parameters default value different behavior 2007 to 2010

Issue: After uploading a SSRS 2008 R2 RDL to SharePoint 2010, a listing of possible values of a query based parameter is not populated into a dropdown list next to the “use this value” radio button ...
0
votes
0answers
14 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
1answer
61 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
72 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 ...
1
vote
1answer
279 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 ...
1
vote
0answers
63 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 ...
0
votes
0answers
68 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 ...
0
votes
1answer
106 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
461 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
208 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 ...
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 ...
1
vote
0answers
163 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
114 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
43 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
131 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 ...