Sharing a Report (Pivot Table, Charts)
The following section describes how to share a Pivot Table report with other users in your Database. It shows the steps for sharing a report where data is visualized as a Pivot Table but you can follow the same steps to share reports where data is visualized as a Bar or Line Chart.
Once you design a report visualizing your data as a Pivot Table, Bar Chart or Line Chart, you can share it with other users who have been added in your Databases. You can share a Report with users based on their assigned Role in the Database.
The report will be automatically updated as data are updated.
To be able to share a report you must be the Database owner or to have been assigned the 'Share reports' permission.
When you share a report with other users, they will be able to view and export the report but they will not be able to save changes to the original report, nor rename or delete it. However, they will be able to do edits and save a copy of the report and work on the copied report instead.
Also, when a report is shared with users, users cannot share or publish that report, even if they have permission to share and publish their own reports.
To be able to view the data displayed in the report, users must have been assigned to the resources (Folders, Forms) that are used in the report.
So for example, if you design a report using Records added to "Form A" and you share the report with all users that have the Role "Data Entry" in the Database, a user that has no access to "Form A" will be able to view the report in the Report List page but the report won't include any visible data when opened.
You can stop sharing a report anytime.
Database owners will be able to view all shared reports of the Database in the Reports List page.
Learn everything you need about Sharing and Publishing Reports in our Webinar "Publishing Reports and Dashboards".
The 'Share reports' permission cannot be granted on a per resource or a per user basis.