Crystal Reports prompt for a date range

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: prompt for a date range

Post Reply

Post New Topic

Author	Message
jimisayss Newbie Joined: 29 Aug 2012 Online Status: Offline Posts: 5	Topic: prompt for a date range Posted: 06 Sep 2012 at 10:29am
	So on this report we would like to it to promt for a data range when refreshing the data, we would like to be able to pick from say the 1st of the month and the last of the month, how would i go about setting this up. any help would be great. {calibration.duedate} is the field im working with.
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 06 Sep 2012 at 6:35pm
	Hi 1. In the field explorer go in Parameters section and create a new paramter of date type, while creating you could see Option in the same screen.. make Range value to true. 2. Once you create the paramtertr, go in Report-- Selection Formula--Record and give the following condition. {calibration.duedate} >= {?Parameter} and {calibration.duedate} <= {?Parameter} Your report will get filtered based on range values
	Thanks, Sastry
	IP Logged

jimisayss Newbie Joined: 29 Aug 2012 Online Status: Offline Posts: 5	Posted: 14 Sep 2012 at 1:45pm
	thank you! my next question is how do i sort this by groups as well, the clients are sorted in to groups, when i put a date range it is showing me all data but i want to show the individual clients for the date range selected, if this is possible.
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 16 Sep 2012 at 11:41pm
	Create a formula like : IF {?dateparameter} >= {datefield} and {?dateparameter} <={datefield} then "MYGROUP" Now go in insert group-- insert the above formula as your gorup.
	Thanks, Sastry
	IP Logged

jimisayss Newbie Joined: 29 Aug 2012 Online Status: Offline Posts: 5	Posted: 20 Sep 2012 at 5:38pm
	Thank you again, but is seems to be giving me dates past what i have specified in the parameter prompts, what can i do to fix this?
	IP Logged

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