Tuesday, January 29, 2013

NextReports : Templates for Parameters' Values with Time Interval

NextReports Server has a feature called Templates for Parameters' Values which was explained here. User will be able to save a template of runtime values or to select a previously saved template to automatically load all values.

This template will be extended with a Time Interval starting with 6.0 version.

If a report has two parameters named by convention as start_date and end_date and those parameters have single selections and their type is one of Date, Time or Timestamp, then values templates panel will show also a selectable time interval:





This interval can be one of Yesterday, Today, Current Week, Previous Week, Current Month, Previous Month, Current Year, Previous Year and Last.

For all the intervals the two dates will be automatically filled with the corresponding dates. For example for Current Week, start_date will be the Monday of current week with hours, minutes, seconds and milliseconds equals to 0, while end_date will be the Sunday of current week with hours 23, minutes 59, seconds 59, milliseconds 999.

If Last interval is selected user will be able to select how many days, weeks, months or years are counted from current day:





For example for “Last 4 Months” start_date will be the same day as today but 4 months earlier with hours, minutes, seconds and milliseconds equals to 0, while end_date will be the current day with hours 23, minutes 59, seconds 59, milliseconds 999.

No comments: