Tips and Tricks: Calculating Qtrs on defined year

Print Page | Close Window

Calculating Qtrs on defined year

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7597
Printed Date: 18 May 2024 at 5:54am

Topic: Calculating Qtrs on defined year

Posted By: PJsFort
Subject: Calculating Qtrs on defined year
Date Posted: 04 Sep 2009 at 9:49am

Help...need direction. I need to produce a report that will calculate quarterly activity based on a fiscal or hire date year. This is a Annual Scorecard report based on start date. Using CR11.

My current report calculating the quarters by using the group options per quarter. I need a way to calculate or define the quarter based on the start date. Or remove the group options and come up with a formula that will calculate 3 months at a time to provide quarterly totals.

Is there a way to define the quarterly group option or a better way to get a quarterly sum based on the parameter of the report date. I don't know if this is possible or how to do it. Hope this makes sense. If you need more information please let me know.