Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deault parameter values

Status
Not open for further replies.

syncdba

IS-IT--Management
Nov 28, 2005
206
US
Hi,
I have created a report in CRXI. Is it possible to create a default value for parameters.
For Ex, For Start_date parameter I had start_date >=
{?start_date}. Now user wants the start_date currently defaults to today but they can also change the Input start_date.
Any help.
 
Set the default value to 1/1/1970, and turn on the Description only and place Today as the default value for it.

Then in the Report->selection formula->record place:

(
if cdate({?Start_date}) <> cdate(1970,1,1) then
{table.date} = ({?start_date})
else if cdate({?Start_date}) = cdate(1970,1,1) then
{table.date} = currentdate
)

Now if they select Today as the date, it will default to today, otherwise it will observe the date entered in the parameter choice.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top