Belinda Allen has been running a series of videos on creating an FRx Rolling Quarter Report . Check out the whole series.
Belinda, the GP CSI: FRx Rolling Quarter Report
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.