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.
Dynamic Chart Filtering
Hello. I look at the post here: http://blogs.zoho.com/general/dynamic-chart-filtering-and-url-data-type-in-zoho-reports The Dynamic Chart Filtering is exactly what I need for my chart. I have 3 Columns: 1. The X-Axis - Series of number 1 Through 145. 2. Y-Axis - Data (Integer number according to the X Series). 3. Y-Axis - Data (Integer number according to the X Series). I create a Line Chart out of them yet can't enable those Checkboxes feature. How do I enable it? The Chart can accessed heres:
Charts sorting in numeric reverse
I have been having this problem a lot lately... The charting feature of Zoho reports is sorting everything backwards. For ethical purposes, values should be sorted from smallest value on the left to highest value of the right (0 -> 10, for example) from the bottom left of the axis. Currently, I can only create charts in my account that sort from the highest values on the left tot he lowest on the right (10 -> 0). [see attach. for example] Is there something I am overlooking when creating the
Date fields won't import from Zoho Creator
I have 2 date fields in a Creator form that are MM-dd-yy. They refuse to import into Zoho Reports even though I have set the column properties in Zoho Reports to exactly the same format. The import job says: [Line: 2 Field: 6] (03-08-10) -RESET : Invalid Date value [Line: 2 Field: 7] (03-09-10) -RESET : Invalid Date value [Line: 4 Field: 6] (10-10-09) -RESET : Invalid Date value... A sample of the CSV feed from Zoho Creator (the 2 date fields are on the end): Child Leader Training,Charles,Guinea
Exporting multiple views as PDF
When I select the option to include multiple views in a single PDF, I cannot see all of my views in the selector. For some reason, I can only see 6 out 11 pivot views. How can I get the rest into the selector so that I can include them in my PDF file? Thanks for helping.
Newbie questions
Hi, I was wondering whether it is possible to: Have dynamic filters visible on published pivot tables (similar to graphs) Have graphs based on pivot table / reports Ta Ian
Cannot Filter when a Element has special characters
I have a report and need to filter all the records that contains "España". Since the systems doesn´t recognice the "ñ" character the filter wont work. Help
Filter in Tabular view does not save
I must say I don't understand. I have one database. I create a tabular view based on that database. I filter a column based on one of the column values. I save it. Now when I select this view there is no filter. WTF?
My data appears and disappears
One day I was working on my main database that has all the contacts for my company. I was sorting by a category, and all of my data disappeared from view. Not even the headings for my columns or the row numbers were visible anymore. The weird thing is that since then, sometimes the data can be seen and other times it cant. The two of us working both have Mac computers. We have had the problem in two separate buildings. A person we called and asked to look at the database could see the
Prevent people from copying table content?
I have a page on my website that provides membership information for a chamber of commerce. http://www.zhchamber.com/memb_dir.html Is there a way to prevent people from selecting the information in the table and copying it. I want people to be able to view the information, and to click on the e-mail and website links but not be able to capture the table content in any way. I use a software called HTML Protector which works great for anything on a web page but it doesn't protect the content of
Next Page