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
zoho reports with openbravo
How can we make zoho reports as pdf file in openbravo and forward it to users?
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
HTTP 400 Error when using API
Hi, I'm trying to upload data through the API calls, about 80% of the time this works but the other 20% of calls return HTTP 400 errors. If the program waits 10 seconds and retries the identical data, it works. Unfortunately this makes importing data extremely slow. Is there a limit to how many calls can be executed and what is the maximum upload size? I have noticed the chance of it occurring is bigger if you upload more lines at once, but it can also give you an error when uploading as few as 10.
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
Custom formula throws error when changing value in lookup column
Hi, I have a table called ExpenseFact which has one Lookup Type column called "AccountType", one custom column called "cGST" that removes 15% of an existing field called "Total", and another custom column that is derived from "cGST" field and is called "cTotalLessGST" which is simply "Total" - "cGST" field. When I created the two custom formulas the values were refreshed correctly with no issues. However, if I update the value in the Lookup Type column called "AccountType", the following errors occur:
Upload MySql TinyInt with Nulls becomes Zoho Reports "Text" DataType ??
Hi, Using the UploadFromDB tool, TinyInt columns (containing Nulls) in my MySql DB become TEXT datatype in Zoho Reports table (on first upload with auto-create Zoho Table). This text datatype makes graphing axis data type incorrect (text instead of number). Would it be possible to make MySql TinyInt (containing Nulls) = Zoho Reports Table NUMBER Datatype? Is there a work around? Thanks, Jason.
publish -> url for this view
Hey, Is it possible to integrate the "filter" in the "publish -> url for this view" ? I want to publish url's so the viewer sees already the ask information. Example: I create a database of sportsresults with there information in Belgium. I use the filter on sportsclub town (or town and date ect) and want to save this in the url. Integrating this link on a site the viewer must do notthing when he follows the link, and see only the results of that town. Help would be helpfull. Thanks
Can a shared user have publish rights?
I would like certain users to be able to publish specific reports to a public blog without having to ask the database owner for the embed code. Is this possible?
Convert String to Date
I need to be able to take my string and convert it to date, however I am no SQL master. I am getting nothing returned because the time is being captured in the date field, What I want is only the date (MM/DD/YYY) to be captured in both "Pick_Date" and "InvoiceDate" Columns. Current its capturing (MM/DD/YYY/HH/MM/SS) The query I have written is below Select InvoiceDate, Grade, GradeName, sum(GradeNW)/sum(ProductionNW) * 100 as "percentage" from prod_sum_nw, grade_sum_nw Where InvoiceDate = Pick_Date
Next Page