Report - Group By Month

maanmusleh

Hi,

I'm developing a report where i have to group invoices by month.



So I used the Date table as the first data item and filtered for "Period Type" to be equal to 'Month'

and added the invoice header table as the second indented DataItem..

But I can not link the two tables together.



I want to link the invoice header to the date table using the 'Posting Date' to be between the Date.'Period Start' and Date.'Period End'

However I can't find a way to do it from the DataItemLink property.



Any thoughts??

FDickschat

You can not do so with the DataItemLinkeference. Just put 1 line of code into the OnPreDataItem Section which filters the Posting Date.

If you are an end user then in NAVs Help (C/SIDE Reference Guiode) look for SETRANGE.
If you are a developer at a partner please get some training.

MBerger

This kind of filter you'll have to do in the OnPreDataItem trigger of the Invoice Header dataitem :

setrange("posting date",date."period start",date."period end") ;