Chart url errors
I published url's of my reports to my website, but after I enter new data and save, we can no longer view them as we get an error. I was under the impression that when you saved info on your database it would automatically update your chart with the new figures. What am I doing wrong?
column aliases should take precedence over columns in underlying table
When I do this query: SELECT IF( landing_niche IS NOT NULL, landing_niche, 'none' ) AS niche, months.month AS month, COUNT( sites.id ) AS sites_count FROM months, sites WHERE sites.inserted_at >= months.month GROUP BY niche, month It groups on the values in the "niche" field in the sites table, instead of the value of the aliased column "niche" in the select query. The alias should have priority over the fields in the table. Or actually, perhaps you just shouldn't be able to group on
Report does not show new data added to the table
Hi, I created a report based on a table and saved it. When I add new data to the table, it does not show up in the report. I also clicked on the "refresh" button when the report is open, and it still shows the same old number of records instead of also showing the new records that were added to the table since the report was designed and saved. What am I doing wrong, and how can I view the new data in the same report? Thanks. Update: Never mind. Please ignore this - figured it out. You may delete
Are these features available?
Hi, I need the following features: 1: To be able to email reports (to, cc, bcc, embedded, as attachments). 2: To be able to schedule reports (I select a report; mark to whom it should be mailed to; set date and time; set if it should be repeated after certain intervals like daily, weekly). 3: Bursting of reports. 4: Dynamic labels (I want yesterdays date, derived from todays date, in the label) Are these features available in zoho reports? And in which plan? I am using the free edition of zoho reporting.
How can I change the number of decimal places displayed in a pivot table?
Hi, I have created a pivot table where the values are averages, calculated from the source data. The values in the source data are all to 1 decimal place, but the averages in my pivot table are showing to 5 decimal places. How can I change it to 1dp instead? Thanks Debbie
SQL Server fields concatenated in Zoho table
Hi! I'm using UploadFromDB.bat to move a table from SQL Server to Zoho. The Zoho table has the same columns as the SQL Server. But the data from two of the columns are concatenated. In all the subsequent columns, the data is shifted one column over to the left, and the last column, of course, is empty. The data in the messed up column has a comma that (I suspect) is supposed to separate the two fields: 11th Annual Meeting of the Society of AAA BBB ,Society of AAA BBB Could some data have a character
Cannot Process Text Parameter to Tabular View Report
I'm setting up a couple of base reports. Then, on my website, I'm displaying the same report using ZOHO_CRITERIA to select relevant data for the specific pages. The syntax for this command doesn't appear to be consistent, and it doesn't always work. Report Type = Chart View, embedded as an image. This is working OK for me using the syntax ZOHO_CRITERIA=(Area='Potomac') where Area is my field and Potomac is the value that I'm filtering. Report Type = Table Report, embedded as an iframe. This works
Additional Graph Options
It would be great to have additional, standard graph options. Especially these two types of common graphs. - Clustered Columns - Combination Line and Column Thanks.
Comparing Dates in Custom Formula
I'm creating a Custom Formula Column in a table that will compare the value of dates and return a value. I'm unable to figure out the proper syntax when working with dates. This seems very simple, but I can't find any reference on this site . I'm trying to get a simple formula to work. Pls advise on the proper syntax for the following statement. Right now, this returns 'False' regardless of the date. if(CloseDate>'October 30, 2010','Current','Past') ... also tried if(Status='Sold',if(CloseDate>'2010/10/30','Current','Past'),null)
Create/Update Query Tables through API
Is it possible or are there any plans to support creating Query Tables through the API? I would like to be able to Version control the queries that I use in my Query Tables (in case they get accidentally deleted, modified, etc.) and so that I can recreate them in different Databases through code.
vicious circle
The validity checks can be nice, but they also get in the way. What happens when I am writing a query and realize that I will actually need another table or query underneath it? I can't save the query I am working on until I create the underlying table or query. Which means I have to leave my work unsaved while I do that. I would prefer to be able to save my query even though I know that it won't work right away. Another situation: I need to change a column name in an underlying query table. I
comments in sql queries?
I am creating some complicated query tables and would like to leave comments. I've tried // and #, but neither work. Please, advise.
Publish URL/Permalink for a view - Selecting "access this view/table without login" and it continues to prompt for login
Steps to Reproduce: 1. Select a query 2. Select "publish" and then "URL/Permalink for this view" 3. Select "to access this view/table without login, click here". 4. Select "Include Data Type Symbol", "Toolbar" and Edit Private Link Permissions (select Read Access and Export Data) 5. Copy URL code 6. When accessing, this URL, it prompts for login. Obviously, the expected outcome is for it NOT to prompt for login. Please note, I have even tried to regenerate random key and that does not help.
Query Table stopped working
I have a query table that has worked fine for several weeks now. All of the sudden I went back in to add one more column and it is telling me this is not supported by Zoho yet. When I hit execute query it works fine. Please help me! Thank You! Jeremiah My query is below SELECT '' as 'Report_Id', 'POL' as 'Record_ID',curdate() as 'Transmission_Date',NAIC_Code, Transaction_Type_Code,policy_number, date("effective_date"),date(expiration_date),'' as 'Policy_Cancellation_Date', '' as 'Filler', Individual_Company_Indicator,
"Invalid column used" when using column aliases SQL
The following query runs and saves fine: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" However, this isn't that useful because it's not ordered. So, if I just do the final step: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" ORDER BY Sales DESC The query executes and displays what I expect. However, if I click "Save", I then see an error message: "Invalid column used". I'm convinced
Safe ticket call
I'm developing a Google Apps application where users can add data to my Zoho Reports database. For this I use the AddRow method from the API. But, to use this method I need a ticket id which needs to be refreshed every 7 days. The Zoho Reports ID and the Zoho Reports Password is required for this action. Is there a safe way to make this call. I think placing the login id and password in my code and run it as an cronjob every 7 days is not a good idea. Can I send an encrypted password or can I increase
Problem when Exporting data through API without a ticket
Hello, I usuccesfully followed instructions to export through API without a ticket given in topic (https://help.zoho.com/portal/en/community/topic/remove-quot;ticket-quot;-from-mandatory-parameters-on-export-api-calls) The result I get is this message: { "response":{ "uri":"[...]", "action":"EXPORT", "error":{ "code":7309, "message":"You need to (re)login to export. Incase you have logged in already,then please refresh the whole page(browser) and try again." } } } Thanks for the help!
Import data from datastore
I have an app engine datastore. Is there any way to bind it to Zoho reports? Greetings
Dynamic Filter?
Is it possible to create a user selectable dynamic picklist filter for the reports? I would like to be able to define the picklist of one field by what is selected in the previous filed like we do with picklists in creator. Please see example below that I would like to be able to implement to the "View Mode Filters" if (count(Serial_Numbers[Description == input.Description]) == 0) { clear Serial_Number; } else { seriallist = Serial_Numbers [Description == input.Description] sort by
MySQL - managing data
Hi. Can you help me, pls?! How can I manage data from Oputils 5.0? I mean access to data over (for example) EMS MySQL Manager? I tried it, but no accept "localhost" / "root" / (no password) .... Thanx! P.V.
Lost Data in entire table in Reports
Hello Please help. For some reason I can no longer see any data in one of my tables in Reports. It is called ALL_AUTO. We use Zoho as a place to store our info and if it is gone it will take weeks to recreate. Please help me if you can! Jeremiah
Pivot Table
Can i use the Report API to modify the column of the pivot table on the fly ? Thanks, Nimesh
Changing column based on combo box
Hello, I am a relative newbie and was wondering if this can be done in Zoho reports. I have two tables, one with two columns listing a unique id and question name and another table which lists each of the question name as a column and some more variables to perform slice and dice. I want the first table to be a drop down so when a user selects a question in the drop down that particular question is shown as a column in the report with the data obviously coming from the second table. Does that make
test ZOHO functions
My enterprise is planning to buy a BI tool to create Dashboards, we are testing several tools to see if their functions match with our requirements. Zoho seems to be a good tool but before buying it I would like to be sure it can do everything I want. The demo gave me some information but I have some questions about ZOHO reports : Can I generate all the following chart types ? Can we modify the minimum and maximum values of the vertical axis Can we remove selected labels on charts ? Does the tool
Editing Design of a Tabular View - Zoho Reports
In the other reports I can find an edit design button but do not see how to do so with a Tabular View. How do you change what table it is pulling data from, or even verify what table or query table the report is pulling from? How do you set something as simple as the setting default sort order -- not the last used sort which you do in the report itself, but the sort order it always uses when opening?
Zoho Reports Help
Hi I want to purchase the Zoho Reports Professional program but am trialing the free version to get the hang of it for the time being. Is there anyway one can insert a map or maps into the reports program and use that as a basis for drilling down into the data. It seems that the ability to use charts is quite limited in Reports, although I may not have the knowledge as yet to use it properly. Please assist me. Dan Murdoch dmrs000@gmail.com
Error with Query Table
In my BUP reporting database I have a table called ALL_GL. In this table I have 3 records with the policy_number of MSL0000012. For some reason these records are the only ones not coming over in my Query table. All of the others are. I have deleted the rows and re imported them and it still isnt working. Can you please look at it and see why. Thanks. The strange thing is that records from the same import are showing fine my query is only a UNION so it shouldnt really be doing anything to prevent
Why won't addition functions work consistently?
I am having a problem with a formula column. This has to be the simplest of formulas. Total Wage = Total Normal + Total Overtime + Total Prevailing Wage Each of the above columns are themselves a formula column with a datatype of Currency. Despite the fact that one or more of these columns has data, Total Wage sometimes has no values. I can't figure out why. I have tried Total Wage = (Total Normal) + (Total Overtime) + (Total Prevailing Wage ) I have also tried: Total Wage = (Normal Hours * Normal
Export to Multiple Views - Expandable Folder Options, rather than Showing All Files.
As I'm creating reports for a client, let me share with you what we're doing. 1. We have one database with several columns of information 2. We have 20 markets that have information inside this database 3. We have to create 20 individual dashboards from the information on this database. 4. Inside our database, we have folders - one for each market. 5. Each folder has about 18 reports (each folder contains the same 18 reports, just filtered differently) So, while we can't export the dashboard
Cell Formula
Instead of just being able to add a formula column, how about being able to add a formula to a cell. I know I can do that in Zoho Sheets but I rather use Zoho Reports instead
Retrieve OBJID for chart
Hello, is it possible to retrieve the OBJID for a chart through the API? I can get a list of charts using ZOHO_ACTION=DATABASEMETADATA&ZOHO_METADATA=ZOHO_CATALOG_INFO but I would really like to be able to dynamically build the URIs for my charts for embedding in a portal without having to manually extract the URI for each chart. It would be most useful if the info returned for catalog metadata included in the OBJID for each item. Thanks, Ade.
Copy Reports Definition from other users ?
Hi, I have a few questions: 1.- its possible copy any reports from other user to my account ? 2.- I need create a groups of my customers, its possible make a reports gallery to my clients ? thanks
UploadFromDB.sh password parameter
Hi -- I have the the upload tool ( UploadFromDB.sh ) running on my server and automatically pushing my app's data to Zoho Reports. Works like a charm! However, I don't like entering my password on the command line (where it ends up cached in the shell's history) or in a crontab. Can you suggest a clever way to get the password to the script? Maybe storing it in a conf file? I don't know enough about shell scripting to do this without some advice.
Can someone please "resend" my Confirmation link?
I seem to have lost it, and don't want to lose my account here. Thank you.
User password change
How can I change the password for my user? I´m using the freeware version of ZOHO reports. I can only add or delete users but cannot alter them. Any suggests?
La última Fecha de Compra
Hola a todos, actualmente tengo una base de datos de ventas en zoho report la cual contiene una tabla Ventas con los campos de: Cliente, Fecha de Venta, Nota de Venta, entre otros campos, lo que necesito es generar un reporte en SQL de la tabla Ventas que contenga "Cliente" y la "última fecha de compra" ¿Es posible esto?, he estado checando las funciones que trae por default report y no hayé una que haga lo que necesito. Gracias por su ayuda de antemano.
Zoom
Is there a way to zoom into a particular area of a chart?
Column selection does not work in PDF export in embedded reports
PDF export from a report is a great feature, but I can't get it to work properly from an embedded report or from a standalone link. If I try to select columns I get an error in any browser and specifically the attached error in IE8. It will export all columns but that is pretty much useless. If I am signed in to Zoho it works fine, but I don't want to have to expose my user to all that back-end stuff.
Zoho Reports: How do I get to Admin area to add users?
I can get to the Subscriptions area to Add Users but it only take the email address. How do I set someone up with a password so that they can sign in? I can't find anything on my home page in Zoho Reports....thanks!
Error when saving Query Tables
I have been trying to save many query tables today and they all keep giving me the same error "An unexpected error has occured....please give us feedback". I really need to get something to work, I am working on a project for my boss. This just doesnt make sense. Here is the code i was trying to save. When I hit execute it pulled up the table fine, the issue is when I try and save it. SELECT "Effective Date","Broker","Renewal","Date Submitted","Date RSP Released","Total Quoted Premium","Total
Next Page