Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Sales This Week, This Month, This Year, etc. Post Reply Post New Topic
Author Message
bmurphywa
Newbie
Newbie


Joined: 07 Aug 2009
Online Status: Offline
Posts: 15
Quote bmurphywa Replybullet Topic: Sales This Week, This Month, This Year, etc.
    Posted: 21 Aug 2009 at 5:34pm
CR X.  I would think this should be easy but I haven't been able to figure it out.  I'm trying to set up a report so that whenever it is run, it shows sales since the beginning of the week, the month, etc.  Seems like there should be a built-in function for this (the date part) but I can't find it.  I'd appreciate some guidance here. Thanks.
Bill M
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Aug 2009 at 7:25am

1. Are you looking for a parameter to let a user select which way to view this?

2. are you looking for select statement to do this?
3. Are you looking for how to present the data in one report for all of the above?
 
IP IP Logged
bmurphywa
Newbie
Newbie


Joined: 07 Aug 2009
Online Status: Offline
Posts: 15
Quote bmurphywa Replybullet Posted: 24 Aug 2009 at 7:36am
1. No
2. Yes
3. No
 
Thanks!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Aug 2009 at 8:05am
There are a bunch of these and I cannot remember them all but you can search for them in the Crystal Help Files...here are a few....YOu can use them in any of the formulas including the select statement
 
YearToDate example use... {table.datefield} in Yeartodate
LastYearYTD
MonthToDate
Last4weekstosun
LastYearMTD
lastfullweek
 
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.016 seconds.