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
How do you enable a prompt / parameter or user selectable pick-list that pops-up when zoho report is run
I'd like to filter a report using a parameter prompt so the user choose the dataset when they open the view and/or report. Example: prompt the user for which state they want to view the data for. How do you enable a prompt / parameter or user selectable pick-list that pops-up when the report is run?
Format Column for multiple columns
I'd like to set the decimal place number (to 2), comma and other properties for multiple columns in Zoho Reports for a Report Table. I can select multiple columns but the change only occurs to the first one. It would be a significant improvement to be able to do more than one at a time, even if it is only columns of the same data type. Is there a way to do this? If not, can it be added? -
Is there a way to embed Zoho DB Form to my site?
Hi I would like to embed Zoho 'New Object Form' for my table into my site. Is it possible and how to do it? Thanks, Sincerely, Igor
str_to_date() not working
Try this, it returns an empty result: SELECT str_to_date('2010-05-02','YYYY-MM-DD') I discovered this because when trying to select records in a certain date range, the WHERE clause is failing on the date comparison. Nothing is being returned.
May 29, 2010 Update - PDF Export Support for More Languages, Refresh Dashboards, Maximize UI
The latest update to Zoho Reports brought in the below features UTF-8 support in PDF Export When you export a chart or table as pdf, the pdf export now supports quite a few languages other than English. Japanese, Chinese, Korean and the European languages. Support for more languages will be available in future. Refresh Dashboard Like with individual reports, dashboards now have a Refresh button and can now be refreshed to see the latest changes made to the reports within it. Maximize UI For maximum
Need Report for disk drive and mac address
Dear I have been downloaded AssetExplorer trail software and test it on our organization network. my boss ask to take report about all disk & drive ( HDD,CD&DVD Internal and external ) use in our network and also report about all mac address that there in network please let me know how can do these. Regards, Mahdi BAshiri
1multi-select and grouping problems, please help!
I have a multi-select column that I need to analyze by groups; so I have two problems, when I import it into Reports I get an error due ton 100 character limit. I could try and change the data to (1, 2,3, instead of text) with a script but I do not know how to write the script. Please help
Project Consultant Wanted " ASAP for quick turnaround Technical Assistance
Looking for an expert in zoho creator/reports to help with scripting and formulas within creator and reports. My databases are not that complex, (I am a social science researcher and using zoho as a replacement for spss). I have a lot of questions about analyzing "multi-select" data in groups. I am imagining that it would be about 3 hours of work/TA. Please contact me with rate and expertise. Best, Ramona Ortega Global Networks Consulting
Next Page