setting default date

[zik]

any time I run my report, i use date ranges.
eg
select * from emp where
begin_date between to_date('01/01/1986,'mm/dd/yyyy') and to_date('12/30/1999,'mm/dd/yyyy').
Now, how can I set the begin_date to display at the top of the form like this:

December, 1986
and then report follows?
thanks!

 

[freedomUSA]

If your begin and end date are in parameters you could put a text box on your layout with entry like &begin_date - "&" character followed by your parameter name. I usually do this on a header page or in the margin of the report if I want it on every page.