Magento Custom report.

Magento Custom report.... We have a magento installation (version 1.6.2.0) and we need some ADMIN custom development. Basically we need the following ability for the magento admin: for magento admin user "X" show Reports only that relate to products "Y" What this means is for particular admin users to show only reports from particular products. All this users are already created and have roles assigned to them so they can view only strictly the Dashboard, Reports->Sale, Report->Products (see attachment) What we need is for this reports to contain information only based on selected products This users will actually be used by the manufacturers of particular brands and they must see reports only on their products alone. DESCRIPTION: - each magento admin user has now a role applied and can see only the dashboard and reports button - each of this users is used by the manufacturers that have products on our site and they want to see the reports ONLY related to their products - magento shows only reports on all the magento activity, so we need to apply to each user a filter so that they can see only reports based on their products. this filer can not be modified by them (only we can have acces to this modifications) beside this we need a filter that can show the stock of all products by that manufacturer EXAMPLE: we have the company X that has a user created on our magento admin and they have the brands/manufacturers: DHS, APPLE, NIKE they will see sales and products reports ONLY based on their products and not on other companies brands/manufacturers SPECIAL CASE an order has products from more than one company. Example: from company X it has a product Apple and from company Y has a product ADIDAS in this case we will remove the products that are not theirs and leave everything as it is (shipping, discounts, etc)