Double Date Filter in Report

wires100

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.

PeterD

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

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

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

Hallo Egnaz,
(Danke für Deine Antwort).

Thanks for your answer. I Try This Idea.


Gruß
With Regards

Wires100