two filters in one report (not reqFilterFields)

bull

Dear all,

I want to run table "value entry" and take from it some values , including "Quantity" .
I have group on "Global Dimension 2" and reqFilterFields the "Posting Date" .
In first case , when "item lenger entry type " is "Sale" , the "Posting Date" filter is good for me !
But in second case , when "item lenger entry type" is "Purchase" , i want only the second date!
For example :
I give : "..311206" -> everything is cool !
but when i give "101206..311206" in filter , for the Sale case is allright but it doesn't work for the "Purchase" case ! It is normal because some purchases may had been done before 101206 so doesn't match the specific records from value entry . So i want to give to different filters in one report in c/side and not as a reqfilterfield .

Has anybody got some idea?

thanks in advance,
Bull

Miklos_Hollender

In this scenario, what you could do is to to save the beginning date of the range the user entered to a varible via GETRANGEMIN. F.e. in OnPreDataItem. Then override this filtering - filter on GETRANGEMAX. The CurrReport.SKIP those sales entries that are earlier than the saved min date.