SQL Server 2005 Reporting Services Move
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?

Answer Question   |  February 11, 2011  9:12 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server

Reporting Services 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]

Answer Question   |  January 13, 2010  4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005

Grant users rights to run reports on reporting services
How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can’t – they get an error that they don’t have access to the data source.  When setting up the source, we used windows authentication.  I’ve given clearance on the website itself [...]

Answer Question   |  January 16, 2010  3:10 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL 2005

Create report using Reportingservice, from a selected record from Datagrid
Is it posible to bind the data from a record to a report, by clicking on that record in a Datagridview. Please some example code. Thanks, Matthew

Answer Question   |  May 4, 2009  4:29 PM
DataGridView, Reporting Services 2005, SSRS 2005

RPGLE Stored Proc to Reporting Services
Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message “low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

Answer Question   |  July 3, 2009  10:21 PM
Reporting Services 2005, RPGLE, SQL stored procedures, SQLRPGLE

Field data in Footer SSRS 2005
I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.

Answer Question   |  March 26, 2009  10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting

ReportServerService restarting after app domain cant unload
SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR: Unable to unload app domain, terminating process and the ReportServerService [...]

Answer Question   |  November 20, 2008  9:14 PM
Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS reports

SSRS Memory Performance
Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions (some quite long running) and we are running [...]

Answer Question   |  December 2, 2008  9:03 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS Errors, SSRS Performance, SSRS reports

DrawBacks of SSRS
Hi I was asked this question in an interview?Please anyone help on it… 1)What are the drawbacks of SSRS? or What are the problems faced in SSRS?

Answer Question   |  July 30, 2008  3:24 PM
Reporting Services 2005, SSRS

Exporting large files in Reporting Services 2005
Reporting Services 2003 uses a lot of memory for the Excel Export, making it impossible for files 15 MB or larger. Is this still an issue in Reporting Services 2005 or above?

Answer Question   |  June 13, 2008  6:22 PM
Memory management, Microsoft Excel, Reporting Services 2003, Reporting Services 2005

importing into Reporting Services 2005
Can Excel SS or anything besides an Access.mdb be imported into Reporting Services 2005

Answer Question   |  February 1, 2008  7:17 PM
Reporting Services 2005