Filter Report by Year (Data is TransDate)

Finance and Operations/AX Developer Forum
1

Hi,

i have a report created through RDP (Query + Class)

i didnt bother using Contract Class because i can set the Range in the Query (my current Range is AccountNum).

every thing is working fine. and i already run it.

but now, there’s additional…

i have to add: Filter by Year (the data has TransDate which is Full Date)

how can i manage to put the Range/Filter in my RDP Class ?

as much as possible, i dont want to use Contract/Controller and keep it in simple RDP (processReport). so im asking for answers here.

please help, thanks.

2

If you know how to add ranges in general, it shouldn’t be difficult. Just add a filter from the first date of the year to the last date of the same year. For example:

qbds.addRange(...).value(
    SysQuery::range(mkDate(1,1,2016), mkDate(31,12,2016)));
3

For other users: this topic is already discussed in a duplicate thread on another forum, so don’t waste time repeating the same things here.

I would appreciate if people creating duplicate threads did this management by themselves…