Reporting Services 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...

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

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?

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.

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:...

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...

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?

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?

importing into Reporting Services 2005

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