well , it's too complicated , and first of all it needs time to understand the problematic , it doesn't belong to lazreport section according to the previews answers . what I need is : taking a deep look at the stored producers , PIVOT tables.
I'll mark it as solved , and perhaps if it's allowed I'll leave a comment later if I figure out how to fix it .