Show/Hide Column on all Report Types
Show/Hide Column Feature I see is only available on Tabular View, but it would be useful in all reports since the summary and graphic reports are used most, and we can easily click on number to get table and select which columns to hide to get a better view of what we are actually looking for. If this is already built in please point me in the right direction Zoho Support, Thanks
CountIF Aggregated Formula not working
I'm getting the following Alert Message when trying to create a simple countif() aggregate formula..... Datatype mismatch for the given formula. Please choose proper datatype. What is the issue? countif("textfield"='stringvalue') thank you
zoho report
how to give dynamic values in zoho reports
Change label items title
Hello, I didn't figure out how to change the title for a label items. I currently have a numeric value such as "1" or "2" in my table and I would like to have a proper label displayed in the chart. Any pointer how to associate / convert this value to a string?
Top 5 expenses for each month
Hi, I am trying to create a report that shows the top 5 expenses for each month. The underlying data is stored in a table with date, expense description and value. I have done the same report in Excel with the top 5 and attached a screenshot. This is what I expect the report to show for May. I created a pivot table report in Zoho with date formatted as Month-Year, the expense description and the expense total aggregated as a sum. I have also created a filter on the date to show only current financial
Customer's First Order Date (MIN Date)
I would like to find the date a customer first placed an order. Does Zoho have a Min Date function? Or any suggestions? Thank you
Creating User Filers on Dashboard - Not Working
I have created a Dashboard that includes a Query Table....I want to add a User Filter at the top of the Dashboard.....the Filter is on a Invoice Date Field.....that I'm Dragging & Dropping from my Query table.....I'm getting a "Column Not Related" message....The field if from the query table so it is related..... Any suggestions? Thank you
Creating Reports
Hi - I am looking to get some help creating reports for my Recruiting team here in Zoho. I am open to anyone who has some free time who can help me out. Let me know - my email is acharbonneau@k2partnering.com. Thanks, Abby
How to Filter Entire Dashboard
I am delivering a dashboard to a client via permalink and I would like to know how to filter all the reports on the dashboard to be the same via url or some other mechanism. Thanks, Brian
Trying to login using uploadfromdb.bat
I am not able to login using my account. It says 2012/07/05 14:59:07 IST:logging into https://accounts.zoho.com 2012/07/05 14:59:08 IST:java.net.UnknownHostException: accounts.zoho.com at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(Unknown Source) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.<init>(Unknown Source) at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(Unknown
group the multiple columns as others
group the multiple columns as others in pivot view . need help. -snehal
Custom Formula - 2 part question
Genuitywww.genuity.com/Mobile/Pages/home.aspx#SubItemAnchor18-1?utm_source=Weather_FarmersForecast&utm_medium=TextMessaging&utm_content=140CHAR_ProductAnnouncement_VT2PRORIB&utm_campaign=Genuity_Mobilehttp://bit.ly/sdkqVwCustomizeCopy I have two tables where I need to extract everything after the last / in the url but before the CustomizeCopy text. I am not sure how to write this in SQL. The second part is that I will have two tables with this same formula, leaving me with a column in each table
Create a report showing recently changed or added notes?
I am trying to create a report that filters just by notes being created and/or modified during a date range. After I create it, the report will run, but shows no results when there are notes from that time range. What could I be doing wrong? Is there an easier way? I saw how to export Notes, but that pulls them all and then I would have to sort. I just want to be able to see easily and quickly the notes made on any given day by my assistant. Otherwise, I like what I see so far!
Difference from function not working
I've got some data in my Zoho report and I've tried showing data as a difference of a column - but the function does not seem to be working. I double checked and the data is in the correct format (it's a positive number) Any idea why the difference function couldn't be working? Thanks.
Combine several query tables in one new table with sales totals
Hi, I have several query tables, one for each office sales: e.g. 1. New York Timestamp - office - product code - sales amount 29/09/2012 - newy york - ab100 - 100 USD 29/09/2012 - new york - ab200 - 120 USD 28/09/2012 - new york - ab100 - 100 USD 2. Atlanta Timestamp - office - product code - sales amount 29/09/2012 - atlanta - ab100 - 100 USD 29/09/2012 - atlanta - ab200 - 120 USD 28/09/2012 - atlanta - ab100 - 100 USD QUESTION: I need to get a table to sum all sales of all offices on a daily base:
Automatic-recurrent import from a google spreadsheet
Hi, I have a google apps spreadsheet that I use as customer feedback questionnaire. I would like to import any NEW entry in Zoho reports to monitor results (mostly numeric - service quality scores). An automatic import once a day would be enough. Is it possible?
Can't select views from Oracle DB to upload it
Can't select views from Oracle DB to upload it my Oracle DB user name is zoho2012, so the administrator make a view for me. then i want to access those views from: database_sql_queries.xml when i write the normal select statements, its not working moreover the administrator created the view by this CREATE OR REPLACE FORCE VIEW customer(c_code, c_a_name, c_e_name, c_a_code,) AS SELECT
Horizontal Bar Chart
Is it possible to create a Horizontal Bar chart? Vertical Bar charts are great, but sometimes a horizontal bar chart looks much better.
Resolution of pdf export files is too blurry for professional business use
When you present a report to a client, it must look sharp, crisp, and stunning. Zoho Reports produces a blurry something which I would never dare to show to a client without undermining my credibility. Please, do something about this. Thanks Joachim
Connection to multiple SQL databases
Hi, I am having an issue trying to connect to two internal SQL databases with a single database_connection_params.conf file and a single database_sql_queries.xml file. Since the "dbname" field in the query specifies the Zoho Reports database, how do you tell the query which internal database to use? I am wondering if I need to use the $id$ tag to associate query to internal database, but if so I am unsure of the format. I have a workaround which is to replicate the entire ZohoReports folder
Question about updating records using excel files
Hi is it possible to update the data in zoho reports using excel files. Let's say that I have product A's quantity in zoho reports as 5, then I upload an excel file that updates product A's record into 6 based on what is in the excel file. What I want to happen is when I upload an excel file, zoho reports only updates records that are different from its data. Is this easily done?
SQL calculation averages
Hello! I am currently working with a table of data that is collected by date. I have three main columns of data that I'm working with. 1. Quantity 2. Type of product 3. Location I have another table that I'm joining to create a new one that adds a column to translate each date into one of two categories (date type). 1. Promo 2. Nonpromo What I'm interested in accomplishing is an average quantity by product by month by date type. But the average calculation needs to be done by summing up the quantity
Error on Import: Maximum allowed column length is 100
Hi, I am attempting to upload data from an in-house SQL server, but I keep receiving this error on one of the tables. I reviewed this link https://reports.wiki.zoho.com/Upload-Tool.html#ImportParameters and would like assistance. Generating CSV File... CSV file generated... Uploading Query #4 data into Zoho Reports... Uploaded 3721 Error !!! Exception occured while executing queries and uploading data Exception occured while uploading data: Column name 'Quote Date,Won Date,Quote # ,Customer,Description,Category,Sub-Category,Quantity,Unit
Looking for a someone who can create reports?
I don't have the time to create the reports I need for my team - Does anyone have any time to help me through it? Let me know - Thanks Abby
Auth Token Help
I just noticed that my API Key and API ticket are not working, and have seemed to be replaced with Auth Token. Can somone please tell me how to change the below script from API Key to Auth Token string Fetch_Reports(int House, int Crop, string Select_Farm) { if (input.Select_Farm = "Kennett Farm") { farm = "1"; } else if (input.Select_Farm = "Alpine Farm") { farm = "2"; } else if (input.Select_Farm = "West Grove Farm") { farm = "93";
SQL Query - Left Join (not able to save query)
Does Zoho Reports support LEFT JOIN query? SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name I have created a LEFT JOIN query and when I select "execute query" .....the preview results look correct.....however when I go to SAVE the query....I get the following error. Execution of the specified query was aborted, as processing time exceeded the allowed time limit. This is done to avoid any performance impact on the Zoho Reports service.
Upload & Update not working...
I have tried several times to update records within a database tables with no success. Is it possible to update records? Within Zoho Reports I select: 1) Import into Table. 2) How do you want to import? - Add records and replace if already exist 3) Select the column(s) to match existing records: Record ID# Upload using CVS file I'm trying to update roughly 15,000 records And I'm getting a Timed Out error.......every time. Is updating possible? If yes, is there a best method to use? Thanks
Fiscal / financial year - December to November?
Is it possible to change a report to run a different 'year' than is the default Jan>Dec? For example, I have many reports which we view by month, by 'last month', by 'last 12 months'; plus some bar graphs which show month-on-month data, but I'd like these to match the designated financial year, which runs December to November, not January to December. Is it possible to change this in Zoho Reports? Many thanks.
Question about updating records using excel files
Hi is it possible to update the data in zoho reports using excel files. Let's say that I have product A's quantity in zoho reports as 5, then I upload an excel file that updates product A's record into 6 based on what is in the excel file. What I want to happen is when I upload an excel file, zoho reports only updates records that are different from its data. Is this easily done?
sql stored procedure
Is it possible to use/create sql stored procedures in zoho reports? If so how do i accomplish this?
reports
Hello, I am using a professional edition. I try to make a report of monthly sales. I seem to do it wrong, For i can not see a listing of monthly sales, nor a diagram, statistic or what soever. Can anyone help me out?
Vanishing Reports
Recently, after I create reports and save, they do not appear in my list. My permalinks to them still work, but I cannot find them to make edits. I tried deleting some old reports and tables in case it was a space issue, but I still can't find these missing reports or get any new reports to appear in the account after saving. Any ideas?
Embed - Export not working
We are using the embed option and embedding reports into our SharePoint (WSS3) site. When a users clicks the export button the window pops up the says "Your Report(s) has been submitted to Export. This may take few seconds.", but Internet Explorer never prompts to download or open the file. This only seems to happen with IE 9. Any Ideas?
Cost of a free plan?
Why does ZOHO need mi credit card's data for a free plan?
3 tables in 1
Hello, i have 3 tables (C1,C2,C3) with same fields : "ID", "NAME" and i want send all in a big table "Customer". Is it possible ? thanks
Trying to upgrade to Standard Edition Reports - not working
Hi There, Please can you check my Zoho reports subscription. I have entered my credit card details to upgrade to the paid version - in order to get the advanced analytics - I have received the invoice - but when I go to reports - It still says I need to upgrade to a paid version. I have actually done this twice. Will my credit card be billed twice now? Thanks! Zakaria Desai
UploadTool JDBC driver FIREBIRD?
Hi, help configure jdbc driver Firebird for UploadTool??? thank
Upload Tool changes string to integer
I have a field that stores numbers beginning with zero. I need to store it a varchar however the import tool changes it to integer. How do I fix this?
Bar charp option not available
I have a simple table for which I want to make a bar chart however the only option available in scatter plot. Could this be because my Y-axis is a text field? If so, how do I change that?
Aggregate YTD and QTD for financial reporting
Hi, Currently, the aggregate YTD and QTD (great features) use calendar period i.e. Jan to Dec for producing the YTD and QTD aggregates. I read in a another forum entry that the start of the period, for example for financial period in NZ is from April to March, can be set behind the scenes for the database. However, is it possible to have both YTD and QTD for calendar reporting and financial reporting within the same database? Thanks Sunil
Next Page