When it comes to report design and creation, you are spoiled for choice. You can choose from a plethora of tools such as Microsoft Access Reports, Crystal Reports and Microsoft SSRS Reports.
There are times however when these tools are too heavy and too time consuming to just, say, send SQL query results to email.
There are ways to do this that may not involve the full blown report designer such as using SQL Server’s stored procedures such as “sp_send_dbmail” however your output formats are limited and most users do not have the right access to their database systems. [Read more…]