Tim Easley Posted February 26, 2021 Share Posted February 26, 2021 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 More sharing options...
Brian Baird Posted March 2, 2021 Share Posted March 2, 2021 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 More sharing options...
Kristi Carter Posted March 2, 2021 Share Posted March 2, 2021 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 More sharing options...
Tim Easley Posted March 2, 2021 Author Share Posted March 2, 2021 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 More sharing options...
Brian Baird Posted March 2, 2021 Share Posted March 2, 2021 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now