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
117 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
210 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
375 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
157 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
139 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
174 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
111 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
58 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
87 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
26 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
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 ...
1
vote
0answers
93 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
232 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
68 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
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 ...
0
votes
1answer
309 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
546 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
118 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 ...
4
votes
1answer
477 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
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
1answer
57 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 ...
1
vote
1answer
229 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
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 ...
0
votes
0answers
63 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
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
388 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
191 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
0answers
44 views

Generating a report of all checked-out documents?

I was wondering if it would be possible to get a report of all documents which are checked out and to whom they are checked out too. Other metadata would be useful but not important. I've found many ...
1
vote
0answers
86 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
147 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
98 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
39 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
2
votes
2answers
685 views

SSRS ReportViewerWebPart Height Issue

I am working with a customized page that has an embedded ReportViewerWebPart inside of a content tag. In this case, it's inside of "PlaceHolderMain". It looks like this: <asp:Content ...
5
votes
1answer
265 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 ...
0
votes
1answer
413 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 ...