Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: How to use "All" in a date field Post Reply Post New Topic
Author Message
flintwood
Newbie
Newbie
Avatar

Joined: 31 Jul 2010
Online Status: Offline
Posts: 16
Quote flintwood Replybullet Topic: How to use "All" in a date field
    Posted: 09 Aug 2010 at 10:12am
I have a date formula and there needs to be an option to type in "All". So we either type "all" or type in the date. What would be an appropriate formula for that...Any help will be appreciated.
FW
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 30 Nov 2010 at 3:32am
I am sure that you found a work around by now, but this is what I do:
have the date parameter by a string and allow the user to enter the string.
 
if you want the user to select from a list, I would use a command object and union the date selection (converted to a string) with ' All'.  The space allows it to sort to the top of the list.
 
in the selection formula, I would replace the ' All' with a value that would be small or large enough to encompass all the data
 
HTH
 
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.