Problems Uploading from Sybase 10.0.1.xxxx
I am testing the upload tool for a single table, and I am getting the following error: Invalid Packet Type 0x10 (Error Log Attached). Also my Sybase Console windows show after the upload connection: Connection terminated abnormally Disconnected TCPIP client's AppInfo: HOST=XENSB1;PID=00000123;EXE=jTDS Any Ideas? Thanks!!
Zoho Reports service unresponsive - effectively down
Look at the average response time for Zoho Reports starting at around 5PM PDT - there is a problem. 1 minute to login, over 5 - 10 minutes to open a database, sometimes it never opens. The service is effectively down and has been for over 4 hours. Please help
Percent converted
I am having a problem with a percentage number (100%) being converted to (1%) when uploading from an access database into my zoho table using the upload tool. The way I have this set up is that users update a xls spreadsheet, the xls is linked into an Access db, then with the upload tool I update the zoho table. When I look at the data in Access it is formated correctly. If I manually upload it from the xls it works fine. Please advise Abel Melchiore
Zoho CRM Advanced Analytics Add-on, powered by Zoho Reports
We are excited to announce that Zoho Reports now provides advanced analytics for Zoho CRM. With advanced analytics, you can now be on top of your CRM data, which helps you make informed business decisions. The below slideshow has step-by-instructions on how to setup Zoho Reports Advanced Analytics for Zoho CRM. You can find more information of the add-on here - http://zoho.com/reports/crm Help documentation for the add-on is here - https://reports.wiki.zoho.com/Advanced-Analytics-for-Zoho-CRM.html
Problem With Importing SQL Data
I have setup the import tool and have successfully imported most of my tables & data. From my research, the data is first streamed into the temp directory as comma delimited files - as opposed to strings also being enclosed in double quotes " ". Here are some problems: 1) On the Comments field, the data comes in as net.sourceforge.jtds.jdbc.ClobImpl@1c8ef56, as opposed to the actual data 2) One table does not come in at all - error: exceeds the maximum length. Maximum allowed column length is 100
Scheduled Export Didn't Work
Greetings: I have a scheduled export going out on Sunday mornings at 10 GMT. The recipients tell me they didn't receive it this weekend. Since there are 8 recipients, they are in two separate lists. No one from either list received the export. Was there a problem with this feature over the weekend? Thanks, Keith
500 errors on CSV import API
Hey guys, I keep trying to upload a CSV file and have checked I have all the right params but I keep getting this response: {"response"=>{"uri"=>"/api/<USERNAME>/<DATABASE>/<TABLE>", "action"=>"IMPORT", "error"=>{"code"=>7005, "message"=>"Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into.\n\nIt would be of great help if you could provide us with additional information using the \\'\\'Feedback\\'\\' link at the top of this page."}}
Sending email based on SQL query
Hi, I was wondering if there was support somewhere in Zoho for sending emails based on results from an SQL query. I have a query that returns all deliverables in a project that are late. I would want to send a reminder to all people responsible for these deliverables. Right now the solution is to look at the table and use external email, so I was curious about possible support for automation, either inside Reports or if you combine it with other Zoho parts.
how can i add more fields in row and data in reports ?
i have made simple form contains 24 product like product name and box for qty user have to add qty in all 24 fields i want total of all the 24fields in report but i cant add more than 5field in row, coloumn and data. Please help me i am new here
Characters Allowed in Conditional Formatting
Greetings: I'm trying to apply conditional formatting to a column so that names are always entered "LastName, FirstName". (Last Name, Comma, Space, First Name) I created a conditional formatting rule for the column to turn the text red and and the background yellow if a cell Does Not Contain ", ". (That is a comma followed by a space.) This doesn't work. When I go back to look at the rule, the space after the comma has been discarded. How can I express this in a rule so that "Smith,John" is displayed
avgif() aggreagte formula return incorrect report
Thanks for all the help with bugs and usability issues I've had so far - all have been promptly sorted. Thanks. The report is 'Test year' I have 3 fields - Month, Year and Gas units used in the formula: This works correctly with two columns showing 2011 and 2012 data in ther report. avgif("Month"='January',"Gas units")+avgif("Month"='February',"Gas units")+avgif("Month"='March',"Gas units")+avgif("Month"='April',"Gas units") This works works incorrectly as there is no 2012 column in the report. avgif("Month"='January',"Gas
Zoho Reports merge Zoho CRM
Dear Support, How can I get the Zoho CRM information from Zoho Reports? Thanks. Paulo Miguel.
Summary sorting is messed up
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=746239000000010800&STANDALONE=true&privatelink=c2edda58739eed9695142b92734b6b7e&ZDB_THEME_NAME=blue I wish this Summary View to be sorted by the first 2 columns. Simply by editing the title of columns 3 and 4, it sorts by those columns instead and I am unable to remove the sort (without deleting and re-adding columns 3 and 4 - but then the cycle starts all over again as soon as I try to edit the column title). Correction - it isn't the updating
Problem importing date field from mysql from upload tool (Zoho Reports)
I have several date fields in MySql (stored as BIGINT) as time in milliseconds. When I try to upload these tables using the upload tool, I see the date fields get stored as 0s in the Zoho tables and I see corresponding errors in the log file saying that the date fields are invalid. However, when I look at the intermediary csv files created by the upload tool, I do see that the date columns have the right value. Further, I can manually upload these csv files through Zoho reports and the date field
Zoho Reports Questions
Hi all, New user of zoho reports and loaded with questions. * What does the color field on the charts do? * Can we add filters to a dashboard? * When I view a report I can get the data for that pie segment. How to get all the data for the pie chart? * Can I make a chart off a pivot view? * Can I make pivot tables and make charts of them? * On the dashboard how do I remove the chart names and why isn't the chart title displaying? * Does the filter by graph work for date/times? * How do I tell the
Clients landing page
Hi, I need to create a landing page for my clients where they can access reports based on the sharing criteria I have set in each report. The landing page should have: - login - customised logo and url (zoho should not appear anywhere) - https - only display the reports authorised for that particular user - do not allow data export/download Could you please advice on how to realise the above? I have a zoho reports professional account. If necessary, I am willing to suscribe to any require app (e.g.
Import from SQL Azure database
Hello Is it possible to import data from SQL Azure database? If yes, please provide the connection string format that has to be stored in database_connection_params.conf file. Thanks
Formatting Time Elapsed
How can I format time elapsed (ex. 00:02:34) without date information and without converting to text? It won't accept [hh]:mm:ss. Thanks.
Can we customize logo?
can we customize logo in the zoho reports software??
Export and import options disabled
I just joined zoho community and would like to export IPL table for processing in R. But the export option is disabled. I have a free account, is that the problem?
Name of Chart indicators change depending on the function used
Hi, I have an issue with the charts that I hope somebody can help me with. Whenever I use SUM in creating a bar chart with my indicators, I get the word TOTAL added to the beginning of my indicators which changes the meaning altogether. Is there a way to remove or disable this? Thank you!
Using Bar Charts: Selecting SUM adds the word "Total" to the beginning of an indicator
This happens whenever I use bar charts and there doesn't appear to be a way to remove this if I use bar charts and SUM. This changes the meaning of the indicator completely and we'd like to know if there's a way to remove it. Thanks!
Source table of a report
Hi Zoho Reports forum, I'd like to know if there is a way to know which table(s) is (are) used by a report. Is it possible ? Thanks ! Cimballi
Calculated fields: Initial Data or Let ZOHO do it?
Hello Guys, I'm new to report writing and I'm looking for some advice on where the responsibility lay for calculating data. Should calculated fields be handled by the initial app/database server pre-import, or by ZOHO from the raw data once imported? Let's use a simple example. I have two tables, related to one another. Customers and orders, each order has a customer, each customer could have many orders. Say I want a field that gives me a count of the number of orders each customer has, and others
Column formula for "greater than" and "less than"...
Question: "Is this the correct formula for the example below?" The reason I ask is when I try to place it into the "Add Custom Formula" screen, this error message appears "Specified formula is invalid". =IF("Total Commission"<=10,"Total Commission", IF("Total Commission">10,"Total Commission"*0.80)) Total Commission Agent Commission ---------------------------------------------------------------------- 1 $3.00 $3.00
Microsoft Access upload to Zoho Reports
I've been attempting to configure the upload tool to import some MS Access tables into Zoho Reports. However, when I click on the "UploadFromDB.bat" file, it immediately quits. No log file is created. I've gone through the wiki article on how to set it up but am having no luck. Does anybody have an example of the configuration file setups? This really shouldn't be that hard. Thanks in advance.
Java: command not found when running uploadfromdb.sh for reports
Hi, I'm trying to execute the shell script to upload my database to Zoho, but I'm running into this error when I run it: /ZohoReports/UploadTool/bin/UploadFromDB.sh: line 17: java: command not found Any ideas? Thanks, -James
Zoho Report Number of Rows Shown (wasted "screen estate" )
Hi When Viewing a report Zoho only shows a 16 or so rows and at least a Quarter of my screen is being unused wasted "screen estate" Just makes it hard to look at a report with many rows and yes i end up having to scroll (does zoho own shares in a scrolling company ??) Any way to make reports more view efficient and friendly Thanks
Bar graph
I have a chart and one bar has a total of 300. When I create the graph the total goes on increments of 20 which is great so the chart is not so big. But when I go to view the graph within the application it goes in increments of 2 and then makes the graph to big to view. Now i have to scroll down so much. How can I keep it at the amount of increments I choose. Thank you.
Change the default range?
Is there anyway to change the default range? When I select a column, like "Cost", I can show the range, but it automatically chooses the range. I know that I can filter by range, but I want to know if I can change the default values?
Downloaded excel file report - dates not working
When I export a report the date fields aren't working (see attached file). Only a handful of the dates are recognised by excel as dates, the rest are recognised as text. No matter what I try in excel I can't get the Zoho date fields to show as dates. This stops sorting ability as well as creating charts and formulas. This only happens with Zoho reports that are extracted. It's made even worse in that only "half the fields" have this problem. See the attachment. Really need a fix!
Querying for a date range
Hi, I did the following query table SELECT "Email", "First Name", "Added Time" FROM "GGIT Applicants" where "Added Time" between '07 Apr 2012 00:00:00' and '15 Apr 2012 11:59:59' and it is returning results that include March. Please help! I have attached the returned results. Note there are many more records in the database but it only seems to get confused with March. Thanks for the help!
Unable to refresh pivot report
I am unable to refresh several pivot reports. The request is timing out. I know the reports are quite large but I don't know how to improve performance in order to see updated information in my reports.
Calculated fields:Initial data import, or let ZOHO do the work?
Hello Guys, I'm new to writing reports, and I'm looking for some advice on where the responsibility lay for generating calculated fields. Whether it should be done by the app/database server pre-import or by ZOHO once the raw data has been imported. Let's look at a simple example. I have two tables, Customers and Orders, each order is assigned a customer, each customer may have many orders. Say I want to know how many orders each customer has placed, or that customers total spend, or their average
Error when creating report for related table.
Hello All, I've got a couple of tables that are related by a lookup column: Orders: OrderNumber Value Deliveries: OrderNumber DeliveredDate I'm trying to generate a report that gives me a count of deliveries and a sum of their value for a given month of delivery dates. i.e. Deliveries in January: 5, totaling £12,000 However, whenever I try and do this I get the following error: Sorry, you cannot have numeric column(s) ('Column,Column4'), from the parent table ('Untitled-1')", when text/date columns
Upload Utility - Import Type = Add. replace if already exists
I am using the Upload Utility to try to upload data. I have successfully uploaded several CSV files using the import type of "Delete Existing and Add" and "Add at the end", But when I try to upload a CSV file using the "Add, replace if already exists" import type, it seems like the upload is getting hung up. The status on the bottom of the GUI interface says "Logged in Successfully, Uploading data", but it has been stuck on that for several hours. I have entered the name of a single column in
Problem With a Bar Chart
Hi, I am new to ZOHO, so please help me out in this one I have 5 columns for which I have to create a bar Chart just like in excel. They dont have a year column but still i can create a chart in excel using the same data but here in ZOHO the bar chart icon is grayed out, can somebody help me in this one?
Ability to pass Fields to ZOHO Reports via URL
Is it possible to pass fields via url which will be added to the report dynamically, i.e. http://zoho..../Column=[NEW_COLUMN from database]
Generating random keys for reports in client site
Hi, i wonder if you can help me, i have a site where i have different customers, i generate with zoho reports, reports so they can see their status, when i generate a reports with random key and embed in my site it´s ok, but the url stays static, is there anyway i can make a code to geturl from zoho reports to put in my website and my website update the links with new key, so i can generate random keys everyweek?
User filter by column
I Have a table that is a golf score card. Each column is a different hole. I am looking to do a pie chart that shows the percentages of strokes you have taken on that hole. This works great for one hole. The issue is that I don't want 18 of these pie charts in my dashboard, I would like it so that there is one pie chart that you can choose what hole to get your stats on. Is there a way that I could set a user filter to switch between holes/column's?
Next Page