Report - Group By Month

maanmusleh
maanmusleh Member Posts: 7
edited 2010-12-07 in NAV/Navision Classic Client
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??

Comments

  • FDickschat
    FDickschat Member Posts: 380
    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.
    Frank Dickschat
    FD Consulting
  • MBerger
    MBerger Member Posts: 413
    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") ;

Categories