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
2answers
485 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 ...
0
votes
0answers
345 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 ...
0
votes
0answers
347 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 ...
2
votes
0answers
203 views

Error on creating Report Model :Data extension does not support model generation

I'm trying to create a Report builder Model using a SP Custom List as Datasource. But it returns me the following error: Data extension does not support model generation. ---> ...
0
votes
1answer
700 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 ...
2
votes
3answers
816 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 ...
2
votes
0answers
163 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 ...
1
vote
1answer
12k 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
51 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
36 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
524 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
161 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
69 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
96 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
293 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
156 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
759 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
894 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
38 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
225 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
140 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
82 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
697 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
341 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, ...
1
vote
1answer
81 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
96 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
122 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
772 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 ...
1
vote
1answer
603 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
104 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
366 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
206 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
176 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
48 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
379 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
44 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
198 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
790 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
67 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
133 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
249 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 ...
2
votes
1answer
3k 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
49 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
4k 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
359 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
2k 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
579 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
179 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 ...
2
votes
2answers
4k 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
526 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. ...