Originally posted by lockwelle1) shouldn't kd0116 have 1td not 995? Just trying to figure out the logic of the report.
2) it would seem that you want have a group based on the [tool]. then you could have a formula in the detail section that would look at the [tc] and it would look for the value. If the value is found you could either set variables or a flag and then you could either suppress the row based on a flag or display the variables saved in the group footer.
I realize that this a bit vague
Hope this helps
thanks for your reply but i need to explain more it seems.
First i need spesific TC for some tools so TC depends which tool it is.
Second; i cant group by tool number because i must group by another field.My aim in this report is grouping by another field and then making a chart whit this field that counting tool number per field.
So i cant use next,previous command on field and cant use suppess because it will still counting supressed rows at total count. :(