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

CAML query reporting services, date field

I am using reporting service to query (with CAML) a list on SharePoint. The list has an external content type, my problem is that just the Date field is not rendered fine. This is my result: ...
0
votes
0answers
5 views

Reporting server issue - external content type list

I created a new report with Report Builder, it is working fine into the client but when I open it in SharePoint I get this error: The shim execution failed unexpectedly - Proxy creation failed. ...
0
votes
1answer
17 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

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

Connect to Report Server from SharePoint 2010 in Native Mode

I have a SharePoint 2010 installation in Native mode. As per company rules, I cannot have Integrated mode for this solution. I need to connect to a report server containing SSRS reports so that I can ...
0
votes
1answer
10 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
28 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
0answers
22 views

SharePoint Foundation 2013 - report / chart / Graph for Employee vacation

In SharePoint Foundation 2013 I want to create a report / chart / Graph for Employee (Employee Id,Employee Name & Department) which will show month wise from which date to which date Employee are ...
0
votes
0answers
36 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 ...
0
votes
0answers
5 views

SharePoint 2010 Integrated Mode Reporting Services 2008 Subscriptions

I have some trouble with reporting services 2008 subscriptions. Notifications table has about 1500 records and getting bigger. 1500 is not a big deal but count is not decreasing. I need to find the ...
0
votes
0answers
14 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 ...
2
votes
1answer
59 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 ...
1
vote
0answers
30 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
35 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
0answers
55 views

KRB_ERROR KDC_ERR_BADOPTION (13) for MSOLAPDisco.3

Anyone encountered the KDC_ERR_BADOPTION (13) Kerberos error for the MSOLAPDisco.3 SPN (SQL Server Browser)? Couldn't find any resources related to it. What misconfiguration (or missing ...
-2
votes
1answer
80 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
0answers
9 views

Determine Correct Item URL for Report Library

I am creating a webpart that displays list items from a Report Center that contains both .xlsx files and .rdl files. When I view the .xslx files in the standard SharePoint list webpart it opens them ...
0
votes
0answers
42 views

Migrated Content from 2010 from 2013, reporting services

I just migrated a site collection with reporting services feature deactivated from SharePoint 2010 to SharePoint 2013 where in my 2010 environment, reporting services 2008 were present. In our new ...
0
votes
0answers
31 views

Error while uploading SSRS Reports to SharePoint Report Library

I am having a SSRS Server running in SharePoint integrated mode and I am running reports in SharePoint successfully, but I am facing issue with one site as shown below. I am getting below error while ...
0
votes
0answers
104 views

Reporting Server Integration Feature will not be activated

I have very odd problem with Reporting Server Integration Feature. I have developed SharePoint Web Template. I have used Windows Server 2008R2 for developing and I have tested that my solution works ...
0
votes
0answers
29 views

Data Alert menu option missing from SSRS report

I have an SSRS report and I want to put a Data Alert on it, but the menu option isn't available. The menu option is selected for the webpart, and it's a shared data source with stored credentials. ...
0
votes
0answers
16 views

SSRS 2012 configuration issue

My client has a very strange SSRS issue. When I click on "System Settings" in the SSRS service application management I get an 503 (server Unavailable) error even though the service is running. The ...
0
votes
0answers
40 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
116 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 ...
1
vote
2answers
691 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
248 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
98 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
67 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
320 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
48 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
26 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
39 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
166 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
55 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
671 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
159 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
686 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
2answers
70 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
110 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
32 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
112 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
40 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
51 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
1answer
47 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
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 ...
1
vote
1answer
557 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
53 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
59 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
94 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
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 ...