Security on accounting flex fields

[nhsa]

Hi...
I'm trying to create a budget variance report that may be accessed by different departments, there are some security roles on the account flex field that let the users see thier departments data only , it's working fine on ERP screens but my report shows all the data, from where I can inheretes these security roles and let the users see what they should see?

Please Help

Thanks in advance