Zoho Reports
Hi How to get Click Rate or List Growth data from MailChimp into Zoho Reports Thanks
Scorecard
Hi all, I want to create a dashboard, that includes several metrics and then compare the average value of those metrics against predefined targets. Im not so much interested in having charts in the scorecard, want i want is to structure a set of metrics around our strategic objectives, and then compare the actual values against the target. It is possible to do this with Zoho Reports? Thanks, Juan
Zoho .pdf Reports - very wide and the text too small to read..... Help????
Been going on the past couple of days....can anyone help??
Adding Javascript to Dashboards
I have hit a brick wall and I seem to need Javascript, but can't see how I can get it to work. I want to try and overcome the limitation of the dashboard feature that you can't filter all reports in a dashboard from a single filter option. I need this function. I looked at adding a form on my HTML page which adds in the appropriate CRITERIA code into a URL like so ... &ZOHO_CRITERIA="YearMonth"='201005' But this won't work as the Dashboard is inside an IFRAME. I realised I could add my form into
Linked Dashboards
I want to create a multi level dashboard for my users. Right now I can create a kind of two level dashboard - as optionally - its possible to go from a chart to its underlying data. But lets say I had a pie chart which shows the sales by all regions. I want to be able to click on any region (say Europe) and go to a new dashboard which has the right data. What I need is the ability to apply a link to the pie chart pieces to make it work.
Amount convertion between Invoice and Zoho Reports
Hi, I imported invoice details report from Zoho invoice to Zoho reports (*.csv). I have an issue on invoice amount which one is not well converted by Zoho Report. Exemple ( 2 500,52 becomes 2.50052). Thanks,
Publish URL Permalink for this view
For some reason when I'm publishing a URL / Permalink for this view, it no longer gives me the option to allow for link access without login. And now, my charts are no longer showing up in my dashboard created where it calls the individual charts through a www frame. Can you help me? Thanks, Jamie
MuliCurrency Reports
Can we produce multicurrency reports in ZOHO. If yes please exlain how? Thanks
Importing Multiple Views Into a PDF
Is there a way to reorder the list of reports in the importing field? Kathy
User Filters
I have created a chart that shows the TOP FIVE KEYWORDS for a SEM campaign by click. No problem to do this, and the chart looks great. However, other fields in the database include "Campaign" and "Ad Group" and I would like to allow the user to select the "campaign" and "ad group" to see the TOP FIVE KEYWORDS by each combination. My problem is that ZOHO first generates the report of the TOP FIVE KEYWORDS for the entire account and then the user can only filter THAT data. Rather than the user filter
Zoho Reports-New features rolled out in September 15, 2011 update
New Feature: Conditional Formatting Newly added Conditional formatting feature allows you to highlight cells of a column with different background color and font color to make them easily identifiable and unique. In conditional formatting, you have to specify the required conditions/criteria for formatting. When data in a cell meets the condition, Zoho Reports applies the corresponding formatting style that you have specified. To apply conditional formatting: Select the column (by clicking the header)
Novice struggling with Inner Join in Zoho
This sql is working in Access, but not in my Zoho Reports environment that is a mirror image. SELECT Questions.Q_ID, Questions.Question, Schools.Fullname, Answers.Survey_Year, Answers.Response FROM Schools INNER JOIN (Questions INNER JOIN Answers ON Questions.Q_ID = Answers.Q_ID) ON Schools.School_ID = Answers.School_ID Any suggestions?
Export Chart as Image without ToolBar
Hi, I want to display my chart embedded on my WebSite and give possibility to export it as Image, however I only get it if I set Display Toolbar = True on publish options. The problem is: When Toolbar is visible the user can change chart type. I don't want this. I know that exists the option to publish as an image, but If I do this, I lose interactivity on chart. How Can I do it ?
Reports causing mass duplication
I am simply trying to run a query on our existing accounts with the following columns: Account Name Status Account Size Support Level DSM Status Account Person When I generate this report it's taking my 1101 clients and saying there are 1950 clients. When I look at the report, a bunch of the clients are listed more than one time (sometimes up to 6). What am I doing wrong that's generating all these duplicates? I went into the accounts section and none of these accounts are listed twice.
Dashboard
Hi I want to create DashBoard when user clicks on Day (it should display day's sale) , if month (it should display data of that month) , if year then it should display of that year. Thanks
Scheduled Export
I (and my clients) would love to be able to schedule an export of a table/chat/dashboard to be sent via email in a prescribed format according to a schedule. I would expect that these would be limited to some degree to avoid overloading, but the flexibility of delivering these to an inbox for reading off line rather would be a bonus to many. I have several reports that I know a client wants in PDF format ready for Monday morning project review meetings. It is helpful to them and also provides some
username account inactivated mistakely
sir this is a request to unblock "lpu10800622" user account as i inactivated it today mistakenly....i needed this account to give tests uploaded by my college for placements..please release it today...itz an urgent but humble request...plz plz...
Can we unshare a databse which we shared previously?
Hi I have created a database in zoho reports. I share this database with another user . now i want to unshare this database , and I want to know how can I do this.
Using PHP curl for Reports API
Hi ! I tried to use php code to connect to Reports API, but I'm getting a 505 error Array ( [headers] => Array ( [Date] => Sat, 26 Feb 2011 13:02:00 GMT [Server] => - [Connection] => close ) [body] => [info] => Array ( [url] => http://reportsapi.zoho.com/api/****/****?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=mykey&ticket=tiketvalue&ZOHO_API_VERSION=1.0&ZOHO_SQLQUERY=Some+sql+query [http_code] => 505 [header_size] => 110 [request_size] => 1574 [filetime] => -1
column data formats
I want to create a column that will contain a phone number in a format like this: (406) 656-3311 is there any way to enforce this format on data entered into the column? Also, Can I limit the amount of characters allowed in a column entry somehow?
simple text database with multiple identifying flags or similar?
Hello (ed. this is a bit long, sorry, and I might be wrong with my database terminology) I'm looking to build what I think will be a simple data base, but then again, I'm not a coder, and have not really done anything like this before. I'm an architect. I'm looking to build a very straight forward spec writing tool for small (but often complicated) building projects. I'm pretty sure this zoho will allow me to create multiple records with multiple fields, say a clause number, a title and some body
Nothing Showing up
Howdy, I imported all of my data for a week's worth of reporting and it all imported into campaign performance, however none of the charts are showing anything. Do I have to specify that I want these days and not a MONTH period, if so how do I do that. Cheers ANdrew
Query Table Deactivated
When trying to use a query table I am seeing the following error: This query table is deactivated and cannot be saved or refreshed. Kindly Upgrade your plan to create and use more query tables This is in a database that had been downgraded to a free account and all previous tables etc deleted. However, it appears that the references to the old query tables are still persisting. Any help would be appreciated. Regards, Adrian.
Can I synchronize Zoho Reports folders with another site?
I would like to create a website on which their were embedded Zoho reports. I want to organize this reports into folders. How can I synchronize my folders with Zoho reports folders? There is an API which doing this? Thanks: miamano
Reports that ask for password input
Hello, i have made a table with a password column and then a report for that. I was wondering is there any way when i publish it, the report asks the user for the password field and displays only the row with that password? Thank you.
Is it possible include a HTML menu (button)
Dear Support, Could you inform if is possible include a HTML code that show a Dropdow Menu (eg. below printscreen1) at dashboard? I tried include the HTML code but it's showed only the text (please see printscreen2 below). thanks. Paulo Miguel. printscreen1 printscreen2
Convert Text String (Date Info) into Date Values
We have a number of reports where the data is coming from web input and is slated to be scheduled "daily" As such changing the Datatype of the field from Plain Text to Date would cause the scheduled "fetch" to remove the Date Values. Questions 1) Why can't Zoho Parse a text string (7/26/2011) into a Date DataType during the import - reason for the question is that we will probably learn that we can create a custom formula column but over the course of a 100 reports we have over 500 date fields to
Upable to connect to MYSQL DB
Following is the error I am getting connecting to MYSQL DB... Please Help... First time user 2011/04/28 15:40:19 PDT:Logging in... 2011/04/28 15:40:19 PDT:logging into https://accounts.zoho.com 2011/04/28 15:40:20 PDT:sucessfully loggedin 2011/04/28 15:40:20 PDT:Logged in successfully... 2011/04/28 15:40:20 PDT:Exception occured while establishing connection to the database server 2011/04/28 15:40:20 PDT:java.lang.RuntimeException: Exception occured while establishing connection to the database
Zoho reports
Hi Guys, I am using zoho reports to make my QA reports accessible from cloud. I would like to know is it possible to upload my csv files to upload with into my zoho reports and to create reports AUTOMATICALLY? I am exactly looking for a desktop sync API which upload files and generate reports.Thanks in advance. Bharat Junior Developer Arrowsight Inc.
Calculated date column
Hi, I have 3 columns: - Day (one or two digits) - Month (one or two digits) - Year (four digits) Can I create a calculated date column? Please note that the day and month data varies in number of digits: 1 = Jan 12 = Dec
Include the source name at the top of field list
Dear Support Is it possible include the source name at the top of field list? We've used a lot of Querys and we have difficult to identify the source of the data. Below a sample of Pivot Table, we'd like to know the name of source. Thanks. Paulo Miguel.
Limited number of records displaying on me iframe
Hello Zoho-ers, I have a question which I hope you may be able to shed light on. I have made a database with several records (about 20) however when I load the iframe on my website, I can only see 9 entries. I cannot seem to work out how to make all the records show as they do in the report view. Any suggestions?
Zoho Reports-New feature rolled out in July 19, 2011 update
Cascading User Filters Zoho Reports now allows you to set up cascading user filters i.e., the list of values available in one User Filter depends on the value that you have chosen in the preceding User Filter(s). This feature ensures that you only select valid filter values at any time. It also reduces the time taken to scroll through a long list of filter values to select from. For example, let's say you have one user filter to filter Product Category , and a second filter to filter Products in
Changing user roles + backups
How do I change the role of a user? If I click on "User" I get "No database objects (tables or reports) shared to this user". I need to assign another user as database owner/admin. I also upgraded to the Standard Account which provides Backups. When I go to Backups, it says "No Backup available." Why's that? thanks
Changing admin in reports
Is it possible to change the admin in Reports? I want to assign this to another employee and have the existing admin setup another account. Unfortunately cannot create a new account as long as that email address is already assigned as the admin in the current account.
Special character at droplist (Portuguese Language)
Dear Support, Could you tell me how to handle with special characters in Portuguese Language. Please see below at droplist these character doesn't showed correctelly. Thanks. Paulo Miguel.
Scroll Bar Bug at Chrome Browser
Dear Support, There is a bug when I try scroll bar down, it always return to the top or to the left. I'm using Chome browser. Could you fix it please. Thanks. Paulo Miguel.
Delay to populate User's Filters droplist
Dear Support We need your urgently help. We are experienced a terrible delay when user's filters droplist is clicked. I've already done a Zoho Meeting with support and showed to them the delay. Our users are demanding a urgently fix. They were experienced a very nice performance till last week. We use a lot of user's filters as you can see at sample below. I'm not sure, but we included a procedure to update the database each 3hours. Could it be the problem? If you need contact, please call me
"This Year" and/or "This Year to Last Month" Filter
Hi, I am attempting to create a year to last month report. While I see pre-built relative filters for "This Quarter", "This Month" and "Last Quarter" and "Last Month" etc. I don't see a pre-built filter for either "This Year" or "This Year to Last Month" or a way to create a relative filter to accomplish this. Can anyone provide help? Thanks.
Error when search at Droplist
Dear Support, When I try search inside a droplist the message error is showed. Could you fix it please. Thanks. Paulo Miguel. +55 11 3748-6211
Next Page