2008

2008: What's New in Zoho Reports?

Trail on Zoho Reports feature and service evolution in the year 2008.

December 2, 2008

Zoho DB & Reports Web API

November 4, 2008

Folders and Reports Explorer
Auto Number

October 23, 2008

Embed Interactive Chart

October 9, 2008

Scheduled Periodic Import of CSV files
Zoho DB & Reports Integration with Zoho Creator - Step 1

September 20, 2008

Query Table - Auto Refresh
Charts - Data points highlighting for better visualization

August 9, 2008

Easy to filter legend values in a Chart
How to filter a legend value?
Hide Data Type icons on the Table headers during Embed

July 19, 2008

Export multiple reports into a single Printable PDF
How to Export multiple reports into a single PDF
Data Type icons on the Table header

July 14, 2008

Format you Columns
How to format a column?
Customize Chart Coloring
Auto-recognizing currency data during Import

June 19, 2008

Print your Reports

June 2 , 2008

Template to Analyze your Google Adword Performance with Zoho DB and Reports
More intelligence & convenience for designing Chart/Pivot/Summary views
Export Chart as Image
Filters & Search across all tabular views
Color your Zoho DB & Reports interface with Themes

April 19, 2008

Copy Database
Save your Filters
Enhanced Templates
Specify Interval between Axis Labels in Charts
New Theme and Layout for Charts, Pivot and Summary reports

March 7, 2008

HTML Import
Right Click Popup Menu in Table and Tabular Views

Febraury 19, 2008

Min/Max Support in Charts

Febraury 6, 2008

Filters and Search Support
Support for data in Multiple Character Set
New Chart Types
Groups support for easy Collaboration

October 3, 2007

Public Release of Zoho DB & Reports Beta

December 2, 2008

Zoho DB & Reports Web API:

Zoho DB & Reports provides REST style Web APIs over HTTP. With this API, users/developers can extend their hosted as well in-premises applications to push or pull data into or from Zoho DB & Reports for powerful analysis and reporting.

The API allows you to:

  • Add data into a table in Zoho DB & Reports database
  • Modify data in the Zoho DB & Reports database
  • Bulk Add/Update data into a table via CSV file.
  • Bulk Update with criteria support.
  • Bulk Delete with criteria support.
  • Export data and Reports in various formats such as CSV, JSON, PDF, HTML, IMAGE
  • Fetch data from the database using SQL Select query using Zoho CloudSQL technology

Click to read more on Zoho DB & Reports API

Nov 4, 2008

Folders and Reports Explorer:

We have rolled out Folders support along with Reports Explorer in this update. User could create folders within a reporting database and organize their reports in a logical manner.

To enable better navigation we also support a 'Explorer' tab which provides a detailed view of each report and tables present in a database. The Explorer tab will be the default one that would be shown when you open a database. This tab cannot be closed.

Highlighting features of Folders include:

  1. Support for creating Folders by the database owner. Folders could also be created by users who are present in the DB Group of that database.
  2. "Tables & Reports" will be the default folder created. This cannot be currently deleted or renamed
  3. You can create new folders using the Create New Folder option seen in the top right corner of the Explorer tab
  4. You can move reports across any folder using the Move Folder option that would be shown in the menu that pulls out when you click on the options icon which appears on mouse over over each report in the Navigation tree or Explorer tab.
  5. When you share a report under a folder, the folder will also appear to the shared user. Within the folder only the reports shared to the user will appear to him/her.
  6. Apart from folder based organization, we also support Group By Related Views and Group by Report Type. This two options would be listed in the drop list on the top of the Navigation tree seen on the left.
  7. Currently only one level of folders could be created. Folders within Folders are yet to be supported.

Auto Number:

We support a new data type Auto Number. This is useful if you require a column to contain auto generated incremental numeric values, which are unique. This would be helpful when you need to have a unique identifier associated to each row/record in the table.

Auto Number features:

  1. Auto Number column value starts with 1 and each new value will be incremented by 1.
  2. Auto Number values will/should always be unique
  3. If data is imported into the table with the auto number column in it, the following will be done by Zoho Reports:
    • Verify whether the values are numeric (not decimals)
    • Verify whether all the values are unique (if not the import will be aborted)
    • Zoho Reports will find the maximum value for the column in the data imported. Then for any subsequent row addition Zoho Reports will add maximum value + 1 as the next auto number.

