Export option in graph
Hi, 1. How to give a export option in embedded graph (Public view without access). 2. How to create a graph based on conditional formatting data. for example to want to show only current quarters report . Date should be in X axis. Kindly assist me in this problem. Thanks Satya NHM
Import from zoho creator into zoho reports
I am having difficulty importing from zoho creator into zoho reports. Normally I would just copy the permalink, with publish enabled, and paste that link into the Data Location, selecting Web. For some reason this has stopped working, it only imports, a single cell with the entire document in it, rather then splitting it up, and displaying the rows normally. I have tried changing the view from List to Spreadsheet, and I have also tried to create a custom url, for CSV, but it's just not importing.
Reach support portal and reports from the same view?
Hello, We are trying to create a portal for customers. They should have the Support Portal and also be able to reach a database in "Zoho Reports". Is there any page for this? Where they can choose their apps? They should only be "Customer" in the support. Kind Regards, Marcus
how to make Bullet graph?
hi need to use Bullet graph how to make it?
new zoho reports interface data feed not working
Your new Zoho Reports interface is not working for me: please review this feed: https://creatorexport.zoho.com/lifengwu/2015client2/csv/Copy_of_BUFEED/NSsjOdkwa8S9JExGwayRbRbhuWsrtvs0WAbGHmCtAma12E93jFTHuKGXDfAyyksq1T2C8mDhMqdxTM5N1uO7awM8nZmEkX2hhzw3 When I fetch it from within Zoho Reports, I got all columns crammed into one column:
Zoho Reports - New feature rolled out on Dec 10, 2014
Advanced Analytics Add-on for ServiceDesk Plus Zoho Reports now provides an advanced analytics add-on for ManageEngine ServiceDesk Plus. With this add-on, SDP customers can create fine-grained reports with easy drag-and-drop actions, without writing database queries. The add-on also comes pre-packed with 80+ usefull reports and dashboards. With this add-on you get simplified KPI tracking and analytics for improved decision support in IT service desk operations.
Help query
Hi, i need help , how I could do this. for example, I have this table Fecha Plano Perdida etc etc etc etc etc 01-03-2014 20 10 02-03-2014 40 60 03-03-2014 50 40 04-03-2014 10 25 05-03-2014 15 32 06-03-2014 25 18 07-03-2014 86 22 08-03-2014 12 45 09-03-2014 14 60 10-03-2014 25 21 11-03-2014 34 44 12-03-2014 22 24 13-03-2014 12 18 I need to create a new table containing the following Fecha, Proporcion where fecha between 01-03-2014 and 07-03-2014 proporcion = Plano , when fecha
Time Tracking Reporting
Hi Guys, This is probably very simple but I cannot seem to be able to report on a project and the logged hours. Can anyone point me in the right direction as I am wanting to compare projects to ascertain which projects are taking longer than others.
please unblock my block my account.
my id is blocked because of exceeding bounce mail.my id is mohan@axinosys.com. thank you
API v3.0 has a feature to add/rename/remove columns
Two questions:- 1. When will the API docs be updated to see the details of these new API endpoints? 2. Is there an API call to create a new table, so that columns can then be added to it? If not that would provide a way to automate data upload including table management. Many thanks. Best regards Keith
Calculating difference between two dates with format "dd/mm/yyyy hh24:mi:ss" in seconds
good Morning I need to calculate the difference between two dates in seconds. Has "Zoho Report" some way to do this?
Time wrong in export report to pdf
Hi, When exporting a report to PDF the time mark on top is wrong date OK My properties are set to Europe Athene -2 GMT The reports shows 16:07 and it must be 09:14 Thanks
Auto Delete Rows in Table
Has anyone found a way to auto delete rows in a table from a schedule? Due to the nature of our imports its best to clear all data from the table and completely refresh it with a new import. Looking to schedule this vs manually opening each table and deleting all rows.
Manipulating Drill Down
Hi, I was wondering how one might be able to change the drill down options for the user when you create a new report. For example let's say we have a bar chart with dates (no time incl.) on the x axis and units sold on the y axis. How do we go about doing the following: If user presses any bar and selects the drill down option, the user will be shown a bar chart with time (grouped by hour) on the x axis and units sold on the y axis for the particular date selected. And if the user again selects any
Import Data to Google Sheets from Zoho Reports
Is there a way data can be imported from Zoho Reports to Google Sheets
3rd party cookie
I embed reports in a webpage using iframes. A client of mine has made changes to the security settings on their system to block third party cookies which is causing problems for viewing reports - The reports won't load. IS there anyway to get around this from your end? My client is reluctant to make the required changes to their settings (an over-cautious IT dept). Regards Jjoe
First Zoholics conference for Zoho Reports users
Hello Everyone, Save the dates for the first Zoholics conference for Zoho Reports users. This year's first Zoholics conference is to be held from February 25-26, 2015 at Pleasanton, CA, USA. This is an exclusive event for Zoho Reports (and Zoho Creator) customers, partners and developers to come together and share their experiences. Come join us for the event and get a chance to meet the users and experts from our user community, and the Zoho Reports team. We also have dedicated one-on-one sessions
Zoho Reports 3.0 is Here
Zoho Reports 3.0 has been released. More details about the release here - https://www.zoho.com/reports/blog/zoho-reports-3.html
DB name have spaces
How can I get my DB_name and name_report to use in the API URL when they have spaces. I have tried different was and in documentation there is nothing regarding how get the DB_name valid for the API
Sparklines
Hi, I was going through zoho reports and realized that we do not have sparklines in our reports. Sparklines in excel helps to summarize large columns of data in a single cell and is an ideal representational tool. I think it can be a great feature to incorporate in a report. Regards, Manish
HTTP status code (302) obtained by reading the content URL. Check if the URL is accessible.
Hello all of you... I configured a Table import from iFormBuilder few day ago... But it is not working.. I am receiving this message: HTTP status code (302) obtained by reading the content URL. Check if the URL is accessible. Do you have any idea... what is happening...???? Thanks..
Coming soon: Zoho Reports 3.0
As regular users of Zoho Reports, you might have noticed the 'Try our New 3.0 Interface (Beta)' link at the top. Our plan is to have the 3.0 release in early February 2015. As a precursor, here's a short video on what you can expect in Zoho Reports 3.0. If you haven't yet, try the new Zoho Reports 3.0 UI now, and let us know your feedback.
Connecting to a SQL Server database issue
Hi all, I am trying to connect to my SQL server database to upload a file to the new user interface. I believe that I have everything set up but I keep getting the same error which is too generic for me to do anything with. the error I am getting from my log is this: 2015/02/05 15:08:55 GMT: ============================================================================================================================================ 2015/02/05 15:16:41 GMT:#################### ERROR OCCURRED WHILE
The end doesn't show the list of formula
Dear Support, The end doesn't show the list of formula as you can see below. If String is select the end show the list of formula. Thanks. Paulo Miguel.
Access Log
Is it possible to view a log of all accesses, or login attempts by my users to zoho reports?
Joining tables for conditional
I have create a conditional formula in my "Inventario" table to classify each line according to some parameters on the column "Estado". The problem is that I need a new parameter whether a "Caso" of the Inventario table is on the "Pendientes por Resolver" query the value of "Estado" column would be "Pendiente IPS". I hope I make myself clear and that you guys help me as soon as possible. Thanks.
Group report color separations
When viewing a report using a groups selection by Dates, the separation bar for each date is grey, is it possible to have the separation bar a different color like dark green or Blue.
Graphic of two tables
I have two tables (Pendientes and Datos-Casos Cerrados). I want to show in the same graphic the amount of "casos" in each table by month. In the case of Pendientes it would be the date on "Fecha de Solicitud" column and in Datos-Casos Cerrados the date of "Fecha Cierre" column. I hope I make myself clear and you guys help me as soon as possible. Thank
Report to show sales commission for each sales person
Hi, I am doing some tests on Zoho to see if it is a suitable software package for my client. My client has several sales persons. Each sale person makes several sales a month. At the end of the month, the sales person receives a 10% commission based on their grand total of sales for that month (e.g. if the sales person gets $10000 worth of sales that month, they receive $1000 in commission). How can I show this commission figure for each sales person in a report? I am very impressed with Zoho so
Zoho Reports Auto-import/refetch successive failures from dropbox and google drive
Hello everyone. This is to report an issue I have been dealing with for about 4 months now. I am having a succession of auto-import/refetch failures from a set of csv files from dropbox. I tried using google drive as well but the same issue is observed. These CSV files are dump exports from a database and are replaced/overwritten to reflect updates (new records) regularly. We cannot proceed with allowing Zoho Reports to directly query the database since our internet connection is not that reliable
Highlighting more then one row
Hello. How can you highlight more then one row in a table? For instance I want to delete five or six rows a a time. Thank you.
Forecasting Calculation
Hi, I am trying to forecast the performance of a sales performance over a 12 month period based on their past performance. This calculation aims to calculate the expected number of appointments a sales person will book. The calculation I would like to achieve is as follows: Sum total of appointments already made in 2015 / the number of weeks that have already passed in 2015 * 52 This calculation would give the total number of appointments the sales person would expect to secure based on what they
Error when importing from URL
I get the following error when trying to import from URL. Error while reading the URL contents. Please verify whether the server (host machine) containing the URL is connectable. I know the URL works because I can paste it in a browser and see the information, so it is connecting to the host machine. I can't find any information regarding this error. Thanks, Dan
Chart reporting time based data incorrectly
hi, I am currently working with a phone log. I have created a chart that analyses the number of calls made at different times of the day. Unfortunately Zoho Reports interprets calls made between 12 and 1pm as midnight opposed to midday. All other data is interpreted correctly. Is there an obvious way of solving this issue? James
Problems with C# Client Library
Hi, I am new to Zoho API. I have a requirement to import data into tables from CSV files through the API. I have tried the sample code given on the site, but it does not work. It does not return any error, but data not get imported in the destination table. Here is the same code I am using IReportClient RepClient = new ReportClient("-----Auth Token-----"); string tableURI = RepClient.GetURI("<email>", "<db name>", "<table name>"); Dictionary<string, string> ImportConfig = new Dictionary<string,
Update time for Zoho Reports to see changes made in Zoho Projects
How can I push the changes made in Zoho projects to Zoho reports quickly so I don't have to wait 5 or 6 hours to re-run the reports. The wait time significantly slows down my ability to invoice my clients in a timely fashion.
Issue with creating lead / contact report with "description" for advanced filters
We noticed your lead and contact reports have changed recently. We used to be able to create lead and contact reports with being able to choose from the pulldown under advanced filters for the "description" field. This is no longer the case. Is there something that has changed with our contract / product subscription? See screen shot below (and enclosed) on an older report that we are no longer able to create. Note the "description" is chosen for the advanced filter.
Allowing people to upload text to the website
I run a web site for a charity (U3A) and have been asked if some Group Leaders could add short messages for their groups without having to come through me. We did this some years ago using I think Zoho reports but I can't now remember how to do it! Can anyone please point me towards the correct tutorial?
urgent - datatype changed avoid data truncation
hi just connect report from zoho creator to zoho reports database all works well but at first connection in zoho database there is changing of datatype (positive number -> decimal number) why? and how to leave in database first (positive number) datatype for column? and what is "avoid data truncation"?
Not able to refetch data from Table
Hi, I have created a table named Mill Report New. The database fetches the data from a google drive folder. I have set the sync schedule for every 6 hours and have chosen the option to "Delete existing records and add". I am not receiving any error notifications but it appears that the database is not being fetched completely. The total number of rows in the database is 46923 however the database size shown in the uploaded table (BSP Flour Mill Sales Analysis D) is 46754) .The size of the data base
Next Page