Date Parameter to default to CurrentDate?

[fredong]

I am using CR v 8.0 and with a datetime paremeter field on my with SQL 2000 store procedure. I need to automatic default to CurrentDate on the datetime parameter on the report each time I schedule to run. Is that possible? Thanks.

 

[Naith]

You could set an arbitrary value as your parameter default, as say Date(0,0,0), and make the description for the default "Current Date".

Alter the parameter to display description only, if necessary, and amend your record selection criteria to say

If {?Parameter} = Date(0,0,0)
Then CurrentDate

Naith

 

[fredong]

where do I put this information at? At the Record selection?

 

[Naith]

Put the code part in your Record Selection.

Everything before the code window is formatting you do in the parameter editor.

Naith

 

[fredong]

I placed in the record select and it return an error

"The result of selection must be a boolean." Please advise.Thanks.

 

[synapsevampire]

Naith is speaking of detecting what is entered, to answer your question, the default value of the prompt IS the currentdate.

-k

 

[fredong]

so where should i put this to default to currentdate.Please advise.Thanks.

 

[ShortyA]

I think Naith is suggesting that in your record selection formula you have something like :

{mytable.myfield}=xyz
and (If {?Parameter} = Date(0,0,0)
Then {Mytable.MyDateField}=CurrentDate)

When editting your parameter you would set the value ("Set Default Value" button) to 00/00/0000. Your record selection formula will then check for this parameter value and if it has been left as 00/00/0000 by the user then the currentdate's data will be returned otherwise the data for the user-input date will be returned.

Hope this helps.
ShortyA

ShortyA

 

[fredong]

on the "Set Default Value" button it will not allow me to insert 00/00/0000. Each I try to type in 00 it will flip to a non zero value. Any ideas.

 

[ShortyA]

Try a date such as 01/01/1901!