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

Create a ReportingServices data source and upload to a data connection library

I have installed reporting services 2012 in SharePoint 2013 integrated mode. I need to create a report data source and upload it to a data connection library using C#. As I know it uses the ...
1
vote
1answer
800 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 ...
0
votes
1answer
85 views

What is the best practice to create some SSRS report to show info from a list, and show in a webpart in SP 2010?

I am using SP2010. I have a list with some important info. I would like to generate some report in SSRS. What is the best practice to create a SSRS report with the source from a SharePoint list? I ...
-2
votes
1answer
147 views

SharePoint WCF SOAP, Rest, AJAX [closed]

I need to know the following things: How is SharePoint used with WCF, REST and SOAP.
0
votes
1answer
368 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
2answers
148 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
0
votes
1answer
30 views

SharePoint reporting services integration

I am using the SharePoint report services integration. I deployed a report to a document library, but when I try to view the report (form SP), I receive this error: login failed for user 'nt ...
0
votes
2answers
4k 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
143 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: ...
1
vote
0answers
293 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
2
votes
1answer
326 views

SharePoint 2013 + Reporting Services + Kerberos

How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database? I found below blog but I'm not sure about ...
0
votes
2answers
210 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 ...
1
vote
0answers
205 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
0
votes
2answers
57 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
0
votes
2answers
130 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
0
votes
0answers
4k 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
0answers
592 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 ...
4
votes
5answers
1k 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
1k 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. ...
1
vote
0answers
197 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 ...
0
votes
1answer
121 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 ...
1
vote
0answers
99 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
666 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 ...
1
vote
2answers
4k 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
1answer
430 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 ...
1
vote
2answers
2k 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
487 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 ...
2
votes
0answers
281 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
75 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
2answers
3k 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 ...
2
votes
2answers
689 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
390 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
540 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
3k 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
106 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
70 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
158 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
555 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
836 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
3k 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
1k 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
262 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 ...
1
vote
0answers
381 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
251 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
2k 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
747 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
118 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 ...
1
vote
2answers
646 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
1k 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 ...
0
votes
3answers
6k 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 ...