iam having a brain draining problem, i am doing a report for our purchasing dept called "supplier delivery performance" what this report does is give a list of supplier accounts, lines due from that supplier, lines recived from that supplier, qty orderd from supplier and qty recived so far from supplier. its the quantity received so far that i am having a problem with, this report has a drill down so i can see which products exactly are on order, and basically in the drill down i have a summary which adds up how many products have arrived but only if the date received is equal to or less than the date due. my problem is then how to get this onto the main report, i thought i could use the maximum function and try to add a summary of the maximum of that erunning total, but apparently you cant sum a running total ??!!

so in a nutshell, how can i get the maximum value in my running total (in the drill down) onto the main report?????

 

wht do u mean by row level? i take it you mean a sample row from the supresed details section?

 

wells its liek this supplier code - lines due- lines recived on time - % lines recd on time - qty ordered - qty received on time - % qty recd on time

 

its the qty recd on time im having trouble with

 

iv tried a formula somthing like if date_recd <= date_due then sum qty_recd.

 

this is giving me a real headache hahahaha.