Zoho Reports is an on-demand reporting and business intelligence solution that helps you get new insights on your business information through its powerful and flexible online business intelligence engine. You get powerful reports in minutes, with no IT help.
Zoho Reports offers the following important capabilities:
Also watch the Video on Zoho Reports Overview
Zoho Reports can be used across various functional areas and by a wide range of users for their reporting and analytical needs. Read more about who can benefit from Zoho Reports. Follow this link for a detailed discussion on Who should use Zoho Reports?
You can read about the difference between Spreadsheet and Zoho Reports in our solutions page - Comparison with Excel Reporting.
Zoho Reports supports a wide variety of report creation options, which includes:
Yes, Zoho Reports does support dashboard creation. Zoho Reports provides an easy to use drag and drop interface for creating custom dashboards in minutes. Using the dashboard you can display a collection of reports in a single page, providing a quick at-a-glance view of your Key Business Information for easy analysis & visualization. For more details, refer this help documentation.
Currently, Zoho Reports is integrated with Zoho CRM, Zoho Recruit, Zoho BugTracker, Zoho Projects and Zoho Creator. We also offer integration with Manageengine ServiceDesk Plus and Manageengine SupportCenter Plus. We are also planning on providing integrations with other Zoho Services like Zoho Books, Zoho Survey, Zoho Invoice etc in the future.
Zoho Reports is an Online Reporting and Business Intelligence service, therefore yes it can be used as an online database. The features offered by Zoho Reports specialize on providing an in-depth - powerful and flexible reporting capabilities. It contains an in-built analytical database grid, which is optimized for reporting and querying more than just serving as a real-time online transactional database.
The following links will be a useful read:
Zoho Reports supports the following browsers:
The above browsers have been tested in the following platforms:
Zoho Reports also provides mobile optimized apps for iPad and Android tablets. You can refer to ths help documentation to know more.
Zoho Reports is best viewed in 1280 * 720 screen resolution and above.
Zoho Reports user interface is available in nine different languages.
We are working to support more languages.
The Zoho Reports User interface language selection is based on the locale setting in the user`s browser. In case you have a different language setting in your browser, you can change it from the Zoho Accounts page. You may have to wait for 10 minutes, or logout and login again, for the language change to effect in the user interface.
In Zoho we give utmost importance to ensure our customers' data is both Safe and Secure. We have very stringent processes and systems in place to ensure the same. To know more about this, we recommend you to go through the following policy documents:
Zoho Security Practices & Policies: https://www.zoho.com/security.html
Zoho Security Practices An Overview: http://blogs.zoho.com/general/security-practices
Zoho Terms of Service: https://www.zoho.com/terms.html
In case you have any further questions or concerns, please write to us at email@example.com.
The pricing for Zoho Reports starts at $50/month (supports 5 users, 500,000 rows & unlimited reporting databases in the account). There are various plans ranging till $495 per month (50 users, 25 million rows & unlimited reporting databases). Zoho Reports also offers a Free Plan ($0) targeted at small end reporting requirements. It supports 2 users, 5 reporting databases and 100,000 rows in your account.
We also offer bulk pricing packages to suit your needs. Please write to firstname.lastname@example.org with your exact requirements. We'll get back to you with a price quote. You can find more details about the various pricing plans offered by visiting https://www.zoho.com/reports/zohoreports-pricing.html
Yes, Zoho Reports offers an forever Free Plan ($0) targeted at small end reporting requirements. It supports 2 users, 5 reporting databases and 100,000 rows in your account. You can find more details about the various plans Zoho Reports offers, by visiting https://www.zoho.com/reports/zohoreports-pricing.html
The priced plans allow you to store more data (more number of rows) and share the views in Zoho Reports with more number of users based on your plan. Also, it offers a wide range of value added features, which include:
Anyone to whom at least one view in the Zoho Reports account is privately shared is considered a User in the Zoho Reports pricing model. These private users are required to have an account in Zoho Reports and they need to login with their user name and password to access the views shared to them in that corresponding Zoho Reports account. Users are identified by their unique email address, to which the views in Zoho Reports account is shared.
Account Administrator is also considered as a User. When you subscribe a plan with 5 users, then you an privately share the data/reports in your account with 4 other persons for collaboration. Now your Zoho Reports account is said to have 5 users (Admin + 4 users).
By adding new users to your account, you could easily collaborate with them. The Administrator has the complete control on who can access the views. The administrator can grant permission to perform operations such as add, modify and delete data, create new reports and share views within a group, apart from just viewing the shared reports. Shared users will be able to perform only the operation that the admin has granted.
An Account Administrator is the one who subscribes to the Zoho Reports account. The Admin has authority to perform all possible operations available. This includes:
The number of rows (records) is the sum of all rows stored across all your database in your Zoho Reports account. i.e., when you have 2 databases with 3 tables in each of them. And each table contains 100,000 rows. Then the total number of rows in your Zoho Reports account is calculated as 6,00,000 (1,00,000 rows * 6 tables).
Yes, we offer technical support to all our customers. And we do not charge any fees other than the monthly subscription. We do prioritize our paid users request and ensure that it is responded within 24hrs. You can avail technical support through any of the following means:
For more details about support, refer to the Help & Support section.
Yes, we do. Please write to email@example.com with your exact requirements. We'll get back to you with a price quote.
Yes, you can change your credit card details setup for your account. To know how to change credit card details, refer to the Zoho Payments document.
You can find more details about the various pricing plans at http://zohopayments.wiki.zoho.com/Zoho-Reports.html
You can create a Zoho Reports account in less than sixty seconds by just filling up the Sign Up form.
You can change your account setting by following the steps given below:
For more details about your account settings, refer to this link - https://zohosso.wiki.zoho.com.
You can change your password by following the steps given below:
Yes, Zoho Reports allows you to add multiple Email ID's to your account.
To add a secondary email id:
Yes, you can change your primary email id and set one of your secondary email id as primary.
To change primary email id:
You can get more details about your account setup in the following link - https://zohosso.wiki.zoho.com
You can import tabular data from the following file formats:
You can also copy-paste data from all the above file formats as well as from spreadsheets (Microsoft Office Excel, Open Office Calc and StarOffice) files to import the data into Zoho Reports. For more details, refer to Import Data section.
Currently, Zoho Reports allows you to import files (CSV, TSV, XLS, HTML) with maximum 500,000 rows or a file size limit of 50 MB at a time when you use the Zoho Reports web user interface. It will restrict it based on whichever condition is met first. If you wish to upload more than 500,000 rows or a file more than 50 MB at a time, you can use the CSV Upload tool, as it would be more efficient to handle such loads.
For free and trial versions, Zoho Reports allows you to have only up to a mavimum of 500,000 rows in a table.
If you find these limits are constraining to your application needs, mail us your requirements to firstname.lastname@example.org, we will definitely help you.
If you have large amount of data (greater than 50 MB or 500,000 rows) to be uploaded into Zoho Reports, loading them using the Web Graphical Interface of Zoho Reports, might not be the best way. As the upload happens over the Internet, slow or unreliable network connection might cause failures or interrupt the large data upload. In these cases, we recommend the following mechanism:
You could also Zip the file and upload from the Web User Interface, as long as the Zipped file content size is less 20MB and containing not more than 500,000 rows. CSV Upload tool does not have this restriction. But the overall limitation of having a maximum 500,000 rows in a table still applies, when you are in the Free or Trial Editions of Zoho Reports. Please refer #2 for more details on import data size restrictions.
You can upload/push data files from in-house and hosted applications into Zoho Reports. For details, refer to the solution page How to upload/push data from in-house applications.
You can upload data from local databases like Oracle, SQL Server, MySQL, DB2, PostgreSQL, MS Access etc., to Zoho Reports. For details, refer to the following sections:
You can periodically upload/push/import data into Zoho Reports through any of the following supported means:
Yes, Zoho Reports supports relational modeling of your reporting database. The following are the important capabilities that are currently available:
Yes, you can join data tables and easily create reports in Zoho Reports. There are two way to join tables. They are by Auto join and by Query tables.
You can auto join tables using lookup columns and then create reports over these tables. For more details on this refer to the following link:
Help Document: https://www.zoho.com/reports/help/table/joining-tables.html
Using Query tables you can join data from multiple tables in a database using JOIN construct in SQL SELECT query. You can save the results from the query into a new table for creating reports over the same. For more details, refer to the following link:
Yes, Zoho Reports supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL.
You can use SQLs from any of the below methods:
Zoho Reports supports SQL written in a wide variety of popular database dialects. It currently supports Oracle, SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL database dialects.
Yes, you can easily share your data tables, reports and dashboards created in Zoho Reports with other users. Use the Share option within Zoho Reports to share your tables, reports, dashboards or entire reporting database to others users. You just need to provide the email address (Users should have a Zoho Reports account registered with this email address. If they do not have an account at the time of sharing they need to create one using the email id to which it is shared) and set the necessary permission (Read or Read-Write etc.) for the views being shared.
To learn more, refer to Sharing and collaboration section.
You can also make a reporting database public for anyone to access it in a Read-only mode (no permission for editing) or set the necessary permissions (Read Access, Export Data and View Underlying Data) to the views being shared. Refer to the topic Making Views/Database Public to know how to make your data and reports public.
Yes, you can embed tables and reports created in Zoho Reports in your website, web application or blog. Follow the steps below to achieve the same:
To learn more, refer to Embedding Views in Web Pages, Web Applications and Blogs section in Zoho Reports.
Yes, you can allow other users to edit (add, modify & delete data) the data in your database. Follow the instruction below to do the same:
Your data table is now accessible to the shared users for editing. For more details about granting permissions for your user, refer to Granting Permissions to Users section.
Yes, you can allow others to create reports in your database by sharing the data table over which you want them to create reports. You can do this as follows:
Your data table is now accessible to the shared users. And they can create reports over the shared table. For more details about sharing, refer to the Sharing and Collaboration section.
Yes, you can allow other users to upload data in your database. Follow the steps given below to do this:
Your data table is now accessible to the shared users. And they can upload data into your database, by logging into their Zoho Reports account. For more details refer to Granting Permission to users section in Sharing Views to a User topic.
Yes, you can generate a standalone URL (permalink) for the reports created in Zoho Reports. Follow the steps given below to do this:
For more details on this, refer to Creating URLs to Views section.
Yes, you can export your reports & dashboards created in Zoho Reports into various file formats. Zoho Reports supports exporting into the following formats.
Yes, you can email the reports & dashboards created in Zoho Reports as attachments to your users. You can also schedule the emails to be sent automatically at specified time intervals. You can setup this as follows:
You can email multiple reports together.
Currently, Zoho Reports is integrated with Zoho CRM, Zoho Recruit, Zoho Projects, Zoho BugTracker and Zoho Creator. We also offer integration with Manageengine ServiceDesk Plus and Manageengine SupportCenter Plus.
Yes, Zoho Reports is integrated with Zoho CRM. The Zoho Reports Advanced Analytics Add-on for Zoho CRM enables you to analyse your Zoho CRM data and create insightful reports & dashboards easily. It brings all the powerful analytical & reporting capabilities of Zoho Reports into Zoho CRM. For more details, refer to Advanced Analytics for Zoho CRM.
Yes, Zoho Reports is integrated with Zoho Creator. For more details, refer to Creating Data Entry Forms for Zoho Reports using Zoho Creator section.
Yes, Zoho Reports is integrated with Zoho Projects. With the advanced analytics add-on for Zoho Projects, you can easily analyze your Zoho Projects data and create insightful reports & dashboards. This enables you to proactively monitor & manage your projects by tracking the Key Projects Metrics. For more details, refer to Advanced Analytics Add-on for Zoho Projects.
Yes, Zoho Reports has an integration with Zoho BugTracker. The Zoho BugTracker Advanced Analytics Connector Add-on allows you to import Zoho BugTracker data and create insightful reports over them. You can now monitor & manage your bugs with ease by tracking the Key Issue Management Metrics. For more details, refer to Advanced Analytics Add-on for Zoho BugTracker.
Zoho Reports will integrate with Google Adwords in the near future, offering powerful analytics & reporting on the data collected in these applications. We have plans to offer integration with other popular on-demand applications like QuickBooks, Zendesk etc., in the future to come.
If you would like Zoho Reports to offer integration with any specific on-demand service/application or want to know our plans, please do drop us an email to email@example.com
Currently, we do not offer a direct integration with Google Adwords that pulls the data from that service automatically. This is something that we are already working and should be made available in the very near future.
Meanwhile you could still use Zoho Reports for analyzing your data in Google Adwords, by manually exporting the data from Google Adwords and importing into Zoho Reports. Refer to the solution page Google Adwords Reporting and Analysis for more details.
Yes, Zoho Reports offers extensive APIs to integrate any external application with Zoho Reports. The API's offered are HTTP based, which can be used in any programming language. Also language wrappers are provided for Java and Python.
Zoho Reports offers APIs to perform the following actions:
For more details, refer to Supported Actions section in the API documentation - https://www.zoho.com/reports/help/api/index.html
Zoho Reports also offers White Labeled (fully re-branded) version of Zoho Reports to enable integration with product/service offered by Independent Software Vendors (ISV's). For details, refer to the following link - https://www.zoho.com/reports/blog/zoho-reports-white-label-solutions.html
Yes, Zoho Reports supports comprehensive HTTP based Web APIs using which application developers can add, update and query/fetch data in the reporting databases created in Zoho Reports. Using these APIs users could push/pull data from Zoho Reports from/to their own applications enabling easy integration. This would effectively enable Zoho Reports to be a convenient reporting database framework for your applications.
Zoho Reports also support Zoho CloudSQL API technology, which enables users to interact with their business data stored in Zoho Reports through familiar SQL language. Users can access the data in Zoho Reports using CloudSQL from both other cloud applications as well as from traditional in-premises software.
View API docs - https://www.zoho.com/reports/help/api/index.html
Zoho CloudSQL docs - https://www.zoho.com/reports/help/api/zoho-reports-cloud-sql.html
Zoho Reports offers APIs to perform the following actions:
Currently, Zoho Reports supports the following programming language libraries to enable developers to easily use Zoho Reports API in the corresponding programming language:
For more details, refer to Client Libraries section.
Yes, Zoho Reports supports API for sharing. To know more details about share API, refer to Sharing section in the API documentation - https://www.zoho.com/reports/help/api/index.html.
Yes, Zoho Reports supports re-branding. Zoho Reports provides two types of re-branding. They are Logo re-branding and Complete re-branding ( white labeling).
Logo Re-branding enables you to customize the Zoho Reports product logo that is displayed within the Zoho Reports service. This support is available only in paid plans of Zoho Reports. Using this feature you can replace the Zoho Reports product logo displayed in the service and also change the powered by logo displayed as footer of the reports when you export them (as PDF or images) or embed them in other web pages.
Follow the steps given below to change the logos :
Complete Re-branding (White Labeling):
Zoho Reports also offers a white labeling solution with which you can completely re-brand Zoho Reports to serve from your custom domain and seamlessly integrate with your application. For more details refer to the following question.
Zoho Reports offers a full-fledged white labeling solution. With the white labeled solution, you can completely re-brand Zoho Reports to serve from your custom domain (URL), in your own brand, seamlessly to your users. This enables application developers, Independent Software Vendors (ISVs) and solution providers to integrate powerful reporting & business intelligence capabilities into their applications/products seamlessly. For more details refer - Zoho Reports: White Label Reporting.
Yes, independent software vendors (ISVs) can integrate with Zoho Reports. Benefits of integration with Zoho Reports:
Read more from our website.
Take a tour for a quick understanding of the product. Also refer to the following links, to know more on the features of Zoho Reports:
Online Video Demos: https://www.zoho.com/reports/Video-Demo.html
Zoho Provides e-mail & telephone support. You can submit your request here in the online form.
You can also mail your questions to firstname.lastname@example.org or call us at our toll free numbers
We will respond to you as per our support policy.
Yes, Zoho Reports does offer telephone support during business hours (please refer our support policy). You can call us on our toll free numbers
You can interact with Zoho Reports user community through Zoho Reports User Forums.
Yes. Zoho Reports offers mobile optimized apps for iPad and Android Tablets available in the Apple App Store and Google Play Store respectively.
The key difference between Zoho Reports and Zoho Creator is in-depth reporting and analytics vs online custom database application creation.
Zoho Reports enables you to easily create powerful and sophisticated reports with your data by creating online reporting applications. It enables you to slice & dice your data for in-depth visualization and business intelligence. Zoho Creator enables you to quickly create a powerful online database application to collect data and trigger work flows through forms and scripting.
Zoho Reports could act as a convenient back-end reporting/analytical database for your application needs. You can get data into Zoho Reports through manual data entry or bulk load data from files or upload data stored in your local databases (like MS Access, Oracle, SQL Server, MySQL, DB2, PostgreSQL & MS Access) or schedule for periodic upload of data or push data from your application through Web API (HTTP based) for reporting and analysis. Here the crucial difference is that, while Zoho Creator offers a hosted programming environment (with a DB backing), Zoho Reports offers a powerful reporting layer (backed by an analytical database) for your application data.
Zoho Reports also supports full-fledged relational modeling (similar to relational/analytical databases) for powerful reporting. It currently supports relational modeling functionalities through Lookup columns. With lookup columns you can relate one table with another. It also offers cascade-on-delete functionality whereby when a row in the parent table is deleted, it will automatically delete all the related rows in the child table(s). Click to know more on Zoho Reports Relational Modeling Capabilities.
The other key difference is that Zoho Reports embraces SQL, and supports all major dialects of it. This enables users to do sophisticated querying on the data for creating powerful reports. We will flesh out this functionality even further in future updates.
Please read the FAQ #2 before you read further. If you require a quick application development environment, with forms, scripting, workflows and basic reporting, opt for Zoho Creator. If you require a powerful online reporting and analytics service with an inbuilt analytical database support, opt for Zoho Reports. Zoho Reports also supports Web based APIs using which you can build your own forms and push/update/pull data into Zoho Reports from any of your applications.