Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Topic: leaving a date parameter blank Posted: 25 Jan 2007 at 6:58am
If a report has date parameters for the user to use in their selection but instead they choose to enter only a check # parameter without knowing the dates, how do you attempt to leave the date parameter blank?
Joined: 13 Nov 2006
Location: Finland
Online Status: Offline
Posts: 37
Posted: 07 May 2007 at 3:13am
I suggest the following solution.
- set your default value for parameter to history (a date that you know, will never be used in this report, in my example it is set to 1.1.2007). This will be the date used, when the user does not know the date.
- add if statement to Select Expert:
If {?PDate}=date(2007,1,1) Then {Invoice.InvoiceDate} like > date(2007,1,1) else {Invoice.InvoiceDate} = {?PDate}
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
IP Logged
