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 ...
6
votes
2answers
1k views
Performance Issues using SQL Server Reporting Services in SharePoint Integrated Mode [closed]
Does anyone have experience with the following issue? Are there any known workarounds?
Official MS Statement: General overhead performance differences when you view reports in SharePoint integrated ...
5
votes
3answers
2k views
Not able to deploy report to SharePoint 2010 in integrated mode
I am running SharePoint 2010 Enterprise with 2 servers in the farm (SharePoint and db server). They are both running windows server 2008 R2 and the SQL Server is also R2. I have installed the ...
5
votes
1answer
94 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 ...
4
votes
2answers
491 views
Missing SSRS Web Services Directory
So the SQL Reporting Services Service Application is running, but from Central Administration, when I click on the service, then click "System Settings", it returns an error.
Digging through ...
4
votes
1answer
1k views
Reporting Services, get data from any Sharepoint List
I am trying to build an SSRS (2008R2) report based on a Sharepoint (2010) List.
The main problem is that the List on which the report will run has to be a report parameter.I know what the list ...
3
votes
1answer
784 views
Connecting Web Parts across pages in SharePoint Designer
I am trying to connect some web parts across different pages (in the same site) and the behavior I am seeing doesn't make sense to me. I think I am missing something in my understanding.
I am using ...
3
votes
1answer
146 views
Why are web part connections in a template breaking?
We have a SharePoint site that we created based on a blank site template.
We add lists, pages, webparts (including some connected web parts) and then save this site as a template (.wsp file).
We ...
3
votes
1answer
330 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 ...
2
votes
2answers
25 views
Where to Install Reporting Service
To use Reporting Service integrated with SharePoint, where to install Reporting Service?
Suppose that SharePoint env. has two physcical servers: application and database server.
Should reporting ...
2
votes
1answer
252 views
SharePoint 2010 and SSRS 2012 Setup and Licensing
I am trying to setup SSRS 2012 in Integrated Mode so that I can attach my SharePoint to it. The issue that I am having is that it seems like Microsoft removed integrated mode and switch to using ...
2
votes
1answer
2k views
Create reports from SharePoint lists
We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
2
votes
2answers
326 views
Why am I receiving an error when trying to view a report in the report viewer webpart?
I am having trouble viewing reports in our company's SharePoint site using the report viewer webpart. Here are the version details: SSRS 2008, MOSS 2007, IE9, Win 7 32-bit. I can view the Sharepoint ...
2
votes
1answer
355 views
Connect all SSRS Reports in SharePoint library to DataSource using Powershell
We are migrating MOSS to SP2010 and have a library with hundreds of SSRS reports that use a Shared DataSource (in SharePoint Integrated mode.) Since the ReportServer database location has also ...
2
votes
2answers
388 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 ...
2
votes
1answer
2k views
Sharepoint 2007 Create Reports
I'm really new to sharepoint and I'm using sharepoint 2007.
I need to create reports from the document libraries and lists. But i don't know how to do it.
In a forum I saw I have to use "Reporting ...
2
votes
3answers
696 views
Is the Reporting Services Integration for SharePoint 2007 Really Worth the Effort?
I have had nothing but frustration with MOSS 2007 SP2 + SharePoint Reporting Services + SQL 2005 SP2. I even followed Raju Sakthivel's guide to SSRS + SharePoint Integration , but I cannot publish a ...
2
votes
1answer
432 views
Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?
I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B).
In order to run SS Reporting Services in SharePoint ...
2
votes
1answer
1k views
Grant Database Access for Reporting Services: A connection to the computer cannot be established
On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting ...
2
votes
0answers
27 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 ...
2
votes
1answer
386 views
Adding Report Viewer Control on Custom Web Part ASCX Control
I am trying to use Report Viewer control in one of my custom web part (on ascx) of SP 2010. As I drop the report viewer control on my ascx it register its assembly on top with assembly version ...
2
votes
1answer
47 views
Moving reports from sharepoint 2007 to 2010
I currently have both a sharepoint 2007 farm and a sharepoint 2010 farm, both have an SSRS server.
I need to move the reports from SP 2007 to SP 2010 and I'm not sure how to do this easily.
2
votes
1answer
87 views
SSRS 2008 and SharePoint integrated mode - security flaw?
Here is my scenario: I've got SSRS 2008 R2 running in integrated mode with SharePoint 2010.
Everything works as expected in that I can create data sources, models (either through studio or via the ...
2
votes
1answer
181 views
Infopath, sharepoint list and SSRS
I have a challenging question from my manager.
In InfoPath/SharePoint, he is trying to capture the time spent by his team on various activities via SharePoint.
Using an infopath form, each week his ...
1
vote
2answers
619 views
Installing SSRS on the Sharepoint Box as opposed to the SQL Box?
We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases.
We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
1
vote
1answer
571 views
Get Current User in a Reporting integrated in SharePoint
I have a SharePoint 2010 with Reporting Services in Integrated Mode.
I would like to be able to get the current user from the report code and use it as parameter.
but when I use the ...
1
vote
2answers
101 views
Publishing Report PDFs Monthly - multiple permissions to view them
We have about 30 reports a month to publish. Each report will have a different set of security rights. (For example, office manager x should only be able to see his/her report. But there are a few ...
1
vote
1answer
115 views
SSRS SharePoint Integration on 2 Computer Deployment
I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this:
My setup consists of a ...
1
vote
3answers
413 views
How are you creating reports out of lists?
I have 2 lists I need to create reports out of including pivot like reports. What's your recommendation for doing so and still present it on a SharePoint site?
look up list
Sample List A
1 X
2 ...
1
vote
1answer
180 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.
...
1
vote
4answers
1k views
SharePoint 2013 Standalone VM for Development good enough?
I'm building a VM for SP 2013 development. Will be developing Solutions, WebParts, Custom forms, Dataviews, Business Data Connectivity, Custom Fields, inline Jquery, SSRS reports for deployment into ...
1
vote
1answer
911 views
Programmatically set data source link for SSRS Report files
I have a scenario where I export/import a site collection with the Content Deployment Wizard. The problem is that all Reporting Services (SQL Server 2008 R2) reports (all located in the same document ...
1
vote
1answer
226 views
SSRS reports not visible to all users in spite of permissions?
I have added a SSRS report to one of my department home pages and two things concern me:
It is very slow - almost a minute to render and any slicing takes a minute as well.
Reporting services ...
1
vote
2answers
6k 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 ...
1
vote
1answer
40 views
Not able to see reports in SharePoint site
I have a SharePoint site containing more than 100 reports.But i am not able to see few reports.When i browse the report it executes for 15 to 20 mins then it gives blank page with error at the bottom ...
1
vote
1answer
295 views
Deploying reports with enabled Forms Based Authentication (FBA)
Configuration:
Sharepoint 2010
Reporting Services Integrated Mode
Claims Authentication with Windows Authentication (NTML) and Forms Based Authentication Enabled
I can deploy reports from Visual ...
1
vote
1answer
3k views
The permissions granted to user 'MYDOMAIN\ryanhayes' are insufficient for performing this operation. (rsAccessDenied)
I'm getting several users getting access denied for some SSRS reports that are in a reports directory in SharePoint 2010. I have a single sharepoint group with all users in it so all users have the ...
1
vote
1answer
150 views
SSRS Report Content types available in Central Administration but not in Sharepoint Site
I am trying to get Sql Reporting Service running with Sharepoint server, and I have a two computer deployment, like example 2 on this page: http://msdn.microsoft.com/en-us/library/bb677365.aspx
...
1
vote
1answer
541 views
Reporting Services Error after doing a restore on a new farm and attempting to view a report
The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound)
The source farm reports work fine, but after the restore to a new farm, some (not all) reports get this error. Looked ...
1
vote
1answer
427 views
Why am I getting rsExecutionNotFound in SSRS integrated mode?
I'm currently setting up a SharePoint Foundation Farm with a front-end server hosting central administration (which we'll refer to as spfrontend) and a Sql Server with SSRS in SharePoint Integrated ...
1
vote
3answers
574 views
Can I download an rdl file from a SharePoint list?
I wonder if I can download an RDL file that was uploaded to a Sharepoint list. I want to upload it to our QA server, but I don't seem to find it anywhere since it was done by the developer before me.
1
vote
1answer
9 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
1
vote
1answer
18 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
1
vote
1answer
117 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>
...
1
vote
1answer
62 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
70 views
Use an Access Web Database as a data source for Excel?
I have an Access 2010 Web Database published to SharePoint as described here:
http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx
If my Access ...
1
vote
1answer
144 views
Service accounts for database connection
We have a SharePoint web application with multiple site collections under that. We have built a new site which will be hosted under the same web application but in a new site collection. It has some ...
1
vote
1answer
87 views
SharePoint2010 configured with Win, FBA and SSRS with Integrated,reports working fine but after enable the anonymous subsite reports are not working
Site Details
SharePoint web application
Enable Windows Authentication with NTLM
Enable FBA(With appropriate setting)
Reporting Services with Integrated Mode
Reports configured with Trusted Account
...
1
vote
0answers
32 views
Hide report builder link on Report Services Report Explorer web part
Is it possible to hide the "Report Builder" link that is displayed in the upper right hand corner of the Report Explorer web part?
This is on SharePoint Services 3.0
1
vote
0answers
273 views
How to get current Login User Name from sharepoint in SSRS report instead of the SSRS report user name show the serviceAccount name
Currently when run SSRS in development, the user name is show correctly. But, once deploy it to sharepoint, the user name become static which means it keep display service Account name and not the ...
1
vote
1answer
471 views
“Reporting Services” missing from SharePoint 3.0 Central Administration
Ok, I am getting into SharePoint development for my company and they have an existing installation of SharePoint that runs Reporting Services in "SharePoint integrated mode". Since I'm new to ...
