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
Query Zoho HTTP API on Query table
Hi, I am having a problem on executing queries on a Query Table using HTTP API. My code works fine, my query get total o rows in a query table. The problem: - I have one table called "Visits" and a query table based on this one. When I execute the query using HTTP API (select count(*) ....) I got the total of rows. But If I add new rows on table "Visits", and execute new query (on query table) using API, the total of rows is not refreshed. It refresh only when I manually open the query table and
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.
Zoho reports api for creat a new database or a new table
Hello,I want to know do you have the Zoho reports api for creat a new database or a new table with java?
Deduplicate Records
I have a mySQL table that will have duplicate records show up occasionally. Is there an easy way to merge these records according to a specific criteria (some duplicates are actually desired in certain columns but not in others) so a chart report won't show the duplicates? Thanks!
Exclude Statement for Query
I have a database that contains data by session: Fall I 2010 Fall II 2010 Spring I 2010 Spring II 2011 Summer 2011 Fall I 2011 I have no trouble writing a query in order to collect all of the data by session and then of course grouping it by say website or market and I even know how to write a query to create a formula such as "clicks/impressions" = CTR. It's all great. EXCEPT....I want to be able to group the first five listed above to give myself totals and to give myself an accurate CTR. I
My Accounts Report
Can I make a report that only shows my accounts and not all of the users' accounts?
Identifying dependent objects
Hi, I tired to delete a table in Z Reports and I received a caution saying that one or more dependent views exist for this table. However, there is no option to list the child views so I can delete the the dependent objects to ensure there are no orphan objects in my repository. Is there way to find out or list the dependency/parent-child object relationships from base tables to queries to reports and views? It would be useful for data lineage as well. Cheers Sunil
Chart Creation
Hello, Is there anyway to automate chart creation via the API? Ideally I would like to be able to create a client specific account, upload data and generate reports all in one go. The data and reports differs from client to client so the current database copy or backup / restore does not work for this scenario and I find myself having to build everything from scratch each time. If I could automate the process it would make my life so much easier :) Regards, Adrian.
URGENT: restore back up (Why support is not answering?)
Hello, on October 16 I have contacted support to get my back up restored. Unfortunately I did not yet get any response. Could you please restore my back up for the following dB only: ApplicantReport 16-Oct-2011.zip Moreover, is there a procedure for user to restore the DB from a back up? As you can immagine these problems can be quite urgent for a user running his business on Zoho!!! Thanks, F
Restore Zoho Reports database backup
How to restore Zoho Reports databse backup from one account to another
Next Page