Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AnnieM
Starting Member
6 Posts |
 Posted - 2010-02-17 : 18:04:54
|
| Hi,I am looking for good reporting tools for SQL Server.Typically, I export SQL Server Management Studio query results to Excel or MS Access and create reports. I'd like to be able to use the last query result from a SQL script or procedure as the source for a report (within a reporting software). I don't know if there's a software that can do that... If necessary, I could load the query results within my SQL script/procedure to a table and use that table as the report source. But if I could avoid building more tables, that would be great! Just to note too: my queries and procedures are complex! (so I wouldn't want to create them in a reporting tool.)Functions I am looking for:- Ability to interface with SQL Server Management Studio- Not expensive, but a software that likely will still be around in 10 or so years- Ability to email reports- Ability to create a separate report for each category (as an example: for each school in our district)- Ability to easily send the report to othersThanks for any suggestions you can offer!I hope you have a good day, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Reporting tools for SQL Server