03-15-2022, 05:54 PM
For Reports - We use SSRS - which is the reporting part of SQL Server. We run the latest version of SQL Server 2019 in-house. Reports are created / customized through Visual Studio 2019. KnightGuild reports are elaborate, with multiple sections. Each section is it's own report and all are printed by one master report. When generated, they produce a multi-page PDF file. We use that with SMTP2GO (a bulk emailer) and another program written in C# to create the reports, attach them to email messages and send them. Our process flags each report for printing so the whole thing is automatic.