Crystal Reports regarding Date Range parameter

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: regarding Date Range parameter

Post Reply

Post New Topic

Author	Message
punamgandi Newbie Joined: 28 Dec 2011 Location: India Online Status: Offline Posts: 3	Topic: regarding Date Range parameter Posted: 28 Dec 2011 at 8:08pm
	hello, in purchase order, i want to pass date range parameter. For eg . I want to fetch data from 21/11/2011 to 25/11/2011 how to pass parameter for this?? or do i need to create any formula?? if yes then how/??????? awaiting for soonest reply.
	Punam Gandi
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 29 Dec 2011 at 1:59am
	Create a date parameter and set it to handle Range of Values. Then you would need to go to the Report>Selection Formulas>Record. You would then enter something like: {table.datefield}={?DateParam} When you refresh the report data you will be asked to enter your parameter values.
	\|< /\ '][' ( )
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 29 Dec 2011 at 3:22am
	that's new and something to remember. I probably would have gone the more traditional route of a startParam and endParam and in the selection formula used something like: {table.field} in {?startParam} to {?endParam} or {table.field} >= {?startParam} and {table.field}<= {?endParam} One the other hand, I mostly use stored proc, so CR would have created 2 params to map to the 2 params in the stored proc.
	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