October 23, 2008

Embed Interactive Chart:

Till now when you embed a chart into your web application/blogs/website, Zoho DB & Reports will generate an Image, which gets embedded. The embedded chart will just be an image without any interactivity i.e. you cannot view details of a point on mouse over or see visual highlight of the point on mouse over or view underlying data on clicking a point in the chart. Still Zoho DB & Reports will keep the embedded chart image updated with the latest data as when you refresh the web page in which the chart is embedded.

Now Zoho DB & Reports also provides an option to embed a chart with interactivity enabled. Follow the below steps to embed an interactive chart:

  1. Select the Chart that is to be embedded
  2. Click on "Publish -> Embed in Website/Blog..." menu in the toolbar
  3. A share dialog will popup with options
  4. Select the radio button "Embed as Interactive Chart"
  5. Set the necessary options listed below (Width, Height, Theme, Toolbar)
  6. Copy and paste the code snippet given in the text are below into your web page/blog where you want to embed the chart.

October 9, 2008

Scheduled Periodic Import of CSV files:

Zoho DB & Reports can now periodically fetch data in CSV format from any accessible Web URL. This would be really useful in scenarios where you have new data being published or updated periodically and you would like get those updates inside Zoho DB & Reports for reporting and analysis. Till now you had to re-import this data manually into Zoho DB & Reports, every time an update is available. Now you just have to setup up the periodic import feature and Zoho DB & Reports would do the rest for you.

Zoho DB & Reports Integration with Zoho Creator - Step 1:

Using the Scheduled Import feature you could also (enable Zoho DB & Reports to) periodically fetch data from your Zoho Creator Application into Zoho DB & Reports as changes happen to the same. As the latest data is made available inside Zoho DB & Reports, you could create any type of powerful reports with it. The reports created using Zoho DB & Reports could also be embedded back inside your Zoho Creator application using the new HTML Page view feature introduced in Zoho Creator 3.0

Checkout the blog post for more details on the above said features

September 20, 2008

Query Table - Auto Refresh:

So far when you create a Query Table based on an SQL (Structured Query Language) query, the data in the Query Table (resulting from the execution of the query) would be re-fetched only on users manually clicking the Refresh button in the Query Table UI. What this means is, when the data in the underlying tables queried keeps changing, the query table data will not be automatically synced up to reflect the changes. This also makes the reports created over this Query Table remain stale or old till the user refreshes the Query Table manually.

We have removed this limitation with this update. From now on, the data in Query Tables will always be current reflecting all the latest changes done to the underlying tables on which the query is executed. No need for manual refresh by the users any more.

Charts - Data points highlighting for better visualization:

To enable better visualization and analysis of charts, we have provided 3D highlight effect on data points in the graph. When you move your cursor over any data point in the graph, we will now highlight the corresponding point/bar/pie slice in 3D for better visualization. In the case of line charts, the corresponding line will be highlighted to stand out from other lines plotted.

Also when you move your cursor over the legend values, all the corresponding data points plotted in the chart for that legend value, will be highlighted to differentiate it from the other data points.

August 9, 2008

Easy to filter legend values in a Chart:

Recently we provided an option to customize the colors in a chart from the legend. Now we have also added another useful option to filter the chart based on the values listed in the legend. If you would like to either remove a value listed in the legend from the chart or only retain that value and remove the rest you could easily get this done now. Although it was possible previously, now with this feature it has been made much simpler.

How to filter a legend value?

  1. Select the Chart which has to be filtered
  2. Click Edit Design and go to edit mode
  3. Click on the legend value that is to be filtered
  4. A menu will be pop up
  5. If you would like to remove this legend value from the chart, select "Filter this value". If you would like to remove all other values from the chart except this one, select "Filter excluding this value"
  6. Click Click Here to Generate Graph link to generate the chart with this new filter applied

Hide Data Type icons on the Table headers during Embed:

