Using CTEs with SQL Reporting Services with Microsoft Dynamics GP

Christina Phillips explores Common Table Expressions (CTEs) and how they can be used to simplify selecting data for comparisons when creating SQL Reports for Microsoft Dynamics GP.  She walks through the structure of a SQL statement containing CTEs and then uses the statement to create a comparative sales report with Report Builder 3.0.