Time by Project and Timescale Portlet – SQL

This portlet displays Actual Time by Project over a span of time.  It supports Annual, Quarterly, Monthly, and Weekly time periods.  The time span displayed is controlled by a filter field for the Start Date (of the time span) and by a filter field for the Number of Time Periods to be displayed.

There are also filters for Project name, Project Manager, and Project Type.