166
In Pages it's possible to use dynamic filters like %MYCUSTOMERS to create views that support users with "their" data. The advantage is the flexibility of the filter range - it's always up to date.

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?
STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Mike Borg Cardona
Program Manager, Microsoft  

Comments

T

Very important!

Category: Reports and Business Intelligence

T

is very frequently requested by customers

Category: Reports and Business Intelligence

T

..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 useful


thanks in advance

Category: Reports and Business Intelligence

T

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

T

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