As you may know, you can share the reports and tables with your colleagues & contacts in Zoho Reports, your effective online reporting & business intelligence service. And this makes collaboration a lot easier. Zoho Reports now provides fine-grained permission options while sharing. When you share a report or a table, you now have the choice to specify what can be done with the table/report by the user to whom its shared. Let's illustrate this with an example.

The following example consists of US GDP data (in actual and chained year 2000 dollars) over the years. For sharing the chart, click on Share -> Share this View to New Users.

Sharing a report
In the dialog box that opens, give the email addresses of those you want to share the report with.

Specify sharing email addresses
Now comes the exciting part. In the Permissions tab, you can specify what the shared users can do with the report you share with them. Whether they can Export the report's data and whether they can view the underlying data etc.

Specify sharing permissions
Similarly, there are permission options when sharing a table too. Like you can specify whether a table's data can be exported or modified (appending or modifying rows etc).

Specify sharing permissions for Tables
Supposing you want to share a number of tables/reports, you can do so from the Share option in the Explorer view. Check the Tables and Reports that you want to share, click on Share -> Share this View to New Users and choose the appropriate permission options.

Share from Explorer view
Whether the sharing notification email is to be sent can be specified too.

Sharing notification email
Also, such fine-grained permissions can be provided when sharing with the Database Group. You can define a Database Group consisting of a set of email addresses. This feature comes in handy when sharing reports & tables to the same set of users (than sharing to the individual email addresses each time).

Sharing from Explorer view
Try the new fine-grained sharing permission options in Zoho Reports & do let us know your feedback.

Related Links
  1. Dynamic Chart Filtering and URL Data type in Zoho Reports
  2. Zoho Reports : Pivot Table Enhancements
  3. Quickly Generate Similar Reports in Zoho Reports

The latest Zoho Reports update brings in the 'Query over Query' functionality, which has been one of the top request from our users. You can now have SELECT queries that combine already existing Query Tables. Let's see an example of how this comes in handy. Say you have a Sales table with sales figures for various customers, products, regions etc across years.



Say you would like to know who your Top 10 customers with respect to sales value were in 2006. Your query table would look like,



The above Query Table in 'View Mode' with the top 10 customers arranged in alphabetical order.



And now you want to know how much you sold to those top customers of 2006 in 2008. This is where the new functionality will come in handy. You will arrive with the required data by joining the base Sales table with the above top 10 customers of 2006 Query Table. The new Query Table will look like,



The above Query Table in 'View Mode' with the customer names in alphabetical order.



You can save the resultant query table and create the necessary reports over it.

With this new "Query over Query" feature, you can create very powerful reporting queries on your data and use it for your report generation and analytics. It also helps in organizing your queries into reusable functional units. To know more about how to create a Query Table, checkout this video
.

Other Enhancements
Previously, direct import was restricted to CSV files. And you had to do a copy-paste from Microft Excel (XLS) files. From now on, you can directly import XLS files too.



Also, for xls, html files larger than 3 MB, you can now zip them and import into Zoho Reports.

Try these new features in Zoho Reports and let us know your feedback comments.

Related Posts