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
Customization of charts
I have embedded a number of charts within a website, but the default chart background does not match the website color/aesthetic. When I attempt to change the chart background, only the inside of the chart is shaded with the background color (not the axis or legend areas). Is there a way to shade the Entire char, so that I can make it blend with the website that it is embedded into? Is there a way to add a background image to a chart? Thanks,
API Import
I am trying to get Zoho Reports to retrieve data from my cloud based scheduling tool. The cloud based tool has a REST API and Authentication key but cannot get the data to import into a Table or database. I am trying to create scheduled reports to send to clients
vertical cell height in reports
Hello, I have come across an issue recently. In the reports that my company uses, the height of cells would automatically be adjusted so that all the text in the cell could be seen across multiple lines. This was always just how Zoho reports worked. Recently, it seems that the height of cells has stopped automatically adjusting and is showing at just 1 line. This causes us to only be able to see what fits in 1 line of text, which is insufficient in many cases. If I modify the width of a column,
How to get support for reports?
Is this the only way to get support? I have a problem specific to my database and would like to be able to email someone directly instead of going through a public forum. I have created a "feedback" request, but it's not clear to me that is actually a support ticket.
how to make same diagrams in reports?
how to make diagram with floating pointer from red to green zones? see screenshot
Zoho Reports - New feature rolled out on Jan 02, 2015
Copying a Table With this new feature from Zoho Reports, you can now save a copy of a table in your database. This feature will be pretty useful for cases like Backup, Copying table design etc. Click 'Save as' menu in the toolbar to save a copy of that table. You can choose to copy the table with data and/or retain the lookup columns of the original table. On copying, all formatting, formulas etc. will get retained in the new table.
How can I select rows without a date ?
dear all, In a data sheet I have rows of which in one particular date column there is a date filled in or no date.(blank). The date is a proof of delivery date. I would like to build a pivot table only filled with the rows that in the particular column has not a date ( = blank) . so all rows should be reflecting those who have no proof of delivery date in it ( = not delivered) How can i obtain this. If I selct the column and try to put a filter it does not let me to select blank or emty or...
How can I get a report to display empty cells?
I created a dashboard that has two reports within it. The first report shows all 12 months in the year because each field has a value greater than 0. The second report (filtered slightly differently) only show 5 months because 7 of the cells are empty. This doesn't look good, how do I get it to show all values even if they are null/empty.
Zoho Potential - Sales Report
I have closed won potential with revenue amount of $48,000 which is divided into 12 months projects. Each month is actually $4,800. So, 1) How to divide the revenue to 12 months and 2) How to generate a sales person's report for specific month?
firewall configuration
Hi team, We would like to evaluate SD+ with ZOHO Reports, but our SD+ server by default doesn't have access to the internet to upload the data. So, in order to open the traffic on firewalls from our SD+ server only to ZOHO Reports we need to know your IP range, can you share? Mar
Is anyone online?
I have some (basic) questions regarding Zoho Reports and am wondering if I can chat or screenshare with someone. 1) I have a field called "Event Type" and values such as "A", "B", "C", "D", "E". Let's say I wanted to report on a rollup or group these into regions where Event Types A, B, C = region 1 and Event Types D and E = Region 2. How can I add this column to a database? 2) When I want to refresh the database, how do I do that? I would want to wipe out all of the original data and put new data
Today I started getting an API_ACCESS_REQUEST_BLOCKED error when the CSV upload program tries to log in
It doesn't happen all the time, but enough that I can't get all my data uploaded. Nothing on my side changed. What is wrong? Here is what I get in the log file: 2014/12/19 16:07:26 MST:Logging in 2014/12/19 16:07:26 MST:logging into https://accounts.zoho.com 2014/12/19 16:07:27 MST:IAM Error: Response status: 200 IAM Response: # #Fri Dec 19 15:07:27 PST 2014 CAUSE=API_ACCESS_REQUEST_BLOCKED RESULT=FALSE 2014/12/19 16:07:27 MST:Error!!! Could not login. Could be because of API_ACCESS_REQUEST_BLOCKED
Zoho Reports: any timeframe for iPad / iPhone browsers support?
hi, Zoho Reports is great but when I try to access one of my published reports from my iPad, the graphs keep on refreshing. They seem to be displaying well other than the constant reloading. Do you have any plans to make it compatible? If so, any date? Thanks in advance! Fabien
Feature Request: Add area shading to axis (background) or as minimum Add "Threshold" to Scatter chart
HI Zoho Folks, I have request for a new feature. I have a scatter chart of min vs max as my two axis. One set of our customers get a certain configuration if their MIN value is ABOVE a certain threshold. One set of our customers get a certain configuration if their MAX value is BELOW a certain threshold. My "Max" value is charted on the Y-Axis, my "Min" value is charted on the X-Axis. So I'd like to be able to shade from Min Threshold and greater, that is the area to the right of a threshold value
Query table not updated automatically after adding formula columns
Hi, if I create and save a query table of this type: SELECT * FROM TABLE1, TABLE2, … WHERE (any condition) And later modify the source tables (TABLE1, …) adding formula columns, these new columns will not be added to the original query table result. I hope this can be improved on the future, since now apparently it is required to generate a new query table for any change (adding new columns, etc.) that is done on the source tables.
prior month formula
Hello, Does anyone know how to create a formula to get the prior month sale?
Issue in ZOHO_CRITERIA
I want to filter the report (Pivot chart) based on user login. I created a report in ZOHO Report and i want to embed that into my creator app. iframe code is <iframe frameborder=0 width='400' height='300' src='https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=###### &STANDALONE=true&LP=RIGHT&ZDB_THEME_NAME=grey&INTERVAL=-1&REMTOOLBAR=true&INCLUDETITLE=true&INCLUDEDESC=true&ZOHO_CRITERIA='Company Email='zoho.loginuserid'></iframe> But the filter is not working. Thanks Gowsalya.B
Feature Request: Add "Best Fit Line" (R-Squared) to data set on Scatter Plot
HI Zoho Reports Folks, Please add the ability to chart a "Best Fit Line" (i.e. R-Squared) to a scatter plot graph. It would also be nice if you could include a 'error line' around this best fit...so that you can visually see all of the data points that fall in inside the Best Fit Line +/- 20% (or some other threshold value mechanism) Cheers, Tyler
Next Page