Item Date Filter on a report

nbangaza · 2012-11-15

Good Day Everyone,

Is it possible to set a date filter on Item.'Date filter'?
The data item of the report that I created is Item table.
On the OnafterGetRecord() section of the report I want to be able to add code where I can filter on the "Item Ledger entry"."posting date".
I tried the below but it didnt work
ItemLedgerEntry.SETFILTER("Posting Date",Item.GETFILTER("Date Filter"));

So for example if a user when they run the report puts in the following date '010112..031212' the report should only filter for "Item Ledger Entries" within those dates.

Regards,

David_Cox · 2012-11-26

Try:
OnPreReport or OnPreDataItem
Item.COPYFILTER("Date Filter",ItemLedgerEntry."Posting Date");

If the Item Ledger Entry is an indented record under the item and not in code, then just add it in the Item Ledger entry > Properties > DataItemLink

HTH

David

Item Date Filter on a report

Comments

Categories