Charles Allen demonstrates Creating SSRS Reports Using Common Table Expressions
Creating SSRS Reports Using Common Table Expressions | Dynamics GP Insights
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.