Dynamic Parameters for Scheduled Quick Report

As far as I know from date and To date are static parameters that user has to enter in the scheduled report.

This might be a customization where we can hardcode these two parameters.

see whether you can use these following queries.

select Last_Day(ADD_MONTHS(sysdate,-1))+12  AS TODATE from dual;

or

select Last_Day(ADD_MONTHS(sysdate,-2))+12  AS fFROMDATE from dual;

Why wouldn’t you remove both inputs altogether, and let the report’s logic pick the data for the month prior? The system knows the current system date, so it can be told to pick data for the previous month without waiting for the users to enter data.

Thomas,

That is the ticket.  I will add to your answer to make it a bit better:

TRUNC(My_Date_column) BETWEEN COALESCE(&absence_period.date_from, add_months(TRUNC(SYSDATE,'MM'), -1)) 
        AND COALESCE(&absence_period.date_to, TRUNC(SYSDATE,'MM')-1)

&absence_period.date_to (this is a generic date field, but can use a date field straight from the table and it will use the column name as the prompt for the parameter box.) Doing it this way puts a option box at the end of the parameter box that allows the user to select the date using calendar control.  Can use it with NVL also.