Zoho Reports: Create Reports Over Multiple Tables Using Auto-join

Posted by Posted on by
0

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 ID

,

Employee 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.


Note

: 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

here

. Subscribe now and take advantage of this special offer.