If you are in the construction industry, chances are that your business uses ViewPoint Software for Accounting, ERP, Project Management and/or Field Management.
One of many strengths that ViewPoint Software offers is that it comes with powerful precanned reports for invoicing, purchase orders, project management, financials and more.
Archives for December 2017
How To Send SQL Query Results To Email
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.