Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Date Range Post Reply Post New Topic
Author Message
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Topic: Date Range
    Posted: 03 Mar 2012 at 6:36pm
Dear All,
I want to run a report where i just have to refresh the report & automatically it should show the records for last three days only from the current date.
 
Can anyone help me on this?
 
Regards
Alex


Edited by Alexander - 03 Mar 2012 at 6:36pm
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Mar 2012 at 4:46pm
You'll use a formula in the selection criteria instead of one of the options from the Select Expert but you have to go to the Select Expert to start.  If you don't have anything set up in here already, select a field - doesn't matter what it is.
 
Click on the Formula button and add something like the following to the the formula:
 
{table.DateField} >= (CurrentDate - 3) and {table.DateField) < CurrentDate
 
NOTE:  This assumes you don't want the current date.  If you do, change the "<" to "<=".
 
-Dell
 
 
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.