Conditional Formatting
Hi When will Conditional Formatting be available on Pivot Tables? Also, will we be able to format a column by comparing it to a value in another column e.g. If Service Level >= Target, Then GREEN Else RED Thanks, Sheila
How to create forecast
Hello, I have a pivot table with monhly revenue. I would like to extrapolate revenue to end of month (i.e. today is 13th and my revenue is 100 USD. Extrapolated revenue is 100/13*31 days.) It's way how to do it? Thanks a lot! Jirka
Move database to different account?
I know it is possible to share a database, but is it possible to transition ownership to a different account? Specifically I would like payment of the usage to transition to a different user/account. Is this possible?
Font size in Tables
Dear Sir. How can I manage to edit Font size in tables (zoho reports)? Thanks for your help. Matias
Reports / Creator Editing the legend names
All, I need to be able to change the displayed text for each of the data columns in the header of my reports. Please see screen shot below. I need to be able to do this without changing all of the names of the tables in Creator. Your help is greatly appreciated. Jason Rapp
Modify Filters width
Dear Sir/Madam: Is there any way to modify a dashboard's filters width? Atached a picture showing my need: Any Help or tip will be wellcome. Thanks
Pipeline by stage by month
Hi, how can i create the following report?
Updating JSON data
Hi. Every time a want to see my dashboard with updated data, I have to import it again and reconfigure all name collumns. Is there a way to Zoho Reports automaticaly updates the JSON data with my REST service url? Tks
How to connect local database?
Hi All I am just new to the Zoho reports. Can any one tell me how to connect the local database - oracle. I have configured the below in the config files. # $Id$ DBTYPE=ORACLE HOSTNAME=localhost PORT=1521 USERNAME=hr PASSWORD=hr DBNAME=ORCL #MDBFILENAME= #SQLITEFILENAME= #FIREBIRDFILENAME= # Generic JDBC connection properties: To upload from a unsupported local database which has a JDBC connector / driver: # Below properties should be used in this case. It is enough to provide the value for DBTYPE,
Read/Write in ASP/C# ?
Hi all, Is it possible to query/read and write/append a records inside asp.net using C#, if yes, kindly point me to the some tutorial or code samples, thanks in advance. Cheers.
Contact lookup fields not syncing from CRM to reports
Hello, we use Zoho CRM Advanced analytics in Zoho Reports. We use the standard Contact lookup type field in Potentials in Zoho CRM, but this field does not sync to Zoho Reports, the column is not shown at all. I need that column to be synced. Is it a bug or a feature? It is quite crutial. Thanks, Vitek
Upload file using java swing application to zoho??
I have created a Java Swing Application which selects files from my computer. I want to upload these files directly to Zoho database instead of uploading it from Zoho Application. Is it possible? I have heard about Zoho API calls. But have no idea, how to use it. I will appreciate your help, if someone can explain the procedure step wise. Thanks in Advance.
Error Code: 8518, Error Message: You need to (re)login to perform this operation
Hello Im currently having this error when uploading to Zoho my db: Error Code: 8518, Error Message: You need to (re)login to perform this operation Please hellp me. Thank you
Error with java jtds library. Not found SQL server instance of my Database
Hi, I've a problem with upload tool from local database. It not found de SQL instance of Database and take me this error. 2013/12/19 08:26:21 COT: OS : Windows 7 6.1 x86 2013/12/19 08:26:21 COT: JVM Version : 1.6.0_16 2013/12/19 08:26:21 COT:TESTRUN :: false 2013/12/19 08:26:21 COT:2013-12-19 08:26:21.188 :: Connection Props are : 2013/12/19 08:26:21 COT:DBTYPE :: sqlserver 2013/12/19 08:26:21 COT:HOSTNAME :: 192.168.0.11 2013/12/19 08:26:21 COT:USERNAME :: icummings 2013/12/19 08:26:21 COT:PORT
error to conecting local database
Hi, I've a problem with upload tool from local database. It not found de SQL instance of Database and take me this error. 2013/12/19 08:26:21 COT: OS : Windows 7 6.1 x86 2013/12/19 08:26:21 COT: JVM Version : 1.6.0_16 2013/12/19 08:26:21 COT:TESTRUN :: false 2013/12/19 08:26:21 COT:2013-12-19 08:26:21.188 :: Connection Props are : 2013/12/19 08:26:21 COT:DBTYPE :: sqlserver 2013/12/19 08:26:21 COT:HOSTNAME :: 192.168.0.11 2013/12/19 08:26:21 COT:USERNAME :: icummings 2013/12/19 08:26:21 COT:PORT
Display Table's column on the form
Hi, I have Resume Form and I added a new column to Resume Table, but I don't see this new column on Resume Form. What I'm doing wrong?
Show last 30 days in Date Range selector
Hi I want to show data for the last 30 days as default. I can achieve this with the "Relative Period" date picker, but then I lose the ability to pick exact date. Any solution to this?
Zoho Reports Upgrade
I've recently completed the Zoho analytic reports trial and want to keep on using them as part of my subscription. But theirs no way off adding it! All i get is this message: "You have been downgraded to Free Edition of Zoho Reports. Please upgrade to "standard" or higher edition of Zoho Reports to continue the integration." When I go to Reports, click on Analytics, there is no zoho reports option to upgrade with! Why do you make it hard to updgrade?
Query Error: Improper usage of GROUP BY clause.
When I execute a query made and stored six months ago I get the following error: "Please ensure that all the non aggregate columns used in the SELECT clause is also used in GROUP BY clause." The query is saved which is why the error most be due to changes you made in the past 6 months. Could you please help me solve this problem. My Query Table looks like this: ------------ select customer_id,timestamp(max(created_at)),firstname,lastname,company,sales_responsible_uk,sales_responsible,store_name,
Let users pick the date grouping
Hi Is it possible to let users pick the date grouping? If not, any workarounds? If a user pick a short time period we would like to group by day. If longer periods, group by week, month, etc.
Combining Field to filter
Hello I am wanting to combine some values when I create a graph. We have got a number of different stages against our opportunities eg - Follow this month, Follow this week, Lead etc. I would like to group them all together so they just show up as Open quotes. Is this possible when filtering or is there some other way it can be done? Thanks Karen
SQL Query with SUM and GROUP BY stopped working
Hi, I have the following query: SELECT "MESBRASIL", "PRODUTOMETA", "Qtd", "Valor" ,"DESCFMCOM", "MÊS", "TIPO PEDIDO", SUM ("VALOR TOTAL ITEM") FROM "Mytable2" JOIN "Meta Brasil" ON "PRODUTOMETA" = "DESCFMCOM" ON "MESBRASIL" = "MÊS" GROUP BY "MÊS" and I got the message error: Query Error: Improper usage of GROUP BY clause. Please ensure that all the non aggregate columns used in the SELECT clause is also used in GROUP BY clause. This was correct some time ago, being able to save the query table,
Changing sender in automatic emails
How can I cange the sender address in the automatic email notifications?
Creating Forecast reports
Hi I am trying to create forecast reports by type (renewal) and by quarter, I can do it by month but I want that grouped by quarter . Can you direct me accordingly. Many thanks.
Zoho Reports - New features rolled out on Dec. 4, 2013
White Label site home page with Multi-tab Dashboard/Reports viewNow Zoho Reports allows the White Label Customers to configure the home page with a multi-tab dashboard. With this your users will be able easily navigate between the views. White Label customers who wanted to configure this for their site can write to us. We will get your requirements and handle this.
Pie Chart & Unknown Value
My charts used to show the amount of fields that were unknown or blank (in underlying data). When i do a pie chart or similar the "unknown" field is highlighted at the side but there are no "unknowns" appearing on my pie chart - see attached pie chart unknowns in that chart should make up 75% of the chart. Thanks joe
Limitations?
Hi, as a subscriber of Zoho Reports (2M + 10M upgrade), I just noticed that 800.000 rows limit for query tables. Since we are going to upload a lot of data (15-25m rows), I am now unsure if Zoho Reports is the right tool for us. Can you tell me about the limitions of the tool? Is it currently possible to run reports over let's say 5 millions of rows of data, which (example) joins to another table with 5 millions of rows? Thanks four your help!
Display columns as rows
Is it possible? Example:
Zoho CRM and Zoho Reports Synchronization
Hello, I have been using Zoho reports to manage our entire business statistics. We pull in a lot of information directly from Zoho Creator, Zoho CRM, and an internal database. Currently we are also using the campaigns module directly within Zoho CRM which relates to events that we run all over the US and is used to track all events related to each campaign, as well as the contacts and leads whom attend each event. Is there any timeframe for which the campaigns module within Zoho CRM will be synchronized
puling data from one table to another for given period
I need to be able to look at a table of data and then grab data covering a 7 day period into another table where it will remain unchanged while main table continually updates every hour. Basically I want something that I can go in at the end of a week and run a query that returns rows of data that were entered or changed in that last 7 day. period. Is this possible in Zoho and how do I do it?
Customize the name of legend items
Is there anyway to customize the name of my legend items without renaming the columns upon which those items are based? http://screencast.com/t/FtUIjEdH
Zoho Reports - New features rolled out on Nov. 21, 2013
Enhancements for Table Designer Zoho Reports has enhanced the table Edit Design for a better usability. With this you will be able to perform the following operations while designing a table. Add Formula Now you can add custom formula or aggregate formula in your table from the designer. It is also supported to edit the formula from the designer. Also the Add Formula link in the new row give easy access for creating Custom Formula . Export the Table Design Now you could export the table design
Problem with Upload Tool (UploadFromDB.bat)
Dear Sir/Madam. I'm having the following error when trying to upload data from a local databas (MSAccess): I'm using the following sql query: <?xml version="1.0" encoding="UTF-8" ?> <!-- $Id$ --> <Queries> <Query dbname="BaseDatos1" tablename="AAAAAA" importtype="TRUNCATEADD" matchingcols="" selectcols="" skiptop=""> SELECT BBDDFinal.Explotacion, BBDDFinal.[Punto Operacional], BBDDFinal.SubFamilia, BBDDFinal.EAN, BBDDFinal.[Descripcion Larga], BBDDFinal.[Descripcion Corta], BBDDFinal.[Precio
Cannot view underlying data
The image below appears when I try to view underlying data on zoho reports on Firefox. What is causing this issue?
ZCRM and External Databases
Hi, We have setup CRM Analytics against Zoho CRM and also imported data from an onsite DB to a DB in Zoho Reports. From what I understand you cannot link DB's in a query so we will need to move data from one DB to another so we can link them. Could some one please confirm this is correct. Is there a way to automate this, either moving data from ZCRM DB to the Imported DB or vice versa? This link between DB's is a big limitation especially if you cannot automate moving data between DB's, I can see
importing data
I can't see anywhere t import data into this system. We would like to organise an automated (if possible) import and export to this system. Is it possible? thanks
Calculated fields not updating after data import
Hi, I have encountered an issue when using calculated columns in my table. When I import new data (delete records and replace with new data) the calculations are not updating. The only way to get the fields to refresh is to edit the formula and either add or remove a space in it. How can I get it to recalculate after the import without having to manually intervene? Thanks.
Zoho Reports - New features rolled out on Oct.30, 2013
Zoho Projects Advanced Analytics Add-on The Zoho Projects Advanced Analytics Add-on is now available in the service. With this add-on Zoho Projects users can slice & dice their projects data to analyze & track their key project metrics. Importing Data Setting up this add-on will sync data from your Zoho Projects portals into Zoho Reports. Data from the following modules will be imported and stored in Tables in Zoho Reports. Milestones Tasks Task owners Timesheet Users We plan to support synchronizing
Zoho Reports - New features rolled out on Oct.23, 2013
The following features were rollout in Zoho Reports service on Oct. 23, 2013. Support to Apply Share Filter Criteria for E-mailing Reports With this build, you will be able to apply the same filter criteria you have applied while sharing to a user for E-mailing the reports too. Support to Import More File Formats From now Zoho Reports supports importing XLSX format of Excel files from your local drive. It is also supported to import Excel files (both XLS and XLSX format) and HTML files from
Comparison of reports
Hi guys, We check our reports each Friday. Is it possible for ZOHO to compare this week's report to last week's report, and show us the changes that were implemented in the past week for the same report? Please let me know. Kind regards, Ninke
Next Page