I've a requirement to distribute the PDF report to the users daily with a dynamic filter applied(today() excluded in reporting date ) . I can exclude today() / current date from the reporting date using triggers when 'on Open event'. But this will not impact the PDF report. In Access Point, it is showing current date excluded whereas in PDF it is not excluded the current date. Do we have any option to exclude the current date dynamically ?
FYI, I've tried report editor settings, Report setting > Initial selection options , but no luck. Only the date is excluded when the application was last saved and it is not dynamically changing .