We have now added an option to hide the data type (/column type) icons displayed in the table header, when you embed the same in another web page. You can do this by checking/unchecking the option "Include Data Type Symbol" in the "Publish -> Embed in Website/Blog" menu option of the corresponding Table or Tabular View to be embedded.

July 19, 2008

Export multiple reports into a single Printable PDF:

Recently we added a feature to export your report into a Printable PDF file. Now we have enhanced this feature to export multiple reports into a single PDF. This would be very useful when you either require to collate selected reports into a single file for reference or to take a print of all the selected reports in one go.

How to Export multiple reports into a single PDF?

  1. Select the "Export -> Export Multiple Views" menu found in the toolbar of all views in a database
  2. You will see a PDF Export settings dialog
  3. Provide the necessary settings like file name, page size, margins, footer and header
  4. Check the option "Generate TOC" if you want Zoho DB & Reports to automatically generate Table of Contents
  5. Select the views to the exported from the list "Select Views to Export". You could also order the sequence using the Up/Down arrows provided
  6. Click OK to generate the PDF
  7. Save the PDF file generated into your local folder or Open it from within your browser

Data Type icons on the Table header:

Another simple usability enhancement has been rolled in with the addition of Data type (/column type) icons in the header of both Tables and Tabular Views. This would enable users to immediately recognize the type of the column with not much effort.

July 14, 2008

Format you Columns:

Zoho DB & Reports now offers a wide variety of formatting options for each data type. With these options you can now choose how you would like to have your data displayed in the various reports created.

How to format a column?

  1. Select the table or tabular view in which the columns are to be formatted
  2. Right click on the column that is to be formatted
  3. Set the necessary formatting option in the dialog that pops up
  4. Click OK to apply the formatting changes

Customize Chart Coloring:

In Zoho DB & Reports the colors used in charts have been system generated so far. With this update you can now change the colors used in a chart to suit your taste. Follow the below given simple steps to customize the color in a chart:

  1. Select the Chart whose colors are to be customized
  2. Click Edit Design and go to edit mode
  3. Click on any of the category colors listed in the legend (seen on the right side of the chart) to change the same.
  4. A color chooser will be poped up
  5. Choose the color required
  6. Click Apply to apply the color Or Click on Use Default if you would like to revert to system generated colors.

Auto-recognizing currency data during Import:

Now Zoho DB & Reports has included the intelligence to auto-identify a data column as currency when you import it into Zoho DB & Reports. Auto-recognition would be applied when you import data into Zoho DB & Reports from any of CSV or .XLS or HTML files. The data could be in any of the accepted currency formats (with currency symbol or abbreviation eg., $, USD etc.,) of any country.

June 19, 2008

Print your Reports:

How to Take a Print in Zoho DB & Reports?

  1. Select the report to be printed from within Zoho DB & Reports
  2. Select the "Export -> Export as PDF" menu
  3. You will see a PDF Export settings dialog.
  4. Provide the necessary settings like file name, page size, margins, footer and header
  5. Click OK to generate the PDF
  6. Save the PDF file generated into your local folder or Open it from within your browser.
  7. You could print the PDF generated anytime.

June 2, 2008

Template to Analyze your Google Adword Performance with Zoho DB and Reports:

  • Zoho DB & Reports provides a default template, named "Google Adword Campaign Performance Analysis", for analyzing your Google Adword Campaign Performance.
  • This template database provides insightful reports that would enable you to easily analyze your Google Adword Campaign Performance. You could also create your own reports for further analysis.
  • A Sample Database of the same name is also available which you could use for your own Adword data for analysis.
  • Checkout a detailed documentation on How to use Zoho DB & Reports to analyze your Google Adword Performance?

More intelligence & convenience for designing Chart/Pivot/Summary views:

  • So far while designing chart or pivot or summary view, you had to drag and drop fields listed on the left to the right and construct the view.
  • Now we have provided checkboxes to just select the fields that are to be used to design the chart. This is apart from the existing drag and drop support.
  • Zoho DB & Reports intelligently identifies the appropriate position to place the selected field in the design area.
  • Also, as another step of intelligence Zoho DB & Reports even selects the right function to apply on the field which is added to the design area.

Export Chart as Image:

  • You could now export and save your chart as either a PNG or JPEG image
  • While exporting you could set the dimension of the image, as well as specify whether to include the title and description of the chart in the image generated.

Filters & Search across all tabular views:

  • Quick Filter option was so far supported only in Tables.
  • Now you could do Quick filtering across all table based views in Zoho DB & Reports. This includes Tabular Views, SQL Query table and tables shown for displaying View Underlying Data in Charts, Pivots and Summary Views.

Color your Zoho DB & Reports interface with Themes:

  • Zoho DB & Reports now supports themes. You could apply the theme you like by choosing the "Themes" menu at the right top corner of the screen.
  • Currently we have only two packaged themes available. More to come very soon....
  • The theme you choose will be set to your preference and applied across logins.

April 19, 2008

Copy Database:

  • You can now create a copy of a Zoho DB & Reports database.
  • Copy Database feature also provides an option to make a copy with and without existing data. If you copy without data then only the tables and report definitions are copied. If you copy with data then all tables, reports along with existing data in the database would be copied.

    You can copy a database following the steps given below:

    • Goto "Existing Databases" section in the home page
    • Under each database that is listed you will find an link "Copy"
    • Click on the "Copy" link for the database that you wish to copy
    • It will popup a dialog where you could provide the name and description for the new database that is to be created
    • Check/Uncheck the "Copy with Data" option depending on whether you would like to make a copy of the database with tables, reports and existing data OR just the tables and reports definition alone

    With this option you could also copy any of the demonstrative Sample Databases that is provided by Zoho DB & Reports.

Save your Filters:

  • You can now save the filters that you do on a Table. With this option you could save frequenly used filters and apply them anytime on the table without the need to re-type the search criteria everytime.
  • Saved filters would be listed under the "Filters" menu option in the tool bar.

Enhanced Templates:

  • We have enhanced the default templates provided namely, Issue Manager and Project Manager templates, with useful set of default reports.
  • While creating a database from templates you could also choose to "Populate with Sample Data" which would enable you to easily understand the features offered by the template database.

Specify Interval between Axis Labels in Charts:

  • You can now specify the interval between axis labels in a chart.
  • Currently supported only for numeric columns and only in Line and Scatter charts
  • No support available for Mult-Y charts.

New Theme and Layout for Charts, Pivot and Summary reports:

  • We have enhanced the theme and layout for Chart, Pivot and Summary reports. Hope you like it.

March 7, 2008

HTML Import:

  • You can now import HTML table contents into Zoho DB & Reports.
  • Enables importing data in any HTML table into Zoho DB & Reports as you import CSV data.
  • The HTML file should contain atleast one Table inside it for importing

You can import data from a HTML file through any of the following means:

  • Copy/Paste the HTML code into the Import Wizard
  • Load a HTML file from a local folder
  • Load a HTML from an accessible Web URL

Right Click Popup Menu in Table and Tabular Views:

  • You can now access most of the operations in Table and Tabular View by Right Clicking on the Table header and accessing the options listed in the popup.

February 19, 2008

Min/Max Support in Charts:

  • You can now specify the minimum and maximum range of points in a chart.
  • Currently supported only in Line and Scatter charts.
  • No support available for Mult-Y charts.

February 6, 2008

Filters and Search Support:

  • Now you can filter or search data in the table using the “Filter“ option in the tool bar. We have provided variety of options to filter the data based on the type of the column

Support for data in Multiple Character Set:

  • You can import data in different character set and do any type of data manipulation and reporting.

New Chart Types:

  • In our first release we only had 5 types of chart supported (basic Pie, Line, Scatter, Bar and Table). Now we support 14 chart types including Web Chart, Stacked Bar, 3D Pie, 3D Bar etc.,

Groups support for easy Collaboration:

  • Now you could create a Group for each database and associate a set of users within it. View creation, sharing etc., could now be done easily at the group level rather than at each user level. This would facilitate much easy collaboration in a team environment.

To know more about this update please refer to our blog post

Check out updates in: 2017 | 2016 | 2015 l 2014 l 2013 |  20122011 | 2010 2009 | 2008 2007