I want to prompt user to chose an input from: Last 12 month ...

[Inder Singh]

I want to prompt user to chose an input from: Last 12 month OR Current fiscal year.

and then use this to filter out my table.

Any guess, how can achieve that

[SATHEESH B]

There are multiple way to do this report.

 

Create a Report with date range parameter &FROM_DATE and &TO_DATE.

Create a Static prompt for Yearly and Fiscal

Based on the Selected option set the start and end date. ( i hardcoded the date but the date calculation can be dynamic)

 

-DEFAULTH &FROM_DATE=;

-DEFAULTH &TO_DATE=;

-PROMPT &RUN_TYPE.(<Last 12 Month,1>,<Fiscal Year,2>).Select Report Type :.QUOTEDSTRING;

-IF &RUN_TYPE EQ 2 THEN GOTO FISCAL;

-TYPE Yearly

-SET &FROM_DATE=01/01/2021;

-SET &TO_DATE=12/31/2021;

-GOTO RUN_REPORT

-FISCAL

-TYPE Fiscal

-SET &FROM_DATE=07/01/2020;

-SET &TO_DATE=06/30/2021;

-RUN_REPORT

-TYPE RUNNING REPORT

-TYPE FROM_DATE : &FROM_DATE

-TYPE TO_DATE : &TO_DATE

Your Report here