Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Calculating Qtrs on defined year Post Reply Post New Topic
Author Message
PJsFort
Newbie
Newbie
Avatar

Joined: 29 Apr 2009
Location: United States
Online Status: Offline
Posts: 6
Quote PJsFort Replybullet Topic: Calculating Qtrs on defined year
    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.
PJs Fortress
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 07 Sep 2009 at 5:08pm
What do you mean by group options?
can you provide sample data?

Jyothi
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.