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

I created a reporting object with some date filters and a re...


Tim Easley

Recommended Posts

I created a reporting object with some date filters and a report based on this reporting object. I added this report to a Visualization, and added the filters, combining two date filters into one control. I would like to provide default dates for this control.

In the properties for the combined date control there are two Default value boxes in the Data Settings section and I tried manually entering dates using various formats in these default boxes with no luck.

Has anyone figured out how to provide defaults for a date filter control

Using version 8207.25

Thanks

Link to comment
Share on other sites

Hi Tim,

Are you able to define the default dates in the processing other section of the reporting object In the example I created I added the following and this populated default dates on the visualisation. You would need to change the parameter names to those used in your filters.

-DEFAULT &C1_YMD_FROM = March 02 2020;

-DEFAULT &C1_YMD_TO = March 17 2021;

Many Thanks

Brian

2.png942547 27.3 KB

Link to comment
Share on other sites

Brian,

An additional question along with your suggestions. Most of the time when we have dates and need defaults, it is based on creating it dynamically based on todays date or another date. How would you suggest doing this dynamically based on the current date for example

Link to comment
Share on other sites

Thanks Brian, thats how I thought it was supposed to work. To answer Kristis question you would include a fex that dynamically gets the dates to set the parameters (commented out below). But even when I hard code them I get _FOC_NULL in the defaults.

 

image.png1000637 62.2 KB

Link to comment
Share on other sites

Hi Tim,

I think this is down to the date format or possibly NLS settings. My example used the field format YYMD.

You could create a blank fex and use the -TYPE &DEF_EARN_MIN command to display the value of the date parameter when one is manually selected. Then alter the default to suit. I didnt try to dynamically populate but will have a quick look now.

WHERE SPREADSHEET_QUERY.SEG01.C1_YMD GE &C1_YMD_FROM.(|FORMAT=YYMD).C1_YMD_FROM:.QUOTEDSTRING;

WHERE SPREADSHEET_QUERY.SEG01.C1_YMD LE &C1_YMD_to.(|FORMAT=YYMD).C1_YMD_TO:.QUOTEDSTRING;

Ill post my findings on dynamic defaults shortly.

Many Thanks

Brian

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