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

Updated contents of SSRS reports on SP 2013

hoping you must be fit and fine... i want to ask one question regarding SQL Server Reporting Services Reports that has been deployed on SP 2013. i have a BI machine that consists of SQL Server ...
0
votes
0answers
89 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
1answer
215 views

SharePoint 2010 Reporting Services Integration Set Server Defaults Error

We are using one FrontEnd server and one DataBase server on our current farm with reporting services integration. We need to change your farm to on FrontEnd server, one Application server and one ...
0
votes
0answers
358 views

Getting “Report Server has encountered a SharePoint error. (rsSharePointError) User cannot be found” error

I am getting "Report Server has encountered a SharePoint error. (rsSharePointError) User cannot be found." error while opening SSRS report on SharePoint site. Getting this error only for few ...
1
vote
0answers
29 views

sharepoint ssrs report get query strings

I have a reporting service in sharepoint integrated mode. How could I get report parameters via query strings? please explain it with some examples! Thanks a lot in advanced!
0
votes
1answer
96 views

Connecting with SSRS using XML Data Source leads to 401 Unauthorized

I am currently working on Report Builder 2.0 with Reporting Services 2008 and am trying to connect to a SharePoint 2013 site using an XML data source query. SharePoint and Report Builder/Services are ...
1
vote
0answers
65 views

SSRS Report Designer and SharePoint 2010 Mixed-mode Authentication

We have a SharePoint 2010 installation that connects to a SQL Server 2008 R2 reporting server which is running in SharePoint Integrated Mode. Initially, our web application was using Classic Mode ...
4
votes
1answer
412 views

SSRS Managing parameters default value different behavior 2007 to 2010

Issue: After uploading a SSRS 2008 R2 RDL to SharePoint 2010, a listing of possible values of a query based parameter is not populated into a dropdown list next to the “use this value” radio button ...
0
votes
0answers
12 views

Multiple Reporting in SharePoint from excel files

My requirement is: data comes from many sites and gets stored in the excel file say in 14 tables. From here onwards multiple reports should be generated. How to do this in SharePoint?
1
vote
1answer
50 views

SharePoint Reporting Services NLB Configuration Problems with Routing

I have a problem with Reporting Service Integration on my environment. We have 2 WFE's. Reporting services is configured on both. However, on the SharePoint Central Admin under reporting services ...
1
vote
1answer
59 views

SSRS Intermittant Exceptions

Someone assisted me this morning with one issue related to Reporting Services in SharePoint Integrated mode: SharePoint Reporting Services - NLB issue Now I seem to have another issue. The post ...
1
vote
1answer
149 views

How to create sharepoint 2013 statistical reports in SSRS?

I wanna to create statistical reports for my sharepoint sites in SSRS. My sharepoint farm is 2013. for wxample I try to create reports about how many user login in every site today, or last week, … or ...
1
vote
0answers
56 views

No email attachments to Document library when using data driven subscriptions

We have recently migrated to SharePoint 2013 and setup document libraries to publish reports to. When we send an email with an attachment to the document library from a users mailbox, the document ...
0
votes
0answers
48 views

Track User through reporting in SharePoint 2010

Is there a way to track what users and the number of times they click on a specific link in SharePoint 2010? The goal is to maintain an anounomous survey, so we dont want to attach the responses to a ...
0
votes
1answer
90 views

SharePoint Reporting Services - NLB issue

I have a problem which I suspect is due to incorrectly configured NLBs. Scneario: 2 Web front end servers: SERVER01, SERVER02 SQL Reporting Services (SharePoint Integrated Mode) is installed ON ...
0
votes
1answer
248 views

New SQL Server Report Data Source Type

I am trying to create a Report Data Source to connect a traditional relational database for reporting. The connection is successful but when I try to create a Power View report, it gives me an error ...
0
votes
1answer
285 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
159 views

SSRS add 2 date time Fields

I have 2 datetime Fields in SSRS and I am summing both of them like: =TimeSpan.FromTicks(sum(Fields!Logout_Time.Value-Fields!Login_Time.Value)). The output is correct but is in hh:mm:ss format, I ...
0
votes
0answers
41 views

Generating a report of all checked-out documents?

I was wondering if it would be possible to get a report of all documents which are checked out and to whom they are checked out too. Other metadata would be useful but not important. I've found many ...
1
vote
0answers
75 views

Anonymous proxy authentication

So I was just reading How to set Anonymous User as a Specific User and I am not sure exactly how to implement and if it will fully cover my situation. I am trying to tunnel users from Salesforce into ...
0
votes
0answers
150 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 ...
1
vote
0answers
108 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
73 views

SSRS reports deployment in production server

