SQL-Based Reporting Engine Exports How-To

The download has a sql-based reporting engine report for course enrollments and a pdf on how to modify the report. Using the reporting engine to do exports is a more powerful tool than AutoSend because you can pull from all the tables and query the database before exporting. However, you won't find any online help either in PS or on PowerSource regarding the reporting engine, so the pdf is basically a manual on sql type reporting engine reports.

The report could be used as a template for other exports. It's actually a modification of a sql-based type report that Shane Thompson posted on PSUG (his is different in that it pulls student data), so thanks to Shane for the original report that was used for the basis for this report and documentation.

4/19/2010 - uploaded original

4/27/2010 - uploaded updated version that mentions possible field types that can be used and how to create a decode statement in the reporting engine