I am having issue with reports only show the data of the user running the report. How do a setup so a user with specific role can export all the data not just their data. Currently this is how I have set up.
1. Created view of node type called Reports
2. View Default has this settings: Table, Fields - User:Uid, Node type, User: email, No Relationships, no filters, no arguments
a. Then I create separate Date Export display for the reports I need.
- Added the fields needed
- Added Filter on node type for each specific node type.
- One one have Relationship to Content profile.
- Set the Items Display Unlimited
- Access to staff_report role
- Set the path to name
- Batched export: Yes
- Style: CSV File
- view has not arguments
3. Create role - staff_report with this access
a. access site-wide contact form
b. node module: access content
c. views module: access all views
d. menu_access module: access menu
e. menu_item_access module: access menu items
f. Create user and set to have staff_report role.
4. Created a block name CVS Reports where
a. block body as links to the reports for example Report1 with link to www.sitename/report1. The export setting path name set in the view.
b. role specific visibility settings: admin and staff_reports checked
When I login in has user with just access to run the reports and run the reports only get the data for the user id logged in. When logged in has admin user and run report I get all the data for all users.
What I am doing worry? I figure I must be missing something. Any help would be great. We do not what to give the user admin role to run the reports.
Thank you,
Pam
Comments
Comment #1
pam.pkrweb@gmail.com commentedSorry I forget we using a module for access content by role.I need to set the staff_report role to have access to view any date for the cck's create that I am reporting on. So have it working now. I know it had to be something I was missing.
Thank you for the great module.
Pam