Hi,

I was wondering if anyone could help me...

In Ingres Report Writer, how do you prompt a user for an input value, but default to something should they enter blank? In particular, I want to prompt for a date, but default to today's date if blank...

I've tried the following in the .DECLARE section:

indate = date with prompt "Enter date (leave blank for today's date):" with value current_date

which doesn't seem to work.

Incidentally, is it possible to not allow a user to enter a blank input?

Any help would be appreciated. Thanks.

Hi,

You appear to have correct syntax, try changing current_date to date('today').

Or, in your header section or where-ever else you print the first data, do

.if indata = '' .then
.let indata = current_date
.endif

I do not think you can force the user to actually enter something when prompted by report writer, life would be too easy if we could control users!

Regards