We have 50 SSRS report created in SharePoint 2010 integrated mode. Now we want to move these 50 SSRS reports to production server. Do we need to create script for this deployment (of report in ...
0
votes
0answers
31 views

Change bar color or highlight label in X-axis based on formula

Can we change the color of bars based on expression formula or can we highlight the x-axis label (Project Names) based on expression formula. I want to change or highlight red color if Actual Cost > ...
0
votes
1answer
30 views

How is SSRS report Deployed to remote server in SharePoint 2010

How is SSRS report deployed in the remote production server where there will be no connection between prod/ staging & production server? you can only send some staff to prod server. What are the ...
0
votes
0answers
35 views

SharePoint 2010 Reporting solution possible

here is what I want to achieve if possible CA (Top leve site) Reporting (site) 1. Sales North -- TeamA Manager ...
0
votes
1answer
83 views

Unable to view SQL RS Services on Server or add new SQL Service Application

I have the following SharePoint 2010 Environment: 2 - WFE 3 - SharePoint Application Servers 1 - SharePoint Database Server with 2008R2 One of the Application Servers has SQL2012 SP1 installed ...
0
votes
0answers
54 views

Report against a Forms Library containg folders using Report Builder 3.0

I need to create a report against a forms library conteining infopath forms with several promoted fields. The forms are stored in sub-folders. The query against the forms lib always return the top ...
1
vote
1answer
34 views

automate reporting, create a separate report for every instance in a report via the schedule manager

is it possible to create a separate report for every instance in a report via the schedule manager in sharepoint? If not what other way is there? Thanks for your help
2
votes
2answers
589 views

SSRS ReportViewerWebPart Height Issue

I am working with a customized page that has an embedded ReportViewerWebPart inside of a content tag. In this case, it's inside of "PlaceHolderMain". It looks like this: <asp:Content ...
0
votes
0answers
33 views

Can Report Builder 3.0 be used to deploy and maintain SSRS reports hosted on SharePoint 2007?

Can Report Builder 3.0 be used to deploy and maintain SSRS reports hosted on SharePoint 2007? If so, Report Builder 3.0 does not let me create a Data Source until I specify a report server, but the ...
5
votes
1answer
231 views

Using SharePoint UserAccountDirectoryPath with SSRS

I've got a SharePoint 2010 Enterprise multi-tenant setup integrated with a new SSRS 2008 R2 instance in SharePoint-Integrated mode and have FINALLY managed to get everything working. However, there ...
0
votes
1answer
336 views

Set SSRS Report Parameter Through JavaScript

I am running SSRS 2008 in SP2010. I want to set some report parameters through JavaScript. Is it possible if yes then how. Basically I read some values from the page itself and then set the report ...
1
vote
1answer
53 views

Is SSRS Required to use Report Builder 3.0

Do I need SQL Server Reporting Services configured to create reports against SharePoint 2010 Lists using Report Builder 3.0 ? I see that I can download an individual installer. Bismarck
2
votes
0answers
103 views

Package and Deploy SSRS Reports / Datasets etc

I have a VS report solution that contains around 40 reports as well as the child reports, sub reports, shared data sets, and data sources. How do I package these for SharePoint to deploy as a managed ...
0
votes
1answer
138 views

InfoPath 2013 to replace formated SSRS reports of Single SharePoint List items?

New to Infopath. Can we natually and easily use Infopath 2013 to do the following with SharePoint: Format SharePoint List Data on a sharePoint WebPart web page for a single SP List item (determined ...
0
votes
1answer
962 views

SSRS Parameters passed through URL not refreshed on Web Part Page

My working environment is SSRS 2008 and SharePoint 2010.I have a report with parameters running in SP 2010. I call my report page in SP 2010 from a page with all the parameters in query string. On the ...
0
votes
0answers
90 views

Deploying SSRS report from BIDS to SharePoint 2010

I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
251 views

Is it possible to use Powerview with SharePoint 2010 SP1 on SQL Server 2008 R2

I have a SharePoint 2010 SP1 environment configured over SQL Server2008 R2. I have an Analysis Server running on a separate physical server which is also SQL 2k8 R2. I want to create a powerview ...
0
votes
1answer
29 views

SharePoint 2010: How to determine in what mode SQL Server Reporting Services is installed

SharePoint 2010 Standard farm. How can I determine in what mode the SQL Server Reporting Services is installed? When installing SQL Server Reporting Services (SSRS), you must choose the mode in ...
0
votes
0answers
180 views

Convert Local Time (SSRS datetime parameter) to UTC Time

I am working with SSRS 2008 and SP 2010. My report has 2 parameters 1. TimeZone this parameter is read from SharePoint site (timezone of the site as per regional settings) the other is simple datetime ...
1
vote
1answer
210 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
0
votes
0answers
115 views

SharePoint 2010 multiple report viewer webparts - very slow

I have 7 report viewer webparts on one SharePoint page. It takes ages to load all of them, if I open the RDL directly, the report loads within 2 seconds. If I remove 6 web parts (thus, only 1 web part ...
0
votes
0answers
57 views

PerformancePoint data source from Oracle

I have a requirement to create KPI and dashboard for which all data comes from Oracle. I am looking for getting this data into PerformancePoint to create KPIs.. Can anybody point me to the right ...
0
votes
2answers
348 views

SSRS 2008 R2 Querystring parameters Sharepoint Integrated Mode

I’m trying to run a report via the following url: http://portal/dashboards/hr/reports/_vti_bin/ReportServer?http://portal/dashboards/hr/reports/reports/Test.rdl However, I get a 401 Unauthorised ...
1
vote
1answer
379 views

Calling Reporting Services API from SharePoint 2013 application page

While upgrading from SharePoint 2010 to 2013 I am facing the following problem. I have an application page, from which an SSRS API call is made to get all subscriptions for a report. ...
0
votes
1answer
234 views

Join multiple lists using XML web service

Implement a new XML web service, in the web service, use the SharePoint API to merge or join two or more list. Then, in SSRS, retrieve data from the XML web service using XML data source type. ...
1
vote
1answer
140 views

SharePoint, LINQ & Reporting Services Tools

I'm new to SP and SSRS, so I want to check if my thoughts are correct. Report Builder and BIDS suck on data retrieval so I have to go deeper using code. Is it possible to write some code in C# using ...
1
vote
0answers
168 views

“Actions” menu hidden in Report Viewer web part?

The Actions menu which allows for export to excel, pdf and other functions is hidden in all of my report viewer web parts. I did try to browse to the web part galleries to see if I can set it up ...
0
votes
1answer
891 views

Reporting Services Error after Content database restoration

I have migrated two web application content databases to from one SharePoint 2010 farm to another. Reporting services seems to work fine on one of the web application. http://webapp1/sites/intranet ...