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
256 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
14k 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
393 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
362 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
973 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
125 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
130 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
1k 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
389 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
775 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
4k 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 ...
0
votes
0answers
317 views

Add ReportViewer WebPart at runtime

I am working with feature receivers in SP2010. I can successfully create web part pages and drop web part on the pages on feature activation.I was trying to add ReportViewerWeb Part (Integrated Mode) ...
1
vote
0answers
75 views

Query Fields in Sharepoint db via Report Builder

Which is the best way to build a report to display the count of all upload files of a specific group of content types, foreach site collection? Should I use the table AllDocs to create de DataSet or ...
1
vote
1answer
460 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 ...
0
votes
1answer
253 views

RS Web parts title doesn't change

After installing the RSwepart that come with SQL server 2008. I noticed that the webpart title doesn't change. After i have tried changing it from Report Explorer to something else. See them here: ...
0
votes
1answer
2k views

Where are the Sharepoint Reporting Services webpart 2010

In SP 2007 there was a RS web part -(RS explorer and RS viewer webpart). And all you need to do is just connect them. But in SP 2010 i can't seem to find a anything similar.I can only see the ...
1
vote
2answers
968 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 ...
0
votes
2answers
57 views

Reporting Server Integration with Sharepoint Server 2010

I have a Sharepoint server 2010 Enterprise in a public domain and a SQL2008 standard in a local domain (with an installation of sharepoint 2010 to support report integration). Does Microsoft support ...
1
vote
3answers
981 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.
0
votes
1answer
110 views

SharePoint 2007 integration Reporting Services 2005 having error!

Previously the reporting services in SharePoint 2007 are working fine. Suddenly it appear an error as below:- The request failed with HTTP status 401: Unauthorized. at ...
1
vote
1answer
45 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 ...
4
votes
1answer
2k 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 ...
0
votes
1answer
609 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
1answer
97 views

SSRS SharePoint Integration - Disaster recovery

I am adding a SQL Server Reporting Services in SharePoint integrated mode to an existing SharePoint 2007 farm (which has DR already). The existing DR involves duplicate servers, and the content DBs ...
5
votes
3answers
4k 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 ...
2
votes
2answers
1k views

SQL Reporting Services in SharePoint Mode Prompts for Login

Scenario: We currently have SQL Reporting Services 2008 R2 in a scale-out deployment on two servers. SSRS is configured in SharePoint integrated mode with our SharePoint 2010 servers (configured with ...
2
votes
1answer
230 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 ...
2
votes
1answer
2k 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 ...
0
votes
1answer
45 views

Lightest possible SSRS Integrated Mode machine

I am building a SharePoint 2010 farm. One machine is designated for SSRS and we will be running it in Integrated Mode. Per this document: http://msdn.microsoft.com/en-us/library/bb283190.aspx this ...
1
vote
1answer
722 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
994 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
0answers
193 views

Removing leading spaces/newlines left from unchecked Multi-Select box

I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line ...
0
votes
1answer
282 views

Sharepoint frontend and SQL 2008 (SSRS) on different servers

This is my first foray into Sharepoint (WSS 3.0) and I'm trying to get SSRS reports running on the front end Sharepoint system, whereas now they are on a different server. I am not familiar with the ...
0
votes
1answer
186 views

Items from last year not showing in SQL report builder 3.0

I created a simple report which queries data from a SharePoint 2010 custom list, the list has 10 records, 5 created in 2010 and 5 created in 2011, when I run the report, which is pretty straight ...
0
votes
3answers
3k views

How to select MAX field in CAML query

RowLimit seems not working. I'm using it in CAML query to run a SSRSreport. I have to pick the Max date for each user. i sorted the user as descending and set the RowLimit element as 1. But that does ...
1
vote
2answers
124 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 ...
0
votes
1answer
192 views

Do SharePoint 2010 and Reporting Services 2008 R2 (Integrated Mode) work together via SSL?

We want to use SQL Server 2008 R2 Reporting Services (Integrated Mode) and SharePoint 2010 in a SharePoint Farm with SSL enabled. Especially we'd like to generate reports from SharePoint lists. Is SSL ...
1
vote
1answer
235 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 ...
2
votes
2answers
528 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 ...
0
votes
1answer
2k views

Can SQL Reporting Services generate reports automatically?

I need to set up a report generation system for a SharePoint list. The report will display all items within the date range that is specified by the user with a start and end date. The requirement ...
1
vote
2answers
3k views

SharePoint 2010 and reporting services mutiple lists [closed]

I'm, looking at how to manage some lists in SharePoint 2010 and have to use SQL 2008 Reporting Services to make reports on these lists. I'm new to Reporting services and is wondering if you can make ...
6
votes
2answers
2k 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 ...
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
767 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 ...
1
vote
3answers
508 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 ...
2
votes
1answer
444 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 ...