With Zoho Reports, you can create a variety of reports including charts, pivot tables, dashboards, query/summary tables etc. Till recently, all such reports were created over only one table i.e., the columns you used for a report should belong to the same table. If the columns spanned across tables, you had to create a Query Table first and then create reports over it. Not anymore.

With the new Auto-join feature, you can now create reports easily using columns from multiple tables, in much the same way as you create reports over a single table. For the Auto-join feature to work, the tables are to be related using the Lookup column
feature available in Zoho Reports. When you create a new report selecting any of the tables with a lookup relationship defined, columns from all related tables will be listed under the Columns List panel in the report designer. You can drag and drop columns from across tables, to create your reports.

Consider this scenario. An Employee table containing the Employee IDEmployee Name Department. And another table Salary Details containing the salary info. These two tables will be linked by the Employee ID.

Let’s say you want a report on employee salaries based on departments or number of years of experience. With the newly introduced Auto-join feature, you can easily create such a report, spanning columns from both the tables.

The below video shows how a report is created using the auto-join feature.

Hope you like this new Auto-join feature. Try this feature in Zoho Reports now.

  1. Arturo Zoho one user

    Arvind, Hi
    I have a query table with 3 levels of query tables, and zoho reports do not allow me, is there a way to resolve a graph I need in 3 levels to be resolved? Info will be appreciated. thanks,

    • Arvind

      Hi Arturo, Zoho Reports, as you said, supports 3 levels of query tables. If you want a fourth level, your query execution time is going to take a hit, and the reports built on top of this query may time out sometimes. Please write to suppprt@zohoreports.com. Our tech support team may be able to help you by optimising your queries. Alternatively, they may enable a fourth level sub-query configuration for your account as an exception.

  2. Justin Smal

    Doesn’t work for integrated Zoho solutions.

    • Arvind

      Justin: For Zoho integrations, internal tables are already pre-joined.