I am asked to put in the header the values maxdate, mindate and maxnr p/ day and minnr. p/day

The listing looks like this, and yes there are more nr.val on one day that might be equal en Yes sometimes a number can be missed on a day,

Now , i need to put this in the header out in front of the report.

I used the month values to group the records >> group 2 = order on date

Since there is the newstart of the nr sequence on every first day of the month, i cant simpley get away with min and max vals.

I have tried with running totals , and ended up to code my own here.

 

Example;

if Cstr({@NrMonthLow}) <= Cstr({@NrMonthHigh})  then ({Opdracht.Nr})

 >> if i place this field in header or footer i  have the correct reading.

       Using min max vals did not give me any better results.

Just for more intersted i handled the moths and groups with these below 

 

{@NrMonthLow} =  Minimum({@Monthverloop})

 

{@NrMonthHigh} = Maximum({@Monthverloop})

 

({@Monthverloop}) = (month({Opdracht.RecDat}))

 

If whished for, ill mail you an Excel sheet from wich i get the data and the report based on that data.