Using 2 date filters on 1 table on a report.

JamieBrown

Hi,

I'm sure this is easily solved but I'm having difficulty.

I'm reporting on the Item table and need to show the "Net Change" with a date filter and also "Qty. Sold (POS) with another Date filter.

What is the best way of achieving this?

Thanks in advance.
Jamie

Marije_Brummel

You can store them in variables.

First set the datefilter for 1 flowfield and do calcfields

Var1 := Flowfield1;

Then change the datefilter and store again

Var2 := Flowfield2;

JamieBrown

Thanks Mark, worked perfectly. !