Tagged Questions

0
votes
0answers
20 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
1answer
12 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
105 views

SQL Server Reporting Services: The remote server returned an error: (500) Internal Server Error

I'm running a SharePoint 2010 Standard farm. I have 2 Web Front-end Servers, an application server running SSRS and 2 Database servers. SSRS is installed using the Microsoft SQL Server 2012 RS Add-In ...
0
votes
0answers
19 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
49 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
13 views

Report Subscriptions and YOU!

We're using SQL 2008 R2 in SharePoint Integration Mode to provide reporting functionality for our end users. I have a task to create subscriptions for all my end users to these reports, however I ...
0
votes
0answers
10 views

Limiting Report Subscription Options

We are using SharePoint Enterprise 2010 to provide reporting functionality for our sales team, using SSRS RDL files. The report's themselves work just fine, but we are going to train our sales team ...
0
votes
0answers
20 views

Share SSRS Server across two farms? Only ever using one at a time

We have two farms, one DR and LIVE. In Live we have an SSRS box, and in DR we have an SSRS box. In a scenario where the live farm dies then obviously the second farm picks it up, however in the ...
0
votes
0answers
63 views

SSRS SP Integrated Using Trusted Authentication Mode but Data Souce Using Windows Integrated

I configured our Reporting Service Integration in Central Admin to use the Trusted authentication mode. From what I understand, this mode allows a data source to run using stored credentials. I also ...
3
votes
1answer
142 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 ...
1
vote
1answer
95 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 ...
2
votes
1answer
204 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
339 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 ...
0
votes
1answer
77 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
1answer
204 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
54 views

Basic breakdown for use of SQL Reporting Services

I would like to utilize SQL Reporting Services (SQL Server 2008 R2) to generate charts based on list information within my site collection. I am looking for a basic guide on how to configure an ...
0
votes
1answer
275 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 ...
3
votes
1answer
735 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 ...
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 ...
0
votes
0answers
156 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
47 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 ...
0
votes
1answer
363 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 ...
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 ...
1
vote
1answer
203 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 ...
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 ...
0
votes
1answer
248 views

SP2010 Reporting Services 401 unauthorized for one web app but working for the others

I have deployed Reporting Services to my farm. From the application server, reporting services are working for all web apps. However, via my WFEs, I have one web app which reports 401 Unauthorized, ...
1
vote
2answers
822 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 ...
0
votes
3answers
2k 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 ...
0
votes
1answer
162 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
528 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 ...