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
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
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
panel in the report designer. You can drag and drop columns from across tables, to create your reports.
Consider this scenario. An
table containing the
. And another table
containing the salary info. These two tables will be linked by the
. 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
: As a New Year special, we are running a limited-time, special discount offer for Zoho Reports. We are offering 25% off on annual subscriptions and 15% off on half-yearly subscriptions. Our pricing details
. Subscribe now and take advantage of this special offer.