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
162 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
1k 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
1answer
35 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 ...
1
vote
1answer
254 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
128 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
2answers
529 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
439 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
308 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
159 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
208 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
1k 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 ...
1
vote
1answer
4k 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 ...
5
votes
2answers
1k 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 ...
1
vote
0answers
147 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 ...
2
votes
1answer
476 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 ...
0
votes
1answer
1k views

How to scale out Reporting Services on SharePoint Integrated Mode over NLB

I have a SharePoint 2010 Enterprise farm with the following topology :- 2 WFE SERVER (behind NLB 1) 1 APP SERVER (used for Search) 1 APP SERVER (used for other service applications) 1 DB Cluster ...
0
votes
6answers
463 views

Test drive of PerformancePoint and SSRS on SharePoint

I need to build advanced reports on SharePoint, where radars, pivots and cumulative values are involved. One obvious option is Excel Services, but I'd be interested to compare it with PerformancePoint ...
3
votes
1answer
413 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 ...
0
votes
1answer
108 views

Causes for really long page Request times?

We have a sharepoint portal running SSRS reports for our customers. The reports themselves dont take that long to render, however the page requests take over 10-15 seconds which is simply ...
1
vote
1answer
488 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
1answer
522 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
485 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 ...
2
votes
1answer
707 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
577 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
38 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
99 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.
1
vote
1answer
176 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 ...
0
votes
2answers
2k views

Sharepoint output list of users

I would like to output the users of a group, for 40 groups, or for every group within the SharePoint Portal. I would like to do this programatically through powershell or a command line tool for the ...
0
votes
1answer
107 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
3answers
422 views

Issue with SSRS and Sharepoint2010

I am adding a SQL Server Reporting Service Report Viewer Webpart onto a webpart page and i place a report generated using SSRS in the document library. I have two reports one with no parameter and one ...
2
votes
1answer
3k 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
0answers
65 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
480 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
297 views

ows_MetaInfo field including carriage returns

I have an InfoPath 2010 form promoting fields to SP 2010. Using SSRS 2008 R2, I'm pulling those fields into a report to report off of. I'm finding that some fields in the ows_MetaInfo blob have a ...
0
votes
0answers
495 views

passing url query string parameters to SSRS Report in SharePoint 2007 integrated mode

Is there some trick to doing this? Most guides suggest I just add the parameter to the url address, but that does not see to work. Is this a SharePoint 2007 issue?
0
votes
1answer
469 views

Upgrade failed: SQL 2008 R2 SSRS (SharePoint Integrated) to SQL 2012

I upgraded a SharePoint-integrated SQL 2008 R2 SSRS server to SQL 2012 SSRS over the weekend. The installer said that the installation succeeded, but it appears that the SSRS database upgrade* may ...
0
votes
0answers
529 views

Bind parameters to my custom reportviewerwebpart and refresh it

I'll try to explain my problem in the easiest way I can, since even for me it is difficult to understand. I've created a custom web part in which I have two columns: a datalist and a few buttons on ...
0
votes
1answer
242 views

Reporting Services Subscriptions doesn't fire Event Receivers

I have a SPItemEventReceiver on a SharePoint library which renames added files. Normally this works fine (Upload from website / WebDav). There is also a report server subscription which drops pdf's ...
1
vote
2answers
12k 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
1answer
370 views

Sharepoint 2010 with existing SQL Reporting Services

going through my list for things I need to prep for in my upcoming Sharepoint 2010 installation. We'll be installing SP2010 Enterprise to make use of the BI components, with the web server on it's ...
0
votes
2answers
296 views

What do I have to do prior to site creation of a “Report center” template?

I have a SSRS service installed, I have Sharepoint 2010 Enterprise Edition. As I read on the internet, I should activate the Report Server Central Administration Feature in site settings > Manage ...
1
vote
1answer
855 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 ...
0
votes
1answer
35 views

Can SSRS reports be integrated into the free version of SharePoint?

Do I have to upgrade to another edition of SharePoint to integrate SSRS reports or is SharePoint integrated mode with SSRS available with the free version of SharePoint (Sharepoint Services 3)?
2
votes
1answer
114 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 ...
0
votes
1answer
116 views

Report Toolbar in SharePoint 2010

I have a SharePoint farm using SQL Server 2008 R2 and SharePoint 2010. In my production environment, my SSRS report within a Performance Point dashboard renders with the "old school" toolbar, which is ...
3
votes
1answer
1k 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 ...
0
votes
1answer
934 views

How to find invalid character in SharePoint item value

I try to create a dataset with Reporting Services from a SharePoint list (inside the root web). When I want to build the query for the dataset I get the following error: ...
1
vote
1answer
339 views

Edit Manage Subscription Page

I have SharePoint 2010 with SSRS integrated. When I right click on a report and select Manage Subscriptions I am presented with a list of the current subscriptions. The columns are: Type, Delivery ...
0
votes
1answer
690 views

SSRS Row Limit Only With Co-Located Data/Report

I've got a 2010 farm with reporting services running in integrated mode (trusted account). On that farm, I've got a report in a site collection that queries a list with more than 2000 items. When ...
2
votes
1answer
3k 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 ...