Issue while scheduling the reports

[lifzgud]

I have come across this issue while scheduling the reports.
Our reports run on 2nd of every month and I have set the default of the Month Prompt of the report to pick up the last month(Current Month -1)
For eg when the report runs on 2nd August it will pick July's data.

Now the report has other prompts as well Namely
1)Customer
2)Reporting period

If I set them to a particular Customer (say ABC) and reporting period to Month while scheduling the report it overrides the Default value of Current Month -1 and displays the report for all months.

I need Date prompt to be dynamic as it has to keep on changing.
The other two prompts(Customer and Reporting Period has to be static)

I don't want to hard code Customer in the Report as it might change later in the future. So I want to change it in the schedule itself.

[mvjcognos]

TRY THIS LIKE WRITE IN THE PLACE OF FILTER

DATE DATA ITEM =
(CASE WHEN ?DATE PARAMETER?='SYSDATE' THEN TO_CHAR(ADD_MONTHS(DATE DATA ITEM,-1),'YYYYMMDD') ELSE ?DATE PARAMETER? END)
WHAT THIS WILL DO MEANS FOR SCHEDULING PURPOSE U NEED TO ADD ONE DEFALUT VALUE FROM VALUE PROMPT.

THINK THAT U HAVE ADDED A STATIC CHOICES IN THE PROMPT 'SYSDATE'

HERE 'SYSDATE' WILL BE CURRENT MONTH

IF IT IS CURRENT MONTH THEN U WANT LAST MONTH'S DATA

THEN MY QUERY WILL WORK WE TOO HAVE THE SAME SCENARIOS...........

BUT U NEED TO KNOW HOW TO USE THIESE QUERIES..........