Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure out how can I generate the report for the contribution specifically created by those staffs of “SHOP”. Any help would be appreciated. Thanks
When someone adds a Contribution via the backend (eg Add Contribution) then an Activity is created (Type = Contribution) which will record who added that Contribution.
If you use that fact, and set up your 'users' in a Group either manually or smart group per Aidan's answer, then you might be able to build an Activity based report to show the contributions they added.
You could sync your Drupal role to a Civi group with the CiviGroup Roles Sync module then use the group in the report filter criteria.
If you have sql skills you may be better with an sql query of the log_civicrm_contribution table with left joins 'Group' so you can filter to the 'Shop' people, and just look for the 'insert' value in the log table. Then you may be able to join in the other values you are saying you need in