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

Is it possible to create a simple filter with 2 values Just...


JUAN ORTIZ

Recommended Posts

Yes. Is it either or year or can you have Select All

 

WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_YEAR EQ &TIME_YEAR.(<2020,2020>, <2021,2021> |FORMAT=I4).Year:.;

 

This will let you pick all years:

 

WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_YEAR EQ &TIME_YEAR.(OR(<2020,2020>, <2021,2021> |FORMAT=I4)).Year:.;

Link to comment
Share on other sites

You can also create a filter in the master file description and then it will be available for everyone to use without having to recreate it for each report.

Or another option is to create a reporting object with that filter embedded in it so it will automatically be applied to every report that uses that reporting object

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...