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
Refetch from Creator not working.
Dear Sirs, I'm reporting an issue where I haven't been able to refetch information from zoho creator. It has been working successfully before, but now it isn't . The issue is that it says that the host is unknown or not reachable. This function has been excellent for my apps and necessary for the data to be updated in the reports. In await of your prompt response. Best Regards, Denis
Performing "SELECT * FROM table" with &ZOHO_SQLQUERY
I am able to use the parameter &ZOHO_SQLQUERY=SELECT * FROM table but the results are not correct. In my table, I have two columns (col1, col2), but all columns are named the same (they are named the first column in the table) <result> <rows> <row> <column name="col1">text</column> <column name="col1">text</column> </row> <row> <column name="col1">text</column> <column name="col1">text</column> </row> etc... All the columns are named col1. Please help! Thanks!
ZOHO_SELECTED_COLUMNS doesn't work
The parameter ZOHO_SELECTED_COLUMNS doesn't work for several OUTPUT_FORMATs (CSV, XML, HTML) but it works for PDF. The following works, and will create a PDF with only the "name" column: http://reports.zoho.com/api/<name>/<DB>/<table>?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=PDF&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=<api_key>&ticket=<ticket>&ZOHO_API_VERSION=1.0&ZOHO_SELECTED_COLUMNS=name I tried to change the OUTPUT_FORMAT to XML and it outputs all the columns, but I only want the "name" column: http://reports.zoho.com/api/<name>/<DB>/<table>?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=<api_key>&ticket=<ticket>&ZOHO_API_VERSION=1.0&ZOHO_SELECTED_COLUMNS=name
Help
Hi Are there any tutorials showing how to create a simple application for my website. I have an xls document with a list of companies, names and other information. I would like to be able to have my viewers be able to search this list and have the results show. I apologize I have no database experience and this site was recommended. Thanks Ant
No Refetch/Schedule Import menu option is available
Hi I am trying Schedule Imports Periodically function, But there is no Refetch/Schedule Import menu option si appeared Import Button on tables as you see in the attached screenshot. Could you kindly show how to access the menu option for Refetch Schedule Import Function? Regards Keita
Possible to upload docs into a database field/cell ?
Hello to everyone. I have read the help about data types, but I will ask anyway: Can I upload a pdf document (or any other file type for that matter) into a database "cell"? As a teacher I would like to upload worksheets into an "English worksheet" database and then publish this database in my website. Parents could then download them. If this is not possible now, how about later? Any chance for a "file" datatype? Thanks.
Selecting multiple items from a lookup column.
Is this possible? If so, anyone have any insight into how to get it done? Thanks beforehand.
Filtering a chart based on a column of type decision box
It looks like filtering data in a chart based on a column of type Decision Box does not work. You always get No Available Data. To reproduce: 1) Create a table with at least one column of type Decision Box 2) Populate some data with both Yes and No 3) Create a chart on the table without any filter. The chart returns data 4) Add a filter for the decision box and set one condition: no available data. In the filter, the values are displayed as true or false, while in the table they are entered as Yes
Date filter
Can I create a prompt and/or filter based on a date range - e.g. between 01-01-2009 to 31-12-2009 in Zoho Reports? Thanks
Zoho Reports, Pivot-Table Embedding and Sorting:
Question1: How can I allow the user to apply filters and modify columns and rows with an IFRAME-embedded zoho pivot table report? Question2: How can I change the sort order of columns in a zoho pivot table report, so that the sort order is "customized" instead of "alphabetical" (for example, instead of Fall Spring Summer Winter ... I would like the sort order of the columns to be Fall Winter Spring Summer )
Chart Axis Ranges
New User to Zoho. I have two date/time fields on a form and then a formula field that returns the number of hours between these two dates. Since I am tracking at the time level, almost every value is unique which is fine. I created a bar chart of this hour discrepancy column and I get a lot of values on the X-Axis. What I want to show is only two bars (one for values that are less than 24 hours, and one for more than 24 hours). I thought the 'ranges' section under 'filter' was going to help
Automating Report Updates
I have an access table with the data from our quoting application. I want to automate extracting the data from here into the Reports data sheet and then update specific reports for our suppliers to see about their individual product performance. Can anyone help with how I can go about this. It would be ideal if they had a link to the report without a login that they just kept and we just updated the backend data for this.
Pivot View Grand Summarys
Hello, I have noticed that when you run a pivot view chart, at the bottom there always is a total bar and grand summary. This is a good feature and all, but when information is taken from adwords and placed into this chart, the averages do not match up. Example: This is what is given out of Adwords Date Campaign Clicks Avg CPC Cost Conversions (1-per-click) Cost/Conv. (1-per-click) 9-Jun 800 all 6958 $0.70 $4,891.48 773 $6.33 9-Jun 800 frames 637 $0.83 $527.51 51 $10.34 9-Jun 800 futons 778 $1.04
Grand Total Calculations
The following SQL produces the following table SELECT "REGION_NAME" as "Region", sum("TOTAL_STAFF") as "Total Staff",sum("NO._MEMBERS") as "Total Members",abs(sum("NO._MEMBERS")/sum("TOTAL_STAFF") * 100) as "Penetration (%)" FROM "Schools Master List" GROUP BY "REGION_NAME" GO Region Total Staff Total Members Penetration (%) Eastern Metro 71 63 88.73 Western Metro 164
Moving DB to another user
Is it possible to move a database and all it's associated reports to another user? If so, will all the existing permissions stay? Reason is that a user has setup many reports from a database and they are leaving but have the reports in their personal zoho account.
Bugs in query?
Hi, I've a Db with 4 records but if I launch this query: select * from "DB CONTATTI" the query gives me only 2 results! Thanks for all your feed back jacopo
Pivot view displaying to 16 decimal places
I have used the pivot view in my report and have decimal data in the row entries which are only 1 decimal place. however I find that the 'total for' row is calculated to 16 decimal places. Is there any way I can change this from 16 to 1 decimal place?
do not want zoho output format xml to show up
hello maybe my brain is fried, but can you help me with this issue, on the sample for "Bulk Adding / Updating via CSV" on reports via the api, the sample url: http://reports.zoho.com/api/demouser/EmployeeDB/EmployeeDetails?ZOHO_ACTION=IMPORT &ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML &ZOHO_API_KEY=adss&ticket=ssfs&ZOHO_API_VERSION=1.0 has "&ZOHO_OUTPUT_FORMAT=XML" so all works excellent to the point i get the xml, how do i remove this? i dont want a result displayed just want to upload my
Merge information between Zoho Reports and Zoho CRM
How do you merge information in Zoho Reports with Zoho CRM. Also noticed it CANNOT be done with Zoho Contacts. Please suggestions and feedback would be greatly welcomed Thanks
data: analysis / exploration / mining / robust visualization - wish list
Thank you for an exciting offering of services. Any plans to integrate this kind of functionality into your product suite? Features would provide the ability to carry out exploratory data analyses - data visualization (scatter matrix, radviz, polyviz, 'motion' charts), data mining algorithms (association, clustering, time series, regression, SVM, Naive Bayes, decision trees), a mining model development & evaluation platform. These kinds of platforms are currently available as open source platforms
Query / Union of tables with date column
Hi, I want to create a new query table based on Table1 and Table2: Table1 Column1 (Text) Column2 (Date) X 30 Apr, 2009 23:15:34 Y 12 May, 2009 23:15:47 Table 2 Column1 (Text) Column2 (Date) Z 18 May, 2009 23:15:34 Using this SQL Select Query: SELECT "Column1", "Column2" FROM "Table1" UNION ALL SELECT "Column1", "Column2" FROM "Table1" Executing the Query the result is OK: Column1 (Text) Column2 (Date) X
Reports: update, import, deleting records.
Reports: update, import, deleting records. Hi, How do I proceed for my problem, database classification, placing game résults. In this case my database contains from one to fifteen records, rows (with indentification and résults from dogs game) A new records, data no problem "importing data - add records at the end" But updating I must work eround, can it be done in one time? Explanation: offline I workout all the individual résults, with a macro in a spreadsheet, and put all the data from the records
Chart width when using a single iframe (embed) for multiple charts
Hello, I use a single iframe to display charts depending on which one the user wants to see (links on a page). Is it possible to still define the chart width using a URL which targets the iframe? I tried sticking "&WIDTH=700" into the url but it doesn't seem to work like it does in the iframe src attribute. Thanks.
Next Page