Operations on folders
Hi, Is there any way to execute operations on folders apart from creating them ? Like delete a folder, move folders up / down, rename a folder, ... ? Thanks, Cimballi
Zoho Reports - New features rolled out in January
Multiple Language Support Zoho Reports user interface is now available in nine different languages. The languages supported are: Chinese [zh] English [en] French [fr] German [de] Italian [it] Japanese [ja], Portuguese [pt] Portuguese (Brazil) [pt_BR] Spanish [es] Note: When a user logs in to Zoho Reports, one of the above languages gets set based on the browser's locale setting. Users can switch to any of the other languages, from their Zoho Accounts (https://accounts.zoho.com) Profile page.
Zoho Report // How to round digits
Hello, I have the problem in Zoho-Report that I the report shows too much digits behind the comma, but in just some data. It shows something like 67.67999999999999. Although I just used the SUM function in the report and all is shown correct in the views. How can I round it to 2 digits (like 67.68)? Thanks in advance. Best Markus
Saved changes not recognized
Greetings: I made changes to data in a table, clicked the save button and then clicked the X on the tab for that table. When I do, Reports displays this dialog: When I click Yes, it it displays a the message "Already saved. No modification found." Once this message is dismissed, the table tab remains open. If I click No, the table closes, so I can work around the problem, but this behavior is confusing. I'm setting up tables for other users to edit, and I know I'll get calls about this issue. Keith
How to copy one specified chart from one database to the other database?
Two databases in the different Zoho Reports accounts have the same data structure. I have already created lots of charts in one database. How to copy one specified chart from one database to the other database? Thanks a lot.
Dynamic filter based on day name
I have a list of account we deliver to each day of the week. Different accounts are serviced on different days. I need to email our staff daily a list of the accounts serviced that day. I've added a calculated field named CurrDay with this expression: weekday( currentdate( )) Then I tried to create a filter in the DeliveryDay field where its value In CurrDay, (or In [CurrDay], or In =CurrDay, or In =[CurrDay]), none of which worked. Then I tried putting the calculation in the filter itself (In weekday(
Back Up Not Functioning - Not Backing Up and Not Scheduling
Scheduled backups are not executing. In addition, I am not able to schedule backups on new databases.
Sorry, column name should not exceed 100 characters
Hi, I have a table in my database called England. For the last few months, I have been uploading data into the table using the csv upload tool and have had no problems. However, the last couple of days, the import has been stopping after 89993 rows. The error message says "Sorry, Column name should not exceed 100 characters" I have read the help section which mentions specifying the delimiters but before changing that, I thought I should report the issue to you to see whether there is anything else
Published Report won't allow for column sorting
I've published a Zoho Report pivot table to the web. With the exception of the first column, no other column is sortable. The sort arrows appear, but they don't work. I'm sure I've done something wrong, but I can't figure it out. Can someone please advise? You can see the published Report here: http://www.aprilmassie.com/test.htm
Using variables in SQL Query Table
I'd like to create a query table making use of variables (dates). I'm unable to use DECLARE to set variables due to the SELECT only restriction. How should I go about analyzing data based on date ranges without modifying 50 lines of code each time I want to adjust the statement? Additionally, is it possible to access a zoho db from my desktop using SSMS? Thanks!
Calculated average in report
I have created a simple log application, in one form field I store the time (in hours) and in another store the number of successful events (Number). In the form I have a calculated field (Events / Time) giving the number of events per hour for the individual line records, I am looking for the ability to calculate the total average events per time from the sum of events and sum of time in the pivot report across all filtered records Any idea’s?
import Excel file from online storage (humyu.com - steekr.com)
Hello, Can we import data from online storage like humyo.com or steekr.com ? thanks in advance for your feedback. example : http://www.steekr.com/n/50-17/share/LNK304249f970a30a0c7/ Sylvain Schaffhauser.
User Filters Format
Hi again! On several of my charts I have user filters. And I've embedded them into a website of mine. Since I have three cascading user filters (set up by using the "show only relevant values), my users and drill down to the data. I love this feature. My issue is that when the user gets to the third filter and they select the drop down to pick what they want, half of the text is cut off along with being able to visually see the scroll bar to know to scroll. Basically the user is stuck looking
password Upload Tool when using google
Hi, I am testing the Upload Tool, but keep getting the error wrong username/password, and I started to wonder. I am using Zoho reports logging in using google apps. What is then the username/password that I am suppose to provide to Upload tool?
access denied
why i cant sign up??i try to register for make a database online..then it say..access denied..lololo..
New TO Zoho
I love the idea of Zoho.... and would like to learn more. I am looking to build my own data base of stocks in the Stock market. I will be recording Daily price changes in a selection of different stocks which i will then analyze using the criteria in the fieldds i have created. My questions are.... 1. Can Zoho automatically create a field by date - daily. Example if i am following a stock every day i will load the prices and & change in price into the field. Can this be done automatically.
Export Excel Date Format Issue
Hi, I have some tables created on Zoho. When I Export the tables to Excel format, all columns of Date have an issue. (The date displayed on Zoho Screen is correct but the exported one is wrong). Ex: Date: 26/10/2011 (dd/MM/yyyy) is exported as 10/03/2013 . Can you help me ? Its very urgent. Thanks, Delio Tomaz
Error in a Custom Formula Column
I have an error in a custom formula column. I have a VERY simple formula in a custom column. Here is the formula: "Column Name"* .15 All I am tryting to accomplish is to multiply in order to get a % of another column. But it only works on some of the entries like in the image below: You can see that for some of the rows are blank and for no apparent reason. I was told when I contacted support about the issue that all I have to do is add a ZERO before the decimal in the formula. So I did that.
Query table with multi line field
Very pleased with ZOHO. However I cannot get this query to work. SELECT "Email", "Name", "Interests", "Classes Attended Title" FROM "Group Table" WHERE "Title" = 'Teacher'AND "Interests" = 'Icing' Title is Plain Text field, Interests is a Multi-Line field. Please help a 75 year old database newbie
Average of an average!
I have created a simple logging application, where I log the number of successful events and the time taken. In a form field I store the number of events (Number) In a form field I store the time in hours (Decimal) In a calculated Form field I store Events / Hour – giving the Events per hour for each record In a Pivot report I then sum all of the records (Filtered list), it all works well except calculating the total events per hour for the report. Am I able to calculate the total average? (Sum
Add filter to toolbar in static link!
It would be awesome to see a Filter option added to the static link toolbar. That way, I have a whole pile of information ready for multiple users (teachers) to view, and they can differentiate the data according to their own classes.
IF Statement
I'm creating a column with a formula field and am able to do the following: if("column 1"='abc', 'Correct', "Not Correct"). In column 1 I have cells that contain the following: abc abc 76 xyz qrs I'd like to be able to write a formula that does the following: If column 1 contains abc, then return 'correct' or if column 1 contains xyz then return 'maybe correct' or if column 1 contains qrs then return 'not correct'. Basically I need the formula to A. search for text rather than an exact match B allow
Custom range in x-axe
I'm setting up a graph to view age distribution for a number of registered persons. I would like x-axes to be age grouped by 5 years. (15-19 years, 20-24 years, 25-29 etc) Is this possible?
Percent Line Chart
Hi, I need to create a line chart of percentage. On my table there is four columns: Month, Territory , Total Contacts, Total Sales My objective is to make a line chart by month (X axis) with percentage of sucess on contacts (Y axis is [Total Sales] / [Total Contacts] ). This same chart have to show a Territory Filter, and the user will be able to view the perfomance by territory. How Can I do this, without create one view for each territory ? regards, Delio Tomaz
Stacked Bar Graph not displaying correctly
When I choose a stacked bar graph the data is not displayed correctly. Have I selected something that is causing this issue, or is it a bug in the reports application? Its almost as if the data was inverted for some reason. Jason Rapp
Zoho Reports - New features rolled out in December 05, 2011 update
Export/Email Dashboard as PDF file Zoho Reports now has the ability to export and email dashboards as PDF. To export or email a dashboard as a PDF file, follow the below steps: Open the required dashboard and select the Export option from the toolbar. Select one of the following options: Export as PDF - To export the dashboard in Portable Document Format (PDF). Email as PDF - To email the dashboard as an attachment (PDF) to the email address specified. Provide the required Format options and click
Share View To User | Filter Criteria | So What Am I Doing Wrong?
In ZOHO Reports from I am selecting a Query Table named "Master Commission Report". I then select "Share View To User" and enter the following in the "Filter Criteria" field: "MASTER COMMISSION REPORT"."Agent" = 'travelstore' I then click on "Preview" and the filter criteria works fine by displaying only the information pertaining to "Agent" = 'travelstore'. Now the problem appears when I send the "link" to the "Shared User". The link is not appling the "Filter Criteria". The link is simply
Schedule CSV files updates from behind a firewall ( https)
I'm trying to import a CSV file and schedule periodic updates, but are not able to import the CSV file from behind my firewall (which off course makes sence as reports.zoho.com is on the outside). It is not possible, from a company intelligence perspective, to share the CSV files in the public domain. How can this be solved? Regards
Pie Chart Can't display totals? (Only percent shown...)
Is there any way for a pie chart to display the totals within the category, as opposed to the percent of total?
URGENT! Zoho Report cuts a digit from a number
I'm repeating the problem here, sorry. ===================== Dear Zoho Reports Team, We've just found a big problem: 1. We have a query which is created as SELECTs from many other queries and tables. 2. It has the first column 'code' which has Positive number format There are, for example, two codes: 1242357 1242359 3. I have another query over this query, where i do: SELECT concat('810',code) as "code" where 'code' is the column 'code' from the first query. 4. In the second query i get CUT version
More than 5 Columns in CRM Reports
Hi I'm having a problem when adding more than 5 columns when creating a Zoho report? The thing that happens is that site goes blank, and stops loading. So I wanted to know if I'm doing anything wrong?
CRM Reports
Is it possible to change/customize the x, y axis within a report?
Iframe code using parameter creteria
Hi, I can not find the write code to embed my selection criteria report on a google site. Can someone compose this code. global database. Link works in browser. You see all the data https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=71310000000763410&STANDALONE=true&privatelink=7571234dbcfd66a81611a1425e2873ea&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=false&SEARCHBOX=false This I want in a iframe Link works in browser and selection on Royal cl Chien pol Tournai column --> Wedstrijd clubnaam
Query Error Message When Using "Order By" Clause
Everything works fine with the Query until I put in the "Order By" clause. I receive the following Error Detail: "Kindly ensure that the table name you have specified is in the query scope.". ======= SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "August 2011" WHERE "Agent" = 'JOHN' UNION SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "September 2011" WHERE "Agent" = 'JOHN' ORDER BY "Travel Date" ======= So, what am I doing wrong??? Any
How to write the BBCode to embedd a Zoho spreadsheet in phpbb
Does anyoone know how to embed a Zoho spreadshet into a phpbb post? What is the BBCode that needs to be included in the post?
How Do I Update a Tabular View base on Query table ?
Hi, I have one Tabular View based on Query Table. I have changed the Query Table, adding columns, but this changing was not applied onm Tabular View. I Have already tried to find the columns on Hide / Show Columns but it no appear. How Can I do it ? Regards, Delio Tomaz
Zoho Reports: Fetch data from Zoho Sheet
Hello, I would like to use Zoho Reports to fetch data from an online spreadsheet. Currently I see Zoho Reports does support Google Docs Spreasheets. Ironically I cannot find out how to insert a Zoho Sheet range into a Zoho Report table. Why does Zoho play nice with Google Docs but not with it's own apps? Am I missing something? Thanks in advance, LG
Printing Filter Criteria on Reports
I've set up several reports that allow the user to select a date range. My issue is that when the report is exported to PDF there is no way to show the date range selected in the report. Can filters be included in the report export?
Create a chart from a Pivot Table
It it possible to create a chart from a pivot table. I am trying to chart the percentage of records by date and status. This is easy in pivot tables. I have 3 different statuses represented by percentage of total for records of each day. I can not figure out how to do this with charts. Being that i have it in a pivot table can I somehow create a chart of that? Thanks
Upload Tool - Problem
Hi, I am trying to upload some data to my Zoho Database, but when I execute upload tool, some columns has strange values (net.sourceforge.jtds.jdbc.ClobImpl@e61a35). When I execute the query direct on SQL, every run OK. I found the temp file generated by Zoho on \temp Folder. The same problem occurs, so, this issue is on the query that Upload Tool did on my SQL; Atached a printscreen.
Next Page