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
3answers
16k views

Tracking and reporting in sharepoint 2010 ? user accessing what kind of data ?

I want to track How many times a particular user has accessed what document in document library?and i need to show this in a report format. Also, i need to check what are links being accessed in the ...
0
votes
0answers
16 views

Invalid URL Error when deploying rdl to SharePoint 2010

Has anyone come across the following error when trying to deploy a .rdl file onto SharePoint 2010? Report Server has encountered a SharePoint error. ---> ...
1
vote
1answer
16 views

Sharepoint reports showing up as xml

We recently installed PowerPivot into our SharePoint environment and it started causing issues with our reports(.rdl) which are now displaying as XML. Any ideas what might cause this?
0
votes
0answers
11 views

Ad-Hoc Reports in SSRS Sharepoint 2013

Is it possible to generate models in SSRS from SharePoint Lists? When trying to create Models, through Report Builder Model as SharePoint List as datasource, following error is displayed. Data ...
0
votes
0answers
17 views

How can I display remote SSRS reports

We have a new installation of SharePoint 2013 on-premis using SQL Server 2012 R2 database. We have not installed or setup SSRS in this SharePoint environment, and we hope to not have to. This ...
0
votes
0answers
7 views

Query to get name of document, which modified in given time line

I am creating the SSRS reports in Visual Studio 2008 using SharePoint 2010 list as Data source. Structure of list is: When users select the region and timeframe, it should go the associated ...
1
vote
1answer
41 views

Is there a way to log specific clicks?

I need to log when users click on specific links on our SharePoint site. Something like: bob@company.com - Clicked Special Link #1 - 02/13/2015 14:41 joe@company.com - Clicked Special Link #7 ...
0
votes
2answers
732 views

Why are Reports returning a 504 Gateway error?

I've created some reports in BIDS and uploaded the .rdl and .rds files to a SharePoint Report Library. Attempting to access the reports leads to a 504 Gateway Time-out The server didn't respond in ...
0
votes
0answers
52 views

Generate automatically SSRS reports via SharePoint Workflow

I have developed SSRS reports (.rdl) and I want when a user subscribes to a report, this one will be generated by a workflow periodically, how can i do that on SharePoint 2010 ?
0
votes
0answers
5 views

Printing Report Crashes IE - SP Integrated SSRS / SP2010

Scenario: A SharePoint 2010 Site dedicated to SSRS Reports When a user navigates to a report and clicks on the report name, the report opens fine When a user selects the "Print" option from the ...
0
votes
2answers
55 views

PerformancePoint webpart showing report from Reporting Service, but is showing cached content!

I am using sharepoint 2010. I have created some reporting service report. On some page, I have created the PerformancePoint webpart to show the reporting service report. It works and shows content. ...
0
votes
1answer
42 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
2
votes
1answer
780 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
32 views

SharePoint 2013 Workflow Reports

I created a workflow in SharePoint 2013 and would like to start collecting information on how long it takes for each task to be completed. I know of ways to build this type of data into the workflow, ...
0
votes
1answer
750 views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
0
votes
1answer
12 views

SharePoint 2013 and ReportingServices2010 CreateDataSource Example

Can anybody help me with how to use CreateDataSource with SharePoint 2013 to Create a Data Connection in C# code?
0
votes
1answer
24 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 ...
0
votes
0answers
17 views

SSRS Web Part Page - HTTP 400 Bad Request

I have several pages that have a single instance of an SSRS ReportViewer web part. Switching between pages or simply refreshing the page adds a new Reserved.ReportViewerWebPart.axd request cookie. ...
1
vote
1answer
532 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
17 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
9k 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.
0
votes
0answers
32 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: ...
-2
votes
1answer
117 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
15 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
43 views

Does SSRS 2012 requires SharePoint 2013 enterprise licensing

Just wanted to confirm whether SSRS 2012 requires SharePoint 2013 Enterprise licensing?
0
votes
0answers
14 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
2answers
45 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
15 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
1k 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 ...
0
votes
0answers
61 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 ...
1
vote
1answer
59 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
67 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
6 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 ...
2
votes
1answer
85 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
92 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
43 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
40 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
61 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
78 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 ...
0
votes
0answers
16 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
2answers
121 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
36 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
186 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
36 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
22 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
1k 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
63 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
221 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
427 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 ...