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
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
New String Value Column
Hello, I am trying to create a custom formula in Zoho Reports. I have a column with multiple string values with true and false. Column: Isclosed String Value is: "true" "false" I want 2 new columns to display: Open "true" & closed "false". what would the custom formula look like? I have tried many different formula but with no success. Thank You, Arron Robles Blue Pumpkin Hosting | Solutions Made Simple
Sheet More Flexible than Reports (Sheet vs. Reports)
Hi, I had an issue I wanted to test: Issue: Needed project description data listed and displayed. Analysis: Commonly used Sheet to display test data as would an ordinary HTML text-based report. Policies and historical project data are kept within a single workbook. Synopsis: Questioned whether Reports could display data the same as Sheets, essentially creating a DB compared to workbooks. When tested column data was straightforward; basically in Reports, all the data entered in Reports are tokens
Replace a table in views
I had a table that I used to test a bunch of queries and views. I then created a new table with real data. Is there a way to associate the view to the new table (fields are the same) without rebuilding? I can do it for custom queries where the SQL is coded by simply replacing the table, but I did not find a way to do it for views as these use the drag and drop functionality. Any help ? Thanks
Integrate data from Zoho Reports into Zoho CRM?
I have used Zoho Reports for over a year for advanced business analytics. The recent announcement of your integration of Zoho Reports with Zoho CRM makes me want to try Zoho CRM, since we already have Customer details, Sales details in a database in Zoho Reports, is it possible to sync this into Zoho CRM? At the moment the data goes into Zoho Reports via the Zoho Reports Upload Tool, can I connect the different categories of data already in the Zoho Reports database (Customers, Sales, etc) to Zoho
Error 7103 with shared table
Hi, I would like to know how to connect via http to a table which is shared conmigo.Lo attempt and the only thing I get is error 7103 when if any.I have all permission. uri="/api/zohouser@xxxx.com/PRE/RTI_IMPORT" action="EXPORT" code error 7301
Column Headers - Orientation of Text
Could you please advise me whether the column header text can be changed from horizontal to vertical? I have a report with too many columns to fit on one screen, but only because the column header texts are too long (I can't make them any shorter). The data in the columns are numbers, fixed to 2 dec places and with a maximum of 5 characters.
Copy Featured Samples into existing Profile
I'm new to Zoho Reports. I used the mountain bike featured reports Campaign Level, to build my first set of reports. Now there are AdGroup reports also in the Featured Reports. Is there a way to copy these reports into my existing folder set so I can link them to my existing database?
Next Page