How can I show 12 hour format time in Zoho Reports
I use a lot of graphs that show time. I would like to have these times display in a 12 hour AM/PM format. How can I make this work?
Add a Calculated field in a Query Table
Hi I have a query table with two columns: - "Sales Euro" - "Exchange rate" I would like to add a calculated column in the SAME query table: - Sales in Dollars (resulting from the calculation of "Sales Euro" * "Echange rate" Thanks!!!
How to calculate a column based on data from multiple tables
I have a table with all transactions: table#1: id, date, customer, value, currency I have another table that contains the exchange rates table#2: month, year, currency, exchange_rate I want to add a new custom formula column to table#1 which basically calculates as follows: CALCULATE - table#1.value x table#2.exchange_rate WHERE - MONTH(table#1.date).'/'.YEAR(table#1.date) = table#2.month.'/'.table#2.year - table#1.currency = table#2.currency Can this be done with Zoho Reports and if so, where do
SQL connectivity?
Hi A small non-profit org I'm the web admin for is looking to open a Zoho account to host its membership database. I'd like to ask a couple of Qs: 1. Can I send SQL statements directly to the database on Zoho? 2. If not, can I send an API call to get, say, record details? 3. Is this facility open to all Zoho users, or only paying customers? I did look through the API docs but they're massive and look to be exclusively focussed on bringing an Office-style interface to the client, though I've probably
UploadFromDB.bat won't execute
Zoho UploadTool - Done with the configuration and all but when I click UploadFromDB.bat, nothing happens. The C:Windowssystem32cmd.exe will just pop for a second nothing when it is suppose to give you information that the query yo specify is being loaded. The query i have on database_sql_queries is this: <?xml version="1.0" encoding="UTF-8" ?> <!-- $Id$ --> <Queries> <Query dbname="Test Datebase" tablename="Test" importtype="APPEND" matchingcols="" selectcols="" skiptop="">
Creator and Reports
It seems bizarre to have to ask this, but how does one use Zoho Reports to create reports from Creator databases? I can't find a way.
Error when trying to use sql server to import data? Any help would be appreciated.
Logging in... Logged in successfully... Executing query #1 Generating CSV File... CSV file generated... Uploading Query #1 data into Zoho Reports... Mar 18, 2011 10:07:17 PM org.apache.commons.httpclient.HttpMethodBase getRespons eBody WARNING: Going to buffer response body of large or unknown size. Using getRespon seBodyAsStream instead is recommended. Error !!! Exception occured while executing queries and uploading data Exception occured while uploading data: Kindly check the logs for more details!
Totals in Reports
Anyway to have the reports do summaries .. as an example .. if someone enters TOW SERVICE TYPE OF CAR TOWED PROBLEM WITH CAR DATE / TIME Can I build a report that does a monthly and yearly summery of How many tows were made Home may types of cars How many of each problem existed.. I basically want the report to tabulate the monthly totals any way to do that??? thanks
Share vs Publish
Hi all, I want to allow my clients to view their data without a zoho reports login. What settings should I pick and what security threats might this entail? Thanks, Mat
Zoho Reports API Questions
* Is it possible to update data? ie: If the row I want to update has a value of 10 and I want to add X to it can I do that? https://zohoreportsapi.wiki.zoho.com/Updating-Data.html * Data Sent as POST parameters. In the samples the samples are written like this with the comment data sent as POST parameters. Because my webforms already post to a webpage, I was hoping to use ajax to post data to zoho and pass the data via the querystring. Can I do this? http://reportsapi.zoho.com/api/demouser/EmployeeDB/EmployeeDetails?ZOHO_ACTION=UPDATE
Printing from static URL chops off the rest of the page
The Dashboard reports feature is an amazing application to a project I am working on right now (thanks to the team for providing this great resource!). However, I'm having trouble getting a good print copy from the Dashboard URL. If there would be a way to add a print toolbar to the Dashboards, I would get a great way to customize reports and then create goals reports for my students. See the attached Print Preview screenshot (from IE) for an example of what I get when I print from IE or Chrome.
SQL Query JOIN on Date help?
I have two date columns that I need to sync. I parsed the time of the other so I can isolate the date. What is the best method of joining these columns. They are formated 1/2/2010 and 1/02/2010 Will that be a problem? Thanks
Android APP DB
Is it possible to use CloudSQL to pass data from ZOHO Reports to an android application?
Changing the CSS of the Title Field
I would like to be able to alter some of the CSS that lies behind the Charts that are generated, to make the title fit the site styling of the pages I am embedding it into. But I cannot see how to make changes to it .. is this feature available or coming soon ?
SQL capability
Were looking for someone that has taking the approach that the core applications from zoho serve as the foundation for enterprise development? also how powerful is teh sql and api piece in achieving this? __________________________________________________ ACURA shocks and struts ACURA quick strut MAZDA shocks and struts
CRM - Reports
Can I import all info from Zoho CRM to reports?
Ability to Filter by Search
A feature that would be very helpful to me is the ability to select any column containing text, and give the ability for a view mode filter, to search through for any specific text. The chart/graph would then update to contain only those records that contain any part of the text, search results. For example: Column 1 contains the text: A big red apple chair If I put into the search box: big, or apple, or chair or any words contained in the column, it would bring up the column 1 record text. Please
Lookup Column Has no Data (Blank)
I have a rather large table that when adding a lookup column the column is then blank. Is there any reason why? I have attached a screenshot of the blank column. Any help would be great. Thanks!
Linking Reports to Invoices
Can I link two different ZOHO applications? I have a table with sales data in Zoho reports. I would like to link this data to Zoho Invoices to automatically generate invoices based on daily/weekly sales for each customer.
Upload tool - MySQL 'NULL' date handling
Hi, I hope that this may be useful to someone else as it gave me a right headache! We use the Reports upload tool to push data from a central MySQL database behind a firewall. Several of our columns have a date type, and an acceptable value in this column is 'NULL'. When we upload these manually as a spreadsheet this works fine. When we automate this with the upload tool we always get the error: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date It appears that this
How to make an accumulated sum?
Hi, can anyone help me on this? I need to make report with a column with a running balance for the data: DATE NAME AMOUNT RUNNING BALANCE (accumulated sum) 01/01/10 alksdjfañlskf $30.00 $30.00 02/01/10 aioijñlkjas $20.00 $50.00 05/02/10 oiqureasd -$5.00 $45.00 Actually I need to know if its possible to be done in the reports area and in the creator area. Thanks.
Forum error
As soon I hit the "Create New Report" button on the reports section an error occurs with the next message: Sorry for inconvenience. Please try after some time or report your issue in the feedback form given below. Any one an idea how long this error will take? Thanx! Menno
Zoho Reports: imported table with "formula" field
I set up an imported table in Zoho Reports, with periodical fetching of data. I tried to define a "formula" field but was not able to. Is this disabled? How can I achieve calculations in a report other than sum-ups? I wanted to subtract the sum of one column from the sum of another column.... thanks.
Only Partial Import on CSV File
I am experiencing an issue where there is only a partial import on my file. I have over 100 columns but only 19 are being imported. Any ideas why? I would attach my file but ext .csv is not allowed.
Can I change base table on an existing report?
Hi, can I change base table on an existing report? If yes, how? Many thanks!
Column Datatype Lost in querytable
Hello, Can someone from Zoho please doublecheck this? How to reproduce the error I have a Zoho Report table with multiple columns, I will call it "TableX" One of the columns is a "Date" datatype with formatting example "13 Jan 2011 00:00:00" If I create a Zoho Chart and drag this Date column into the filters, I can use it as a range with "from" and "to" (This filter is great because I have over 100 distinct date values and need to select any of them) I now create a new query table with T-SQL
Combine totals from three tables in one report?
I'm not very familiar with Zoho Reports, or relational databases, so I'm hoping someone can help. I have three different tables that contain sales data from three different kinds of products - our main product, services, and accessories. I'm wanting to combine the total profits from each of these tables to create a report of total profits. I've seen that you can connect different tables with lookup columns, but these tables don't have any common columns except the date the transaction took place,
Filtering for Dropdown YES/NO is broken in reports?
Note: I apoligize if this is a PEBKAC problem. =P Hi, I have a creator application that is linked to Zoho Reports using a CSV feed. My problem is that the decision boxes in Creator get converted accross as Yes/No boxes. However, when I actually try to filter something according to this, the filter box is showing TRUE and FALSE (If I filter by either, for any of my decision box columns), which, when clicked, say "No Data" when the report regenerates. A few pictures might explain it better: http://img99.imageshack.us/img99/5053/ss20100108140018.png
level of color saturation
how to have many level of color saturation in a chart. when you try to change the color of a bar at the label settings,at the display you get the type of color in RGB mode, when you click on one color, it changes to type like #FFFCOO.I want to change thetype of color in RGB where i can specify the value of R, G and B. Any tips or ideas
How can I change the column heading names in a pivot table?
Hi, I have created a pivot table and specified that the data values should be averages. Zoho has automatically prefixed each of the data column headings in the pivot table with "Avg". For example, the column in the source table is called "Message Clarity", but in the pivot table it says "Avg Message Clarity". How can I change the column heading names in a pivot table? Thanks Debbie
Number Categories in Mode Filters
Currently, whenever a user will try to input a column that contains a number formatting (i.e. a percent, currency) into the mode filter box, there is an error message that pops-up and says we're working on it. Any status update on this? Thank you!
List types reports readability
Hi... did some one found a way to have a nice readability with list type reports ? I mean like auto blank lines insert between each lines, bigger fields display area ... Marcel
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.
Next Page