Print Page | Close Window

Sales This Week, This Month, This Year, etc.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=7458
Printed Date: 02 May 2025 at 2:36am


Topic: Sales This Week, This Month, This Year, etc.
Posted By: bmurphywa
Subject: Sales This Week, This Month, This Year, etc.
Date 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


Replies:
Posted By: DBlank
Date 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?
 

Posted By: bmurphywa
Date Posted: 24 Aug 2009 at 7:36am
1. No
2. Yes
3. No
 
Thanks!

Posted By: DBlank
Date 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
 


Print Page | Close Window