Blank Parameter Field

[zootweller]

How can I set a parameter, so when a user schedules a report without selecting any parameters, it will default to all relevent values, as though the parameter never existed in the 1st place?

Better explanation: A user schedules a report, forgetting to set the 'From' Date parameter, so instead, all dates should be returned.

I am using Seagate Info 7.0.2

 

[synapsevampire]

If you worry over them forgetting, set the default value to something that they would never select, as in 1/13/1902.

Now in the record selection criteria use something like:

(
if {?ParmDate} <> date(1902,1,13) then
({MyTable.MyDate} = {?ParmDate})
else
(if {?ParmDate} = date(1902,1,13) then
true)
)

I add in both sides of the equation because it seems to assure that the SQL is passed to the database more often when multiple parms are selected.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com