Dynamic Date Filtering in Interactive Reports
Introduction…Whilst the filtering part of interactive reports currently supports a fair number of options, there isn’t currently the facility to specify a dynamic date filter using SYSDATE. A common use case for this would be a dashboard report where you want to display all the overdue items in a dataset. In the interactive report filter definition, it would look something like this…
But unfortunately, we do not currently support the use of SYSDATE in the Expression field. So what can you do? I will discuss 3 possible workarounds for achieving this.
Note: Method 1 does not require any changes from a
…click on the title to read the full article…
Leave a Reply