Microsoft SQL Reporting Services Questions

1

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
asked by:
85 pts.

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
asked by:
45 pts.

“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
asked by:
60 pts.

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
asked by:
MJT
20 pts.

1