controlling page breaks in a spooled SQL report
I have written a SQL report that validates many of our tables.  Only when there is an error on a table will a report of that table print.  The script contains 32 different select statements each one associated with a different table.  I need to have a page break between the reports because the tables [...]

Answer Question   |  February 1, 2010  8:50 PM
Microsoft SQL Reporting Services, SQL Reports

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

“Login Failed.”
Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit “OK” they get and error that says “Login Failed.” i am getting ERROR Message “Failed to Retrieve SQL”.What [...]

Answer Question   |  March 20, 2009  6:27 PM
Microsoft SQL Reporting Services, SQL error messages, SQL Server reporting

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