If I use the same filter in a report (created by a job queue entry or using a report filter template) the dynamic filter expression won't be stored in the report options (templates). Instead you'll figure out that the report always uses the same filter range (depending on the values when the report runs first). It doesn't matter that "%MYCUSTOMERS" contains more customers now.
The same problem comes with date filtering.
Using job queue entries for routine activities is fine, but with fixed filter values sometimes it's unusable.
Can't the filters in report filter templates / job queue entries just behave as filters in page views?
Comments
Very important!
Category: Reports and Business Intelligence
is very frequently requested by customers
Category: Reports and Business Intelligence
..or you will start Planning Worksheet with variable planning horizont, set Starting Date ("a") and Ending Date ("a+180D") according to Workdate. would be very usefulthanks in advance
Category: Reports and Business Intelligence
e. g. you want to use the delete sales order job/report where the Posting date is "..h-14d", you can run this manually but not with the job queue. The date is fix.
Category: Reports and Business Intelligence
Yes please . I actually assumed a datefillter on a report put in like this "CM" would stay dynamic if same report is run on a plan the next month, but it doesn't seem to do this. Seems it's converted into fixed values upon run. Without this, a lot of planed reports aren't really useful.
But a test today in BC v15 showed me this is not case, just tested it today.
Category: Reports and Business Intelligence
Business Central Team (administrator)
Thank you for your feedback. We are considering adding it to our longer term roadmap.