Custom formula throws error when changing value in lookup column
Hi, I have a table called ExpenseFact which has one Lookup Type column called "AccountType", one custom column called "cGST" that removes 15% of an existing field called "Total", and another custom column that is derived from "cGST" field and is called "cTotalLessGST" which is simply "Total" - "cGST" field. When I created the two custom formulas the values were refreshed correctly with no issues. However, if I update the value in the Lookup Type column called "AccountType", the following errors occur:
Upload MySql TinyInt with Nulls becomes Zoho Reports "Text" DataType ??
Hi, Using the UploadFromDB tool, TinyInt columns (containing Nulls) in my MySql DB become TEXT datatype in Zoho Reports table (on first upload with auto-create Zoho Table). This text datatype makes graphing axis data type incorrect (text instead of number). Would it be possible to make MySql TinyInt (containing Nulls) = Zoho Reports Table NUMBER Datatype? Is there a work around? Thanks, Jason.
publish -> url for this view
Hey, Is it possible to integrate the "filter" in the "publish -> url for this view" ? I want to publish url's so the viewer sees already the ask information. Example: I create a database of sportsresults with there information in Belgium. I use the filter on sportsclub town (or town and date ect) and want to save this in the url. Integrating this link on a site the viewer must do notthing when he follows the link, and see only the results of that town. Help would be helpfull. Thanks
Can a shared user have publish rights?
I would like certain users to be able to publish specific reports to a public blog without having to ask the database owner for the embed code. Is this possible?
Convert String to Date
I need to be able to take my string and convert it to date, however I am no SQL master. I am getting nothing returned because the time is being captured in the date field, What I want is only the date (MM/DD/YYY) to be captured in both "Pick_Date" and "InvoiceDate" Columns. Current its capturing (MM/DD/YYY/HH/MM/SS) The query I have written is below Select InvoiceDate, Grade, GradeName, sum(GradeNW)/sum(ProductionNW) * 100 as "percentage" from prod_sum_nw, grade_sum_nw Where InvoiceDate = Pick_Date
Zoho Reports SLOW
Zoho reports has been slow for me for the past day and finally it stopped working today and I got the following error message when trying to add rows from creator Error details:Error occured while on Success script.Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page. Please look into this problem I can't
Scheduled Email in Reports
I have read that this is possible, but i cant seem to figure it out. I want to send a weekly CSV of my data in reports to someone via email. How do i set this type of schedule up? Thank you
New Customers in Reports
Hello, My company is trying to create a report that show how many new customers we have gotten per month. In Zoho CRM, we have converted the contacts module to show our customers. We have a checkbox that differentiates between active and inactive customers, and we want to create a report that shows when a customer switches from inactive to active. The problem is I don't know how to get Zoho Reports to show when a change is registered in a field, specifically the active / inactive checkbox. I want
How to format date when Uploading Data from in-house Databases?
Hi... I wonder how to format as a date specific data type when i upload data from in-house DB? whereby the db field itself is a varchar like "2012-12-31". I realized that it can be done using csv by specifying ZOHO_DATE_FORMAT but how to do it from in-house DB query? Thanks in advance
Print Multiple Pivots on single PDF
I want to be able to break my sales data down into sections by customer and month, with those sections i want to add all the sales details (units sold total net, cost/unit/ sales value gp % price/lb ect) Then i want to print it all on one sheet. i want it to break out like the "Group" function in Zoho Creator list view
Force axis range
I am reporting on some AdWords campaigns. One particular campaign only ran for a few months per year. My date range is 2010 - 2012. For the report on that campaign, the x-axis truncates to only three months. I want it to show all months in the range to make the report conform with the others and convey the window as only being a portion of the time covered. However, I cannot figure out how to force the date range on the axis. The report filter is set to all the months in the range. I imagine
Query table timing out when trying to save
I have a query table that pulls from 2 tables with 200k+ rows. When I try and save it it gives me the following error "Execution of the specified query was aborted, as processing time exceeded the allowed time limit. This is done to avoid any performance impact on the Zoho Reports service. Some tips to avoid this: Verify whether you have unnecessary table joins in the query Or could you simplify it further Verify whether you have redundant "Order By" clause or any "Order By" over a general plain
Big querry
Hi, Can zoho reports handle big query like google big query? I want to send sql query which will fetch may be some 1000 rows of data from table/s with a few 100 million rows.. I do not want to import the full table as that would be 30-40 GB... Can zoho reports handle such scenarios? regards sg
Percentage change in Y axis of chart
What is the way to make a chart graph the percentage change from some initial value? Think of a chart that shows the percentage gain or loss in NAV of a stock account, relative to some benchmark. The user of the chart could change the period they are interested in seeing based on their preference, but the chart would always graph correctly. Thanks Harry
Maximum number of row exceeded
Zoho is telling me that I have exceeded my maximum number of rows (100,000) even though I have fewer than 20,000 rows total in two tables. Does anyone have any idea why that might be the case? Thanks
New String Value Column
Hello, I am trying to create a custom formula in Zoho Reports. I have a column with multiple string values with true and false. Column: Isclosed String Value is: "true" "false" I want 2 new columns to display: Open "true" & closed "false". what would the custom formula look like? I have tried many different formula but with no success. Thank You, Arron Robles Blue Pumpkin Hosting | Solutions Made Simple
Sheet More Flexible than Reports (Sheet vs. Reports)
Hi, I had an issue I wanted to test: Issue: Needed project description data listed and displayed. Analysis: Commonly used Sheet to display test data as would an ordinary HTML text-based report. Policies and historical project data are kept within a single workbook. Synopsis: Questioned whether Reports could display data the same as Sheets, essentially creating a DB compared to workbooks. When tested column data was straightforward; basically in Reports, all the data entered in Reports are tokens
Replace a table in views
I had a table that I used to test a bunch of queries and views. I then created a new table with real data. Is there a way to associate the view to the new table (fields are the same) without rebuilding? I can do it for custom queries where the SQL is coded by simply replacing the table, but I did not find a way to do it for views as these use the drag and drop functionality. Any help ? Thanks
Integrate data from Zoho Reports into Zoho CRM?
I have used Zoho Reports for over a year for advanced business analytics. The recent announcement of your integration of Zoho Reports with Zoho CRM makes me want to try Zoho CRM, since we already have Customer details, Sales details in a database in Zoho Reports, is it possible to sync this into Zoho CRM? At the moment the data goes into Zoho Reports via the Zoho Reports Upload Tool, can I connect the different categories of data already in the Zoho Reports database (Customers, Sales, etc) to Zoho
Error 7103 with shared table
Hi, I would like to know how to connect via http to a table which is shared conmigo.Lo attempt and the only thing I get is error 7103 when if any.I have all permission. uri="/api/zohouser@xxxx.com/PRE/RTI_IMPORT" action="EXPORT" code error 7301
Column Headers - Orientation of Text
Could you please advise me whether the column header text can be changed from horizontal to vertical? I have a report with too many columns to fit on one screen, but only because the column header texts are too long (I can't make them any shorter). The data in the columns are numbers, fixed to 2 dec places and with a maximum of 5 characters.
Copy Featured Samples into existing Profile
I'm new to Zoho Reports. I used the mountain bike featured reports Campaign Level, to build my first set of reports. Now there are AdGroup reports also in the Featured Reports. Is there a way to copy these reports into my existing folder set so I can link them to my existing database?
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.
Next Page