Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Inder Singh

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...