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
importing added time as "text" field
I am importing into reports and need graph by mont/year and "added" time is giving me date/month/year/time: I tried changing the column into date with formula but it does not work, Please help!
Calculate - String Replace Help
Hi - I am needing to convert a text field into a number field that I can use to calculate on: Examples: 2d 3h 35m 53s 2d 10h 35m 53s I would like to convert this string into MINUTES so that I can do a calculation of total time elapsed from CREATE DATE. Anyone have any suggestions? Many thanks!
Formulae to pick data from different sheets
I wanted solution for this problem where I had some currency in one data sheet and the exchange rates in the other. How can we plug a formula that picks the exchange rates from that sheet and converts it into required currency. Ex: Converting 100 Euros, 20 INR, 40 GBP all in one sheet to USD.
April 29, 2010 Update : Export Mutiple Views
In today's update, we enhanced the Export Multiple Views option. Previously, you had the option to export (save a copy to your desktop) multiple views as pdf alone. Now we have provided a couple more options. From the Export menu of a report/table, choose Export Multiple Views. You'll see the options as in the above screenshot. You can choose the views to be exported as 1) a pdf, 2) a zip file consisting of csv files (each csv corresponding to a report/table view) or 3) a zip file consisting of image
Report Security Timeout
Hello, Is there a way that I can produce and publish a report so that it does not timeout when I log out of my account? Currently, viewers can access a report I produced and published and all of its capabilities (i.e. Excel Download) as long as I am logged into my account. Once I log out of my account, users can no longer utilize the download featur Thanks in advance for help.
Cloud SQL external data import into Zoho Sheet giving "Problem in configuring WebData."
I have a Zoho Sheet in which I have several external data links / imports from Zoho Reports via Cloud SQL / Zoho API. All was working perfectly when i created it and for a a few weeks after, meaning any changes in the Reports data was correctly reflected in the Zoho sheet. I noticed today that the data wasn't being updated from Zoho Reports in the Zoho Sheet. When manually updating the external data link, it gives me the error "Problem in configuring WebData." Absolutely nothing has changed on my
CloudSQL Export permissions
I would like to be able to export data for via the CloudSQL API for users other than the database owner. I read this post (https://help.zoho.com/portal/en/community/topic/questions-about-sharing-databases) which seemed to suggest that this feature was being implemented but the feature that was announced at the end of that thread does not go far enough. From what I understand currently other users can only export data from reports they have created based on an underlying table which they have export
More dynamic chart filtering
The existing dynamic filtering is great allowing users to filter charts by the field on the Y-Axis of the chart but I would also like to be able to filter the data in the chart based on a filter parameter in the published url of the chart. Ideally this would work like the existing ZOHO_CRITERIA available on the Update, Export and Delete actions.
Multi line reports
I would like to see simple, multiline, reports offered that will work with the Creator database.
April 8 Update - Import limit increased
In the latest update, we have increased the data size that you can import using the Zoho Reports user interface from 100,000 rows (or 3 MB) to 500,000 rows (or 10 MB). ps: for larger data imports, you can use the Upload Tool.
Error entering DB Users for sharing.
When trying to add a new (first) to the DB Users group I get the follow error. this only appears to occur in my pricelist database, I have tested another database and it works fine. Error: The parameter USERS does not match the accepted input pattern. Plus The parameter ADDEDEMAILIDS does not match the accepted input pattern.
CSV Import tool not batching?
I get the error below when trying to use the CSV Import tool with a 58 Megabyte file. Mar 31, 2010 6:52:37 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended. Error!!! Sorry, you cannot upload files that exceed 3MB in size. You could Zip the file and try uploading the contents or use our Upload Tool if you are using CSV File. Please contact support@zohoreports.com
I'm Missing Something...
Well, I feel like I'm missing something here... on Reports, I just want to create a report with a formatted page. Not a chart or table; just a formatted page. Where I can drag and drop fields, set up a repeating section? Is there a way to do this in Reports? I mean, it seems like there should be a way to do this? Any advice appreciated - thanks! R
is jQuery that smart?
Can i have a jQuery autocomplete to have the following behaviour ? I want the autocomplete to get data from DB only if the data is not available in the javascript array. Can i do that?
Copy DB via API
Is it possible to copy a database via the API? I need to be able to copy a pre-defined database before uploading data to the newly copied version. Currently the copy stage has to be done manually and I'd like to automate this step if possible. Thanks, Adrian.
Importing from alternative user using the the Upload tool
Hi, I need to import data using using the Upload tool from an alternative user (not the user who created the database) I upgraded my account to a standard plan that allows a multiple db owners. I then make that user a db owner. I verified that the new owner can see the database (under Shared to Me) and can import from the web interface. However, the Upload tool fails with the following error: jre/bin/java Logging in Logged in successfully. Uploading data... Mar 29, 2010 10:09:59 AM org.apache.commons.httpclient.HttpMethodBase
8518 error
when i put data to reports by request. i got an error for that − 8518 You need to (re)login to perform this operation and my request url is http://reports.zoho.com/api/sihanjishu/seven/use?ZOHO_ACTION=ADDROW&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=mykey&ticket=mytickt&ZOHO_API_VERSION=1.0' -d '&user=xxxxxx&host=fsfefsfsef&svn=fsefefsefff&version=201003142307&action=test
Printing from Imbedded Report
I have imbedded a report [Edit: from Zoho Reports] in a Creator HTML View. How do I print it? Thanks.
Zoho report client API for Java Spring integration - spring-zohoreport release 0.1
Spring-zohoreport project aims at simplifying the use of the Zoho Report Java client libraries and wrap the client configuration with the Spring framework bean configuration. So far, only Zoho Report client libraries can SELECT, UPDATE, INSERT and DELETE datas whereas Zoho CloudSQL (so JDBC driver) is limited to SELECT. This project uses Spring IOC container to manage Zoho Report client as a bean. The spring-zohoreport release 0.1 adds more documentation, http(s) proxy configuration and maven project
Zoho report client API for Java Spring integration - spring-zohoreport release 0.1
Spring-zohoreport project aims at simplifying the use of the Zoho Report Java client libraries and wrap the client configuration with the Spring framework bean configuration. So far, only Zoho Report client libraries can SELECT, UPDATE, INSERT and DELETE datas whereas Zoho CloudSQL (so JDBC driver) is limited to SELECT. This project uses Spring IOC container to manage Zoho Report client as a bean. The spring-zohoreport release 0.1 adds more documentation, http(s) proxy configuration and maven project
Export Underlying Data as CSV Issue
I am currently working with a Pivot Table of a hardware inventory database. While I love the quick view of the underlying data in a pivot row or column, I need to pull the underlying data into a new form to create a listing of hardware that will be phased out of our system. In the past I have been able to create this by exporting the underlying data feature in export. While I can choose this option when I click the "Export" button the "Save" dialogue box does not open. Using either of the current
Cannot create table from html import via non standard port
I attempted to import an html table from http://<site>:<port>/file.php , however the connection times out. When I switch my server from port 8080 back to port 80 everything works fine which tells me the import utility has issues accessing a website running on a port other than 80.
Maximize embedded report within a web page
I am seeking assistance with how to expand a report/table that is embedded within a web page so that is viewable. Presently, there appears to be a "player" window that renders within the web page, but features like scroll bars and maximize/minimimze do not appear. Guidance would be sincerely appreciated.
Next Page