'GROUP BY' options
are 'GROUP BY' options, such as GROUPING SETS, GROUPING ROLLUP, and CUBE, supported?
Forcasting API
Hi I am thrilled at the capability of zoho reports and I can only assume that it will grow to be the best business intelligence app...period... What would be cool is if Zoho could team up with Lokad (http://www.lokad.com) via their API and allow zoho report users to submit their data to Lokad for all kinds of forcasting requirements. Business Intelligence combined with a forcasting and statistical app would really make Zoho reports the best BI implementation out there Another cool thing wouldbe to
Reports and RSS or XML Feeds
Hi Was wondering if it is possible to obtain an rss feed of a table in Zoho reports. I have setup a query table that combines some well needed data for analysis purposed which included geo data. I would like to know if there is a way to obtain an rss feed of this table (Not export to csv) so that I can ass it through google maps for visual analsis of our custoemr base. Please advise. It would be great if Zoho reports could have its own map service or integration with third party mapping services.
Can you copy a database?
I've set up a database where student data can be analysed by various reports. I want another teacher, to be able to copy the database, to use the ready-made reports - not to share the data (which would be different). Is it possible for someone else to copy this public database? I can only see this option with the sample databases provided.
Questions about sharing databases
I have two questions about sharing Zoho Reports databases. First, in my home view, I don't have the option of sharing an entire database. Second, when I share a specific data table or query table with a co-worker, he can create reports from the data, but he can't export those reports. It says he doesn't have permission, even though I have granted every permission possible. Thanks for your help.
How to Create Dashboards in Zoho Reports - Presentation
We made a How-To presentation for the dashboard functionality in Zoho Reports. Hope you find it useful when working with dashboards.
Query Table - Missing Fields for Filter
Hi, I have created a query table linking two tables and that all works fine. When I create a chart or edit an existing one created automatically, not all the fields on the query table are available as a filter. I cant see an obvious reason for the fields not being available. The SQL for the query table is: SELECT "Due Date","Pharmacy Group Name","Total","VAT","Invoice Paid","Paid Date" FROM "Invoice Items" JOIN "Invoices" ON Invoices."ID" = "Invoice Items"."Invoice ID"
Specify JSON output format and callback function name on "ticket" request
In the API, when requesting a "ticket", it would be really useful to me if I could specify JSON as the output format and a callback function name. Currently, the "ticket" request takes the format: https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=zohoUserID&PASSWORD=zohoUserPassword And the response takes the format: # #ddd mm dd hh:mm:ss PST yyyy GETUSERNAME=null WARNING=null PASS_EXPIRY=-1 TICKET=abc123xyz RESULT=TRUE Ideally, the "ticket" request would take the format:
Upload Tool Permission for Shared User
Hi. I'm trying to upload csv files with the upload tool console using the credentials of a user that is not the owner of the database, but has all permissions for read, write and import. But I get this error: Error!!! Database not found! Please check whether the database exists Exception in thread "main" ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/hotlobatest/GasAca/Diario, Action: IMPORT, Message: Database not found! Please check whether the database exists) at com.adventnet.zoho.client.report.BaseClient.sendRequest(BaseClient.java:102)
Speed Performance of Query Tables
We are doing a query table as a join between two tables using a positive number column to join on. One table is 36420 rows and the other54214 rows. When ever an update is done to the underlying tables the Query table refreshes, great, but the refresh takes minutes and data from the query table are not available during this. Are there know limits to keep within for Query tables to perform or any tricks that can help speeding this up?
Zoho report client API for Java Spring integration
The spring-zohoreport project aims at simplifying the use of the Zoho Report Java client libraries and wrap the client configuration with the Spring framework bean configuration. So far, only Zoho Report client libraries can SELECT, UPDATE, INSERT and DELETE datas whereas Zoho CloudSQL (so JDBC driver ) is limited to SELECT. This project uses Spring IOC container to manage Zoho Report client as a bean. An introduction in french : http://jclagache.blogspot.com/2009/12/integration-de-lapi-zoho-report-dans.html
Refetch/Schedule Import Not Available
I have recently upgraded my account from Free to Profressional Plus, but I do not seem to be receiving the unlimited Scheduled Imports, as I created a new Report Database and the Refetch/Schedule Import option is not available under Import. Can this please be resolved as I need to schedule some imports. Glenn.
Creating New Users in Zoho Reports
Using a free account to test Zoho Report for further use I'm trying to create a second user and let that users use a database I have created. Under subscription I add a user and I'm only asked to provide an email address. I then share the database with that user. However the user can not login as he does not have a user name and when he tries to use forgot password he get a message that the email account does not exists. What are the correct and complete way to create a user? could not find information
How do I add calculated fields in a table (like in a spreadsheet)
I have a table and I'd like to add a field that is calculated based on the values of other fields (like I could in a spreadsheet). Is this possible? I am pretty sure that I could do this with a query table, but I'd like to avoid using SQL if there is an easier alternative. I guess what I'm looking for is something more like a cross between database tables and spreadsheets. Any suggestions? Thanks,
Zoho Reports is out of Beta! Pricing Plans Announced
Hi Zoho Reports Users, A happy news to share! Zoho Reports has now moved out of Beta. As part of it, we have also announced the pricing plans and other new features such as Dashboards and iGoogle embed. You can checkout the complete announcement in this Zoho Reports Blog. At this special moment we wanted to thank all our Beta customers, for all the support extended so far and for all those GREAT feedbacks. We were here because of YOU. You can checkout "Your Current Plan" details by logging into
Using Fusion Charts With Zoho Reoprts
Hello. Would you enable easy use of Fusion Charts? http://www.fusioncharts.com/ Moreover you could apply Fusion Charts Free Edition in your system so all we'd have to do is embed. You can also add the feature into Zoho Sheets. Thanks.
Combine rows in a report
I have a table that has the following columns: DATE | TEAM | PROJECT CATEGORY | WORK COMPLETED | HOURS and has data like this: DATE | TEAM | PROJECT CATEGORY | WORK COMPLETED | HOURS {date} | {team} | Non-Chargeable Work | Service Request | 2 {date} | {team} | Non-Chargeable Work | Support Incident | 4 {date} | {team} | Chargeable Work | Delivery | 2 {date} | {team} | Non-Chargeable Work | Support Case Mgmt | 6 For a report, i would like to combine
Can't figure out where I'm going wrong
Hi Everyone, Here is my situation: I have a form where I book interpreters three of the controls on this form are: dtmStartTime (Date/Time field) dtmEndTime (Date/Time field) cboAssociate (Picklist) What I would like to do is when the user selects a start time (the end time is set automatically by code), I want the database to check through each record to see if the associate has a conflicting job. (example of values below): cboAssociate | dtmStartTime | dtmEndTime Bob
Importing Error: Unexpected error
Hi, I'm trying to import data from a CSV file. I can import the data once, into a new table. But when I try to upload further data into the same table, I receive the following message: Error occurred. Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the 'Feedback' link at the top of this page. The data then does not load. I am receiving this
Email module in Reports
Hi, Under my reports tab I don't see the Email module. According to the Help section, email is shown as a primary module. This would be very helpful. Am I missing something? (yes, I have email enabled as a POP and set as an active tab) Thanks
Can I use Zoho Report to consolidate many large Excel pivot tables ?
Hi all, We want to consolidate the pivot table (with same fields) in several large Excel file (~25-30MB) into 1 pivot table. Can we do that via Zoho Report ? I tried to upload the file but the current edition just allows up to 3MB Excel file. Is there anyway to upload bigger size (say professional edition) ? Thanks
The Upload tool always stuck after uploading 5000 rows
Hi, I tried Upload tool in Windows 2000 and retrieved data (> 5000 rows) from an MSSQL server then upload to Zoho server. It always hang (nothing happened) after showing this "Uploading query #1 data into Zoho reports" I checked on the table in Zoho and 5000 rows were inserted but my result (queried from MSSQL got more than 5000 rows). I did try Upload tool in some other environment with Windows XP and it passed the 5000 rows 1st upload. So not sure if it's because of the OS or any other things
Trying to get a Join to return null values
I'm sure I'm doing something stupid here, but i've been struggling with this query for ages so I've got to give up and ask! I have two tables that i'm trying to create a report with. 1. A users table, with two columns - a user ID and a staff member name 2. A time entries table with 3 columns - the user's id, the date, and the number of hours (i've simplified the tables to just the columns i'm worried about) I want to run a report that allows us to see who hasn't filled out their time for any
null values
I have the following table Amount Category Sub category $5.00 Entertainment $5.00 Groceries $5.00 Entertainment Entertainment-Lunch I have a SQL table that tries to spit out a pivot like table SELECT CASE "Sub-Category" WHEN NULL THEN "Amount" ELSE 0 END AS "Unclassified", CASE "Sub-Category" WHEN 'Entertainment-Lunch' THEN "Amount" ELSE 0 END AS "Lunch", "Amount", FROM "t_expenses" WHERE "Category" = 'Entertainment' this should output Unclassified Lunch
Is it possible to let Openoffice Base use a table in Zoho Reports through JDBC?
Has anybody done that? Or just knows how to do this. The Openoffice Database Wizzard asks for information to set up the connection. Could something like this be used (in combination with an URL referring to a ZohoReports db ) DriverManager.getConnection("http://reports.zoho.com/api/david/Sales?apikey=abcd&user=david&password=davidpwd"); Thanks, jstamuller
handling of special charactersets
HI! The special Danish characters 'æøå' appears correctly on screen but not alphabetized correctly. I have created a small database with Danish titles. It appears that the 'å' when sorting comes before 'a'. 'æøå' are the last three letters in the Danish alphabet. I also think that these characters are exported incorrectly because when I try to import a .csvfile of my database into Access and Excel (version 2003), the characters 'æøå' becomes garbled. Are there problems with the handling of special
Wont't save Report after entering data during a filter
In order to help me enter data more accurately, I will filter using a certain characteristic. Recently, using IE, I cannot filter, input data and then save. The save function does not work under a filtered view. There is an asterisk in the tab denoting that Zoho recognizes changes, but when I click the Save button, nothing happens (no popup box, no reports of successful saves, etc). The asterisk denoting changes still remains, but there is no way of saving without closing, losing the data and
XSS error when importing to database
When I try to import data into a table using Zoho Reports, I get the same error message below regardess of the format I try to import it in (csv, txt, xls, etc, etc etc). How can I fix this so I can upload a simple spreadsheet into the table???? XSS has been detected in the content of the parameter TABLECONFIG
SQL sum error
I have two queries: 1. SELECT 'Total', sum("Units sold grouped by country"."UnitSales") FROM "Units sold grouped by country" Result: Total | 1051 2. SELECT 'Total', sum("Top 10 Countries"."UnitSales") FROM "Top 10 Countries" Result: Total | 806 So, you can imagine what I'd expect if I tried to merge the two into a single query: SELECT 'Totals', sum("Units sold grouped by country"."UnitSales"), sum("Top 10 Countries"."UnitSales") FROM "Units sold grouped by country", "Top 10 Countries" Result: Totals
Issue with importing into a table with Lookup Column
I have a column in a table that is tied to a Lookup Column. When I import data either through copy/paste or CSV File, the Lookup Column is left blank when the text is 20 characters or longer. It works as expected for my text that is 17 characters and 9 characters, but fails when I hit 20 characters. The current work around is to remove the Lookup Column restriction on the column, do the import and then switch the column back to a Lookup Column. All my data is retained as all the items are indeed
Report for Text -only data
I have had an MS Access database for many years for the purpose of making and tracking workorders. In its simplest form this could be records made of text fields, no numeric values. I have several Queries, Forms and Reports within the database for different views and filtering of the information. Because none of the data is numerical there needs to be no calculations.When I upload the Access database to Zoho Reports only the Tables are uploaded - no Queries, Forms or Reports. I have not been able
Copying
Is there a way to copy the above data in the same field? I think in Access it was ctrl ' or something like that.
How large can a table grow?
Hi I have an application that can have tables with several 100 million entries. What are the limits on the Zoho tables size? By number of rows or size of the table or total number of data elements. Please advise if there is any special way to handle such large data stores. Thanks Anand
Problem referencing one query table from another
The screen shot above shows that I am trying to reference one query table from another and getting the message "Unknown table or alias" can you explain why this is and is there a workaround? Trevor
RSS feed or Scheduled email from Zoho DB
Hi, I have created a table in zoho db and it get updated with data ( more rows added) every hour. I need to get an RSS feed or a scheduled email that contains a report with the new rows. Can you please point to an example of how this can be accomplished ? I will be happy to pay you a fee to help me with this. Thank you Anand
Import from Zoho creator issue
I can't get the import working at all. I can get it working but the database can't display columns properly. From creator: export as csv feed, copy html (no login prompt) in DB & Reports: import csv (url) Then I can't get the database in the right format at all, be it by comma, semi-colon, tab... doesn't matter what I select it is all wrong. Interesting thing is that if I export from creator as xls (not csv), open in Excel, save as csv and THEN import in DB & Reports it is all fine. But I lose the
Subquery issue
I have a table called STATUS that has a column named BUILD. The build column is integer and populated with values between and 1 and 6. The following subquery in a NEW_QUERY_TABLE: select build from ( select build from status ) subquery returns the error 'Invalid column 'build' used in SELECT query.' This is valid SQL that I have tested in PostgreSQL. Is this unsupported?
Remove "ticket" from mandatory parameters on EXPORT API calls
I want to display data from my Zoho Reports database on my website. My plan was to use <script> tags for the API call (i.e. the HTTP request) and then, by specifying a JSON callback function, to manipulate the data in the response using Javascript. However, this isn't possible because I need to include a "ticket" parameter in the API call. I can't request the "ticket" programmatically because I think that would mean storing my Zoho username and password openly on my web server (unless anyone can
Zoho Reports and Word Docs
HI All, Loving the features of both Zoho Reports and Zoho Creator. Could anyone assist me with the following.... I have a Word document that i have to send out to a client once a week that looks all pretty (uses client logos and a weekly preamble blah blah blah). Many of the Graphs and Data Tables that i can create on Zoho Reports also need to be placed into this volumous Word Doc. Is there any easy way to either populate the Word doc automatically with these Graphs and Data Tables or even an easy
Reports is not running under Firefox 3.5.2
I have a problem with zoho reports running on FF3.5.2. I get the left hand navigation bar that shows my recently used reports but I do not get the report view in the centre pane. None of the menu items work (new save edit design etc) but home | what's new etc are still active. I can either run this in IE8 or run it in FF in IE mode both of these options are frustrating because I have to log in on the different browser regards Trevor
Next Page