Dynamics Community Forum Thread Details

Filtering/date problem

Hello I'm in need of some help

I need to add a filter for one of the report that my company is using i'll to explain my problem:

"Debt Statement For Customers"

it is needed that the report filter would search in all the customers to a specific date and if it finds that the customer has 0.00 in Net Change and Balance it just "CurrReport.SKIP" this works prefectly for me, but for this i must add the following that in a addition to the above it would also check if the customer had any operations in the current year to our speficied date. If i add a filter on date it just gives me all values from the year start for example like this:

yearstart := CALCDATE('<-CY>', ToDate);

recordname.SETRANGE("Posting Date",yearstart,ToDate);

In reqeust page i use "Todate" to specify the end point.

I understand that i must somehow do a check in the filter so that it checks all the records (values), but does not filter them and if it finds any records (values) in the last year, even if there is all 0.00 it doesnt "CurrReport.SKIP".

Basicly if the values is 0.00, but there are record(values) in the last year, it doesnt not stop my report, but if there is values they are printed even for example 10 years go and not only from the last year.

Maybe someone could give me some hints were to start?

Quick Links