Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Group by Month or Week Post Reply Post New Topic
Author Message
Trishuli
Newbie
Newbie


Joined: 05 Jul 2010
Online Status: Offline
Posts: 3
Quote Trishuli Replybullet Topic: Group by Month or Week
    Posted: 19 Aug 2010 at 2:54pm
Hi,

I need a formula which allows the date to be grouped monthly or weekly based on the parameter. I have tried everything and hardly found any information for date to be grouped weekly. I know there is a month(x) function to change it to month..but no WEEK!!! why?? Confused

Thanks!  
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 20 Aug 2010 at 2:33am

Enter the Group Expert and highlight the Date Group you have defined in the Group By window. Click Options. Use the bottom drop down box to change it to for each week.

|< /\ '][' ( )
IP IP Logged
Trishuli
Newbie
Newbie


Joined: 05 Jul 2010
Online Status: Offline
Posts: 3
Quote Trishuli Replybullet Posted: 24 Aug 2010 at 7:36pm
Frn, Thanks. I know about the selection in grouping field for date. My question was how do you use both? It will let me either group the date by Month OR Week. I need both and depending on the parameter chosen, it will display report for that particular date group type.
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.