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
Zoho Reports SLOW
Zoho reports has been slow for me for the past day and finally it stopped working today and I got the following error message when trying to add rows from creator Error details:Error occured while on Success script.Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page. Please look into this problem I can't
Scheduled Email in Reports
I have read that this is possible, but i cant seem to figure it out. I want to send a weekly CSV of my data in reports to someone via email. How do i set this type of schedule up? Thank you
New Customers in Reports
Hello, My company is trying to create a report that show how many new customers we have gotten per month. In Zoho CRM, we have converted the contacts module to show our customers. We have a checkbox that differentiates between active and inactive customers, and we want to create a report that shows when a customer switches from inactive to active. The problem is I don't know how to get Zoho Reports to show when a change is registered in a field, specifically the active / inactive checkbox. I want
How to format date when Uploading Data from in-house Databases?
Hi... I wonder how to format as a date specific data type when i upload data from in-house DB? whereby the db field itself is a varchar like "2012-12-31". I realized that it can be done using csv by specifying ZOHO_DATE_FORMAT but how to do it from in-house DB query? Thanks in advance
Print Multiple Pivots on single PDF
I want to be able to break my sales data down into sections by customer and month, with those sections i want to add all the sales details (units sold total net, cost/unit/ sales value gp % price/lb ect) Then i want to print it all on one sheet. i want it to break out like the "Group" function in Zoho Creator list view
Force axis range
I am reporting on some AdWords campaigns. One particular campaign only ran for a few months per year. My date range is 2010 - 2012. For the report on that campaign, the x-axis truncates to only three months. I want it to show all months in the range to make the report conform with the others and convey the window as only being a portion of the time covered. However, I cannot figure out how to force the date range on the axis. The report filter is set to all the months in the range. I imagine
Query table timing out when trying to save
I have a query table that pulls from 2 tables with 200k+ rows. When I try and save it it gives me 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. Some tips to avoid this: Verify whether you have unnecessary table joins in the query Or could you simplify it further Verify whether you have redundant "Order By" clause or any "Order By" over a general plain
Big querry
Hi, Can zoho reports handle big query like google big query? I want to send sql query which will fetch may be some 1000 rows of data from table/s with a few 100 million rows.. I do not want to import the full table as that would be 30-40 GB... Can zoho reports handle such scenarios? regards sg
Percentage change in Y axis of chart
What is the way to make a chart graph the percentage change from some initial value? Think of a chart that shows the percentage gain or loss in NAV of a stock account, relative to some benchmark. The user of the chart could change the period they are interested in seeing based on their preference, but the chart would always graph correctly. Thanks Harry
Maximum number of row exceeded
Zoho is telling me that I have exceeded my maximum number of rows (100,000) even though I have fewer than 20,000 rows total in two tables. Does anyone have any idea why that might be the case? Thanks
Next Page