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
1answer
121 views

Refused to execute script Reserved.ReportViewerControl.axd in SharePoint 2013

We are migrating our ASP.NET WebForms and MVC 3.5 Application to our new SharePoint 2013. Lots of our applications use Reporting Services which use ReportViewer Control 9.0 but when we deployed the ...
0
votes
0answers
33 views

Disable Data Alerts in Sharepoint Reporting Services

I am trying to disable the reporting services data alerts and can't seem to do so. The "New Data alert" menu option is still available whenever I go in an view a report in sharepoint. I am trying to ...
0
votes
0answers
114 views

How to set DataSource link for RDL file in SharePoint 2010 List Programatically

I have tried several solutions to set DataSource of a RDL file in SharePoint List programatically. I endedup in finding one solution but with PowerShell and doubts its working. Can anybody help me in ...
0
votes
0answers
41 views

Move SharePoint 2010 and SQL 2008 R2 Reporting Services to new server

I have a server with SQL 2008 R2 and SharePoint 2010 installed on the same box and Reporting Services is running in SharePoint Integrated mode. I'm now looking to move all of this to a new server and ...
0
votes
0answers
14 views

Reporting Service: SQL Agent Status can not be determined

I am configuring Reporting Service application on my SharePoint environment, I have installed Reporting Service SharePoint AddIn onto my Application server, when i go to Provision Subscription and ...
1
vote
2answers
1k views

Reporting Services Service Application Authentication Error?

I have "inherited" a small SharePoint farm with an App SP server and a database. The cilent wishes to use PowerView. Reporting Services seems to be configured correctly (but apparently isn't). When ...
1
vote
1answer
216 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 ...
0
votes
0answers
54 views

SharePoint postback error message on BIDS report

When deploying my report in SharePoint 2013, I got the following error message: Report parameter values must be specified before the report can be displayed. Choose parameter values in the ...
2
votes
0answers
155 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
266 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 ...
0
votes
0answers
11 views

Programatically Access 2007 report subscriptions

I am in the process of migrating some reports off SharePoint 2007 to SharePoint 2010. Is there a way that I can programmatically copy the reports so that any subscriptions stay intact? If not, then ...
0
votes
0answers
58 views

Shared Report Data Source forgets saved credentials

I have been attempting to help out a client of mine with a very bizarre SharePoint issue where the saved credentials for a shared data source disappear after a period of time. The credentials are ...
0
votes
1answer
60 views

Sharepoint and reporting services, how to reuse a report in another environment?

I see some link on a SharePoint 2010 portal. When I click on the link below I need to wait for 30 seconds and then I see some report generated and is showing in the reportviewer. It shows all items ...
0
votes
0answers
97 views

SSRS report on Page viewer Web part

I am using Office 365 to load my reports, I have added the SSRS reports on Page viewer. The filter part of the reports are displaying just fine but the Chart parts are Shrunk in a small table. How can ...
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 ...
0
votes
0answers
44 views

SharePoint 2010 Reporting Services Integration - No Report Servers Were Found

I have a 3-server farm with SharePoint 2010. There is SQL Server 2008 R2 installed on database server and SQLServer2012 installed on application server. And there is SQL Server 2008 R2 installed on ...
2
votes
2answers
362 views

SharePoint Document Library Subscription Errors

I have SSRS 2012 setup in SharePoint Integrated mode. I am receiving the following error when trying to setup a subscription to a SharePoint Document Library. A delivery error has occurred. ---> ...
0
votes
0answers
169 views

deployed .rdl exported to PDF changes URL Action hyperlinks

I have a SSRS report that is deployed into sharepoint. In this report I have a URL Action hyperlink. This hyperlink points to an edit form in sharepoint and includes two paramaters in its URL; ID and ...
1
vote
1answer
169 views

Repeating Login Prompts when deploying reports using Visual Studio 2012 BIDS

I am running SharePoint 2013 integrated with SQL Server 2012 and SSRS but I've been having problems trying to deploy my reports from Visual Studio 2012 BIDS. Whenever I enter in my login credentials ...
1
vote
1answer
430 views

SP2010 Reporting Services 401 unauthorized for one web app but working for the others

I have deployed Reporting Services to my farm. From the application server, reporting services are working for all web apps. However, via my WFEs, I have one web app which reports 401 Unauthorized, ...
1
vote
1answer
551 views

SharePoint 2013 SSRS installation problems

I am having a nightmare of a time with the SSRS/SP integration. Let me explain what I did. First, we have: 2 web front ends (WFE) 1 App server 1 DB server I installed both SSRS components (Addin ...
1
vote
1answer
87 views

List view threshold in reporting services integrated mode in sharepoint

In one of my sharepoint sites I have a document library with 7,000 document sets, if I count the files inside there are 21000 files in total. In the beginning we had some views, but when they growth ...
2
votes
1answer
45 views

Site Column as an SSRS Dataset

Is it possible to use a Site Column (Choice) type as a dataset for use in SSRS reports? I can use a combination of hidden parameters, VBA code and a list to effectively obtain a distinct list of ...
0
votes
1answer
97 views

How can I test an SSRS 2012 environment on production

I have a SharePoint 2010 site with SSRS 2008 running. I'd like to dabble with SSRS 2012 to check report compatibility, etc. Can anyone advise on how I can go about standing up an SSRS 2012 instance, ...
0
votes
1answer
254 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
403 views

Can an SSRS Report in ReportViewer web part access the URL or site name of the site hosting it?

I have several sites with pages with ReportViewer web parts on those pages. All web parts use a central report file (.rdl) in a report document library in a reports site. I would like these reports ...
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 ...
1
vote
2answers
800 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
180 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
106 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
194 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
152 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
712 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
319 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
101 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
171 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
397 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
643 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
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 ...
0
votes
3answers
5k 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
253 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
516 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
239 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
1answer
47 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
138 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
33 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
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 ...
1
vote
0answers
123 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 ...
1
vote
0answers
429 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 ...