Creating Audit Trail Report Templates
SQL Server lets you create templates to fit your reporting needs. (For more information about SQL report templates, see the SQL Server documentation.) CCF provides an example of an audit report in a file called AuditTrailReports.sln. The solution file is in the folder at the location <InstallDir>\Program Files\Microsoft CCF 2009\Source Code\CcfAuditReports. The following figure shows the solution file displaying one of the report templates—Agent Login Summary Report.rdl—open and ready for editing.
Sample audit report template