report filter By Year

On a report I have a Filter Posting Date.

I Pretend filter and group My report Data By Year. How can I do That?


If I understood your question correctly you could try to add a global variable, called for example YearToEvaluate (type integer), to your report request form and change the OnAfterGetRecord trigger like the following:

IF DATE2DMY(“Posting Date”, 3) <> YearToEvaluate THEN


Like that your report will only show records that match the year you want to see.

Best Regards.