Print Page | Close Window

How to use "All" in a date field

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10780
Printed Date: 26 May 2024 at 11:04pm


Topic: How to use "All" in a date field
Posted By: flintwood
Subject: How to use "All" in a date field
Date 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


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


Print Page | Close Window