Double Date Filter in Report

wires100
wires100 Member Posts: 4
edited 2011-01-05 in NAV/Navision Classic Client
Hello, i am new in Forum and I need help.

Report 111 (customer Top 10 list),
I need a list from customer- with 2 date filter:

I search all customers, have buy e.g. 01.01.05..01.12.10 (filter1 - is ok, i have this field (Date)), and this customers have not buy e.g. 01.01.09..31.12.09 (filter2)
what I need? how can I programming this Filter and where? OnAfterGetRecorg() ? Which DataItem?

Thanks for Your Help

Sorry for my English.

Comments

  • PeterD
    PeterD Member Posts: 66
    If I understand correctly, you want to skip all customers that bought something in 2009.

    In that case you can use a variable of record Customer in Customer.OnAfterGetRecord and set a datafilter (filter2) on that record for the current customern. Than calc the sales and balance amounts. If <>0 then Skip customer.
  • wires100
    wires100 Member Posts: 4
    Hello,

    Thank you for your help/Tip.

    i want to show all customers that not bought (anything/something?) in 2009.
    I have all customer Filter (date filter) 01.01.03.. 31.12.2010, and i want second filter with this list, where i show customers that not bought e.g . 01.01.09..31.12.09.
    Should i set variable Datefilter2 (date) on that record for current customer? Than calc the sales and balance amounts for 01.01.09..31.12.09 . If =0 then show customer.

    How can user change this? not 01.01.09..31.12.09 but 01.06.10..09.10.10?
    With this Variable? and Filter in option?

    Thanks
  • Egnaz
    Egnaz Member Posts: 111
    Maybe you can try this with another DataItem.

    Customer [datefilter 1]
    --Customer [datefilter 2] - DataLink [No. = No.]

    So you can variable filter both values.

    The output should be printed in the second DataItem. DataItem 1 is just for pre filter the customer.

    Regards,
    egnaz
  • wires100
    wires100 Member Posts: 4
    Hallo Egnaz,
    (Danke für Deine Antwort).

    Thanks for your answer. I Try This Idea.


    Gruß
    With Regards

    Wires100

Categories