Adding results of columns evaluated with IF('Column1' = 0,'0','1')
I have a table whose records represents club attendee stats per month which includes (among several other fields) 5 fields representing the number of attendees per week of the month. Eg. Week1 = 20, Week2 =22 etc. I need to create a query that tells me the running average amount of weeks (not attendance) all clubs met per country. Some of the weeks have zero attendance, so it's not a straightforward calculation. Note: There are no null values, weeks with no attendance have a "0" in them. Fields/Columns
Importing Zipped CSV file
Hi, I have been trying to import CSV file, which size is 3.5MB. I know that Data size should be less than 3 MB and the number of rows should be less than 100000, when importing data. So I zipped the CSV file into a Zip file, which size is 439kB and try importing it as instruction stated in Create Database(import) Dialog. But still get the error saying Data size should be less than 3MB and the number of rows should be less than 100000, Could I import more than 3MB CSV data with making it zipped
Zoho reports stoped working - cannot access reports or dashboard
Hi I have sent various support requests relating to my zoho reports issue without response. The support number is always busy and thus hope that I would be able to get some help here. All my zoho tables, queries, charts and dashboards were working until the past Monday when I imported new data. I am unable to view the reports, dashboards and query tables of some of thecreated reports. All I get is a processing message which hangs even if I close the tab. After a while I get the message that the
How do you query a multi-value field such as one imported from Creator
I get an "invalid column used in SELECT query" error when trying to do a SELECT query on any field containing multiple values that I have imported from Creator. For instance a Creator check box multi-select field. How should I query these type of fields?
SQL for Custom Report
Last time I wanted to run a custom report (workstation & last log-in) I put the question out on your old forum and got a reply in under an hour with the SQL I needed to run. I have to say that, since you changed your forum, no one has answered a single question of mine. Any suggestions on how to get help with writing custom reports if you don't happen to be a SQL person?
if(response=SUCCESSOK,24,0) ... if(response=SUCCESSOK,24,if(response=NotBehind,10,0))
I want to add a formula column that assigns a numeric (currency) value based on a string of text in another column. I have a column named response with the following possible values: SUCCESSOK; FAILED - 1,-1,24 = -1; FAILED - DUPLICATE; FAILED - Requirement; FAILED - VULGAR; NotBehind. I would like to add a formula column named revenue that assigns a revenue value based on the response value (for example: SUCCESSOK=24, FAILED - DUPLICATE=0). Is there a way to do this with Zoho DB & Reports? Thank
Suppress grand totals on pivot reports
Hello. Is there any way to suppress column or row totals on pivot reports? On the vast majority of the views I am interested in, only one of these matters to the report. I would love to be able hide the one that is irrelevant to the data. Thanks,
Zoho Charts And Graphs
Hello. I would like to suggest a new service. I'm writing a blog on technical issues and I've found my self using too much of Excel Graphs (As Images). I've been searching for attractive way to illustrate graphs and found many applications such as: Fusion Charts GraphZX amCharts And many more (You may watch some here - http://sixrevisions.com/flashactionscript/10-useful-flash-components-for-graphing-data/#more-639). The problem is they are too complicated to make. You have to create XML file, Be
'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.
Next Page