Zoho Report Simple Scenario
Inserting a table for a test ID | Title | Portal | Enquiry Received | Enquiry Responded I want a simple report to see information about the enquiry response time - i.e. Enquiry Responded - Enquiry Received. Output maybe: Average response time: X minutes And then perhaps per day Monday: 18 minutes Tuesday 22 minutes etcc Cant see this can be done?
Export Default to Visible Columns Only?
I have a query table that aggregates data from several different table. I wish to create multiple reports from this table with different fields visible for different reports. I want to hide different columns in the various reports and then want to be able to export them as PDF's, but I don't want to have to re-check which columns I want to export each time I run the report. Is there a way to accomplish this? I should say that the base query table is already 3 layers deep, so I can't create new
Uploadtool script does not stop
I am testing the UploadFromDB.sh from a MySQL database, but I cannot get it running. I have: installed the tool configured database access added jdbc file Is there some FreeBSD problem? I had to replace the JRE since the one you have bundled does not support FreeBSD, and suspecting that that might the problem but not sure. When I run the tool sh UploadFromDB.db username password it just runs for ages but nothing happens (and there is only one small query in the xml file for testing. I cannot see
Portuguese Characters
I have in my database portuguese characters like ç and á, and I can't see them. What can I do to fix this problem?
Joining to a shared DB
Is there a way in Reports or Creator to Join to a shared Table? Thanks PJ
Embed zoho reports in Netvibes
So I have been trying for over an hour now just to get a simple zoho report to a Netvibes gadget and it doesn't work. I have tried: - image share using an image widget - iframe include using iframe widget Nothing works. When I type the url directly in my browser I can see the image, but I can't include it in a Netvibes widget. This is so frustrating... Internet Explorer pops a message "has prevented cross-side scripting"... I just want my chart in a widget on Netvibes, how can this be
Difference of two numbers in same column. Place Dif. in Column next to First Number.
I am not the best in Sql functions. I just can't get this figured out. I am trying to find how to get the difference of two numbers in the same Col. and place it in the column next to first number. For example: take 3225 - 3222 then Put 3 in SubT Row 1 Then Next row ..3222 - 3219 place 3 in Subtotal Row 2 etc The dif is not always 3, I just inserted these numbers. I would appreciate any help. PJ
iGoogle Gadget full width?
Is it possible to get the Zoho Reports iGoogle gadget to go full width instead of a little box, where my charts do not fit? Also when I try to resize it clicking the maximize icon on top right the chart is still small and not stretched. Makes it pretty useless right now. Hope there is a better solution to this.
Two tables with one chart, does not work
So I am trying to create a very simple sales, cost chart with two lines. I have one table for sales and it looks like this: I have one table for costs that look like this: Notice how the "Total costs" are calculated using a formula column. Both tables are joined using lookup column for the column "Project". When I try to add this into a chart I get two dots like this: But it should be two lines on a timestamp. How to fix?
export all users permisions
Hi, i want with some way to export all users permisions. I have a file server. This file server has many many folders and subfolders. To each folder some groups or accounts have access. I need an export that says for example that in the folder "work" access has the folowing: "team1,team2, mmayers" is any way to have this export??? Please help me! Thank you in advanced
Creator and Zoho Reports
Can I use Zoho Reports to call and manipulate data from my applications in Creator? If so -- how? If not, is the Report Writer in Creator based on the same system?
Having problem in uploading CSV files using CSVUploadConsole.sh file
Um trying to upload my csv file to Zoho Reports. while executing the command using putty, its giving me the error Following is the command I executed: [path_of_directory]/CSVUploadConsole.sh [path_of_my_csv]/tb_booking_param.csv [db_name] [table_name] TRUNCATEADD [uname] [password] after executing this command, it gives me the following error: [path_of_directory]/zoho/tool/bin/CSVUploadConsole.sh: line 15: 24386 Segmentation fault $JAVABIN $JAVA_OP TS com.adventnet.zoho.client.report.tool.CSVUploader
Shared Users Import data
Hi I have a db which I have shared to another Zoho user. I want him to be able to add data to one of the tables using 'Import' I have given him read/write priveleges for that table. However when he open the table the Import button is greyed out and cannot be executed. Is there a way of enabling him to import data into this table under his log in? Thanks.
How to manage Invoicing
I have a an orders file that is generated through an online payment gateway. I take this file and import into Zoho Reports. I want to be able to handle post-paid invoices (so import everything as before including all the invoice paid dates and then start marking the invoice paid dates in Zoho Reports) My problem is that Payment Dates are managed in a separate spreadsheet - therefore, I have spent a few hours correlating payments to invoices and have a base to start with... Moving forwards, I want
Pivot Report Variable Parameter Enquiry
Hi, I wonder if you can help with this problem I have. I have a Pivot Report (Pivot1) that pulls in data from a query table (QueryTable1). Within the query table I have sales transaction information. Also within here I have two fields that are an evaluation of the week the app was submitted (AppWeek) and also the current week (ThisWeek). AppWeek can be from 1 to 52. ThisWeek will only ever be one figure corresponding to the ThisWeek , ie 48. I am trying to put a week user filter into (Pivot1) , I
Reports
Hi, Is it possible for customers to view reports?
New Calculated field with complex IF function
Hi, I have a table with two columns: - "Sales ID" - "Sales amount" When a sale is done I get a new record When a sale is refunded I get an additional record with the same "Sales ID" but a negative "Sales amount" I need to: Add a new calculated column in the SAME table. The calculation should add the text 'cancelled sale' in both transactions (based on "Sales ID" match) when a sale is cancelled (negative value) An example: Current Table Sales ID Sales amount 123 18.2 124
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.
Next Page