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

How To Roll Up Tasks Using SQL Reporting Services (Report Builder 3.0)

I have a site structure in SharePoint 2010 where there is a top level site collection and hundreds of sub sites below that top level. The same lists exist in each of those sub sites e.g. task lists, ...
0
votes
0answers
32 views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
0
votes
0answers
38 views

SharePoint 2013 SP1 Installation Issue- SSRS Content Type Missing for New SC

Recently I have Installed SharePoint SP1 (15.0.4571.1502) I have Create a New Web application and SC with BI Center Template. Activated the Report Server integration feature and deployed PowerPivot ...
0
votes
1answer
52 views

SharePoint SSRS Report in iFrame

How can I display an SSRS Report in an iFrame? Is there some setting somewhere to enable the content to be viewed? I know bing allows their page to be viewed in an iFrame, whereas google does not. ...
0
votes
0answers
25 views

SharePoint 2010 SSRS Export menu does not show any options

Actions -> Export menu does not show any sub-option in the SSRS Report Viewer Webpart. Environment: SP2010 (SQL Server 2008 R2, SSRS integrated mode) Browser: IE9 Master Page has this meta tag: ...
1
vote
0answers
21 views

SharePoint 2013 Reporting Service Integration mode

I face a difficult problem that I don't understand. What I have: SharePoint 2013 Enterprise SQL Server 2012 with all installed SP features, but configured in NATIVE mode. Both on the same server ...
4
votes
5answers
216 views

Report Server Sharepoint 2013 Errors

We have Report server services in SharePoint Integrated mode and it was working up until last week but now when ever we are trying to open a report or data source we are getting the below error ...
0
votes
1answer
18 views

Adding SSRS to Farm…Do I need to install Project Server onto instance?

We have a Sharepoint farm with four servers: Admin WFE Search Workflow We installed Project onto the farm and are looking to install SSRS into the farm on its own server. As part of getting the ...
0
votes
0answers
15 views

Select Max value records group by field

looking for CAML query to select records max value group by filed example: pid name value 1 abc 1 1 xer 2 1 wer 3 2 rer 1 2 wew 2 2 wew 4 I ...
1
vote
0answers
25 views

Reporting Services Webparts not Available in SharePoint Designer 2010

Firstly, I work as a DBA and have very limited understanding about how everything hangs together in SharePoint, so apologies if this is something pretty basic. We have just recently upgraded our WSS ...
1
vote
1answer
59 views

ReportViewer.dwp not working - Session state has been disabled

I'm getting this error while try to open ReportViewer.dwp: Message : Name=Request (GET:http://xxxxxxxx/_layouts/WPPrevw.aspx?ID=64) Message : Site=/ Message : Leaving Monitored Scope ...
0
votes
0answers
24 views

Set Permmision to SSRS report Programmatically

I like to get all SSRS reports in my custom web part and set Permission to specific User for specific Report. How to list out all reports and set their permissions programmatically?
0
votes
2answers
98 views

Display SSRS reports in SharePoint custom webpart

I would like to display SSRS reports in my custom WebPart. I would also like to set the permissions to particular AD user for accessing those reports. How can I do it programmatically?
0
votes
0answers
60 views

Query String (URL) Filter - show different SSRS reports for different parameter values

Is there a way that I can display different SSRS Report for different URL parameter? I have a URL parameter TestGroupID and I want the SSRS Report Viewer web part to show different report for ...
0
votes
0answers
106 views

SSRS SharePoint Integrated Mode: The status code returned from the server was: 12019

I am running SSRS in SharePoint Integrated Mode and just recently started receiving the following error message when viewing a long-running report: ...
0
votes
1answer
35 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
0
votes
1answer
45 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
17 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
64 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
37 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
12 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 ...
0
votes
0answers
37 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 ...
1
vote
0answers
31 views

Dates returned as #error in SRSS report from SharePoint list

I have connected an SRSS report (in SQL Reporting Services 2012) to a SharePoint 2013 list. Date fields all return #error, but other fields return data successfully. May query looks like this: ...
0
votes
0answers
10 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
1answer
188 views

Is it possible to view/edit SSRS datasets from sharepoint?

I have a bunch of 'shared datasets' on my old report server and I want to copy them to a Sharepoint document library. I'm running SSRS integrated mode in Sharepoint 2013 and I've already created my ...
0
votes
0answers
36 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
28 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
67 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
0answers
28 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 ...
0
votes
0answers
120 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
105 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 ...
2
votes
2answers
234 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. ---> ...
1
vote
1answer
68 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 ...
1
vote
1answer
168 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 ...
0
votes
1answer
57 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, ...
1
vote
1answer
248 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 ...
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
134 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
2answers
425 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 ...
2
votes
1answer
37 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 ...
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
328 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
248 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
194 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
175 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
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 ...
2
votes
0answers
105 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. ---> ...