Matt's+Track

=Matt Freund's Sessions:=

Are you limited by the export functionality of DDE or export templates and looking for a more powerful way to do exports? Do you ever look at custom pages and wonder what the tlist_sql stuff is and how to modify it? This session will introduce you to SQL, also known as Structured Query Language. You'll learn how to use it with Oracle SQL Developer to get around the limits of PS exports, and get a basic understanding of how it works for use in custom pages and reporting engine reports.
 * Basic SQL**

If you've ever used the grades reports from sisresources.com or the birthday report from powerdatasolutions.org, then you've used a dynamic page. Dynamic pages are real time savers because just one page can fit the needs of many. Learn how these pages work, how they pass data when a create or submit button is clicked, and how to use the gpv command to use the data to create an updated page.
 * How to Build Dynamic Pages**

If you ever wanted to automate export templates or get around the limits of AutoSend, then using the reporting engine is the answer. Learn how to create an automatic export of data using the reporting engine and non-sql commands, which is useful if you're on 5.x and have lots of custom data you want to export, or you don't feel comfortable yet with SQL.
 * Reporting Engine Exports - non-SQL type**

This is similar to the non-sql session, except how to use SQL in the process will be covered. Useful Customizations Matt Have you seen customizations on the web at places like sisresources.com or powerdatasolutions.org and wondered what they do or look like but haven't had time to load them on a server? The session will showcase the most popular and useful ones available. Attendees will be able to try them and others on a test server loaded with customizations, including the custom reports bundle from powerdatasolutions.org.
 * Reporting Engine Exports - SQL type**