how to set evaluation in manual running total
I am trying to create a manual running total however I need to setup an evaluation by using a filter field.
Summary Type: Distinct Count
Evaluation: Formula - foc.linetype="F"
Now the question is how to use the above in the formula.
Whileprintingrecords; numbervar x:=0; numbervar y:=0; numbervar z:=0; x:=DistinctCount(foc.doc_no),foc.reasoncode; y:=(foc.linetype="f") If y=true then 1; z:=x+sum(y) z;
I know the above code could be wrong (most probably is) however it gives you an idea what I am trying to achieve.
If I use temp SQL Command. the report takes forever to calculate so I don't think I would be using that.
Any ideas how to do this sort of running total (manual).