Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Formula to detemine month Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Sep 2009 at 7:30pm

If you group once per month (right click on the field grou and you can chnge the look to month-year).

FOr the SUmmary it depends on your data. If you havea field per row that you need to sum:
Insert a SUmmary using that number field as a SUM reset on group footer 1.
it will be on the GF1 and show you a sum per month.
If each row is one job then insert a Summary as a Count of the Primary key of your job table reset on group 1.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Sep 2009 at 7:47pm
Note that you can use the insert SUmmary as a Count or Sum using any of the group options that were given earlier. You just have to place them ont he correct footer.
If you used a double group
Year
Month
Having the SUmmary reset at group GF1 gives you the total per year, on GF2 gives you per month (report footer for all records).
Didn't want to give the impression that you cannot get the numbers by using options Jyothi gave you earlier.
IP IP Logged
<< Prev Page  of 2
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.016 seconds.