Only Partial Import on CSV File
I am experiencing an issue where there is only a partial import on my file. I have over 100 columns but only 19 are being imported. Any ideas why? I would attach my file but ext .csv is not allowed.
Can I change base table on an existing report?
Hi, can I change base table on an existing report? If yes, how? Many thanks!
Column Datatype Lost in querytable
Hello, Can someone from Zoho please doublecheck this? How to reproduce the error I have a Zoho Report table with multiple columns, I will call it "TableX" One of the columns is a "Date" datatype with formatting example "13 Jan 2011 00:00:00" If I create a Zoho Chart and drag this Date column into the filters, I can use it as a range with "from" and "to" (This filter is great because I have over 100 distinct date values and need to select any of them) I now create a new query table with T-SQL
Combine totals from three tables in one report?
I'm not very familiar with Zoho Reports, or relational databases, so I'm hoping someone can help. I have three different tables that contain sales data from three different kinds of products - our main product, services, and accessories. I'm wanting to combine the total profits from each of these tables to create a report of total profits. I've seen that you can connect different tables with lookup columns, but these tables don't have any common columns except the date the transaction took place,
Filtering for Dropdown YES/NO is broken in reports?
Note: I apoligize if this is a PEBKAC problem. =P Hi, I have a creator application that is linked to Zoho Reports using a CSV feed. My problem is that the decision boxes in Creator get converted accross as Yes/No boxes. However, when I actually try to filter something according to this, the filter box is showing TRUE and FALSE (If I filter by either, for any of my decision box columns), which, when clicked, say "No Data" when the report regenerates. A few pictures might explain it better: http://img99.imageshack.us/img99/5053/ss20100108140018.png
level of color saturation
how to have many level of color saturation in a chart. when you try to change the color of a bar at the label settings,at the display you get the type of color in RGB mode, when you click on one color, it changes to type like #FFFCOO.I want to change thetype of color in RGB where i can specify the value of R, G and B. Any tips or ideas
How can I change the column heading names in a pivot table?
Hi, I have created a pivot table and specified that the data values should be averages. Zoho has automatically prefixed each of the data column headings in the pivot table with "Avg". For example, the column in the source table is called "Message Clarity", but in the pivot table it says "Avg Message Clarity". How can I change the column heading names in a pivot table? Thanks Debbie
Number Categories in Mode Filters
Currently, whenever a user will try to input a column that contains a number formatting (i.e. a percent, currency) into the mode filter box, there is an error message that pops-up and says we're working on it. Any status update on this? Thank you!
List types reports readability
Hi... did some one found a way to have a nice readability with list type reports ? I mean like auto blank lines insert between each lines, bigger fields display area ... Marcel
Chart url errors
I published url's of my reports to my website, but after I enter new data and save, we can no longer view them as we get an error. I was under the impression that when you saved info on your database it would automatically update your chart with the new figures. What am I doing wrong?
column aliases should take precedence over columns in underlying table
When I do this query: SELECT IF( landing_niche IS NOT NULL, landing_niche, 'none' ) AS niche, months.month AS month, COUNT( sites.id ) AS sites_count FROM months, sites WHERE sites.inserted_at >= months.month GROUP BY niche, month It groups on the values in the "niche" field in the sites table, instead of the value of the aliased column "niche" in the select query. The alias should have priority over the fields in the table. Or actually, perhaps you just shouldn't be able to group on
Report does not show new data added to the table
Hi, I created a report based on a table and saved it. When I add new data to the table, it does not show up in the report. I also clicked on the "refresh" button when the report is open, and it still shows the same old number of records instead of also showing the new records that were added to the table since the report was designed and saved. What am I doing wrong, and how can I view the new data in the same report? Thanks. Update: Never mind. Please ignore this - figured it out. You may delete
Are these features available?
Hi, I need the following features: 1: To be able to email reports (to, cc, bcc, embedded, as attachments). 2: To be able to schedule reports (I select a report; mark to whom it should be mailed to; set date and time; set if it should be repeated after certain intervals like daily, weekly). 3: Bursting of reports. 4: Dynamic labels (I want yesterdays date, derived from todays date, in the label) Are these features available in zoho reports? And in which plan? I am using the free edition of zoho reporting.
How can I change the number of decimal places displayed in a pivot table?
Hi, I have created a pivot table where the values are averages, calculated from the source data. The values in the source data are all to 1 decimal place, but the averages in my pivot table are showing to 5 decimal places. How can I change it to 1dp instead? Thanks Debbie
SQL Server fields concatenated in Zoho table
Hi! I'm using UploadFromDB.bat to move a table from SQL Server to Zoho. The Zoho table has the same columns as the SQL Server. But the data from two of the columns are concatenated. In all the subsequent columns, the data is shifted one column over to the left, and the last column, of course, is empty. The data in the messed up column has a comma that (I suspect) is supposed to separate the two fields: 11th Annual Meeting of the Society of AAA BBB ,Society of AAA BBB Could some data have a character
Cannot Process Text Parameter to Tabular View Report
I'm setting up a couple of base reports. Then, on my website, I'm displaying the same report using ZOHO_CRITERIA to select relevant data for the specific pages. The syntax for this command doesn't appear to be consistent, and it doesn't always work. Report Type = Chart View, embedded as an image. This is working OK for me using the syntax ZOHO_CRITERIA=(Area='Potomac') where Area is my field and Potomac is the value that I'm filtering. Report Type = Table Report, embedded as an iframe. This works
Additional Graph Options
It would be great to have additional, standard graph options. Especially these two types of common graphs. - Clustered Columns - Combination Line and Column Thanks.
Comparing Dates in Custom Formula
I'm creating a Custom Formula Column in a table that will compare the value of dates and return a value. I'm unable to figure out the proper syntax when working with dates. This seems very simple, but I can't find any reference on this site . I'm trying to get a simple formula to work. Pls advise on the proper syntax for the following statement. Right now, this returns 'False' regardless of the date. if(CloseDate>'October 30, 2010','Current','Past') ... also tried if(Status='Sold',if(CloseDate>'2010/10/30','Current','Past'),null)
Create/Update Query Tables through API
Is it possible or are there any plans to support creating Query Tables through the API? I would like to be able to Version control the queries that I use in my Query Tables (in case they get accidentally deleted, modified, etc.) and so that I can recreate them in different Databases through code.
vicious circle
The validity checks can be nice, but they also get in the way. What happens when I am writing a query and realize that I will actually need another table or query underneath it? I can't save the query I am working on until I create the underlying table or query. Which means I have to leave my work unsaved while I do that. I would prefer to be able to save my query even though I know that it won't work right away. Another situation: I need to change a column name in an underlying query table. I
comments in sql queries?
I am creating some complicated query tables and would like to leave comments. I've tried // and #, but neither work. Please, advise.
Publish URL/Permalink for a view - Selecting "access this view/table without login" and it continues to prompt for login
Steps to Reproduce: 1. Select a query 2. Select "publish" and then "URL/Permalink for this view" 3. Select "to access this view/table without login, click here". 4. Select "Include Data Type Symbol", "Toolbar" and Edit Private Link Permissions (select Read Access and Export Data) 5. Copy URL code 6. When accessing, this URL, it prompts for login. Obviously, the expected outcome is for it NOT to prompt for login. Please note, I have even tried to regenerate random key and that does not help.
Query Table stopped working
I have a query table that has worked fine for several weeks now. All of the sudden I went back in to add one more column and it is telling me this is not supported by Zoho yet. When I hit execute query it works fine. Please help me! Thank You! Jeremiah My query is below SELECT '' as 'Report_Id', 'POL' as 'Record_ID',curdate() as 'Transmission_Date',NAIC_Code, Transaction_Type_Code,policy_number, date("effective_date"),date(expiration_date),'' as 'Policy_Cancellation_Date', '' as 'Filler', Individual_Company_Indicator,
"Invalid column used" when using column aliases SQL
The following query runs and saves fine: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" However, this isn't that useful because it's not ordered. So, if I just do the final step: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" ORDER BY Sales DESC The query executes and displays what I expect. However, if I click "Save", I then see an error message: "Invalid column used". I'm convinced
Safe ticket call
I'm developing a Google Apps application where users can add data to my Zoho Reports database. For this I use the AddRow method from the API. But, to use this method I need a ticket id which needs to be refreshed every 7 days. The Zoho Reports ID and the Zoho Reports Password is required for this action. Is there a safe way to make this call. I think placing the login id and password in my code and run it as an cronjob every 7 days is not a good idea. Can I send an encrypted password or can I increase
Problem when Exporting data through API without a ticket
Hello, I usuccesfully followed instructions to export through API without a ticket given in topic (https://help.zoho.com/portal/en/community/topic/remove-quot;ticket-quot;-from-mandatory-parameters-on-export-api-calls) The result I get is this message: { "response":{ "uri":"[...]", "action":"EXPORT", "error":{ "code":7309, "message":"You need to (re)login to export. Incase you have logged in already,then please refresh the whole page(browser) and try again." } } } Thanks for the help!
Import data from datastore
I have an app engine datastore. Is there any way to bind it to Zoho reports? Greetings
Dynamic Filter?
Is it possible to create a user selectable dynamic picklist filter for the reports? I would like to be able to define the picklist of one field by what is selected in the previous filed like we do with picklists in creator. Please see example below that I would like to be able to implement to the "View Mode Filters" if (count(Serial_Numbers[Description == input.Description]) == 0) { clear Serial_Number; } else { seriallist = Serial_Numbers [Description == input.Description] sort by
MySQL - managing data
Hi. Can you help me, pls?! How can I manage data from Oputils 5.0? I mean access to data over (for example) EMS MySQL Manager? I tried it, but no accept "localhost" / "root" / (no password) .... Thanx! P.V.
Lost Data in entire table in Reports
Hello Please help. For some reason I can no longer see any data in one of my tables in Reports. It is called ALL_AUTO. We use Zoho as a place to store our info and if it is gone it will take weeks to recreate. Please help me if you can! Jeremiah
Pivot Table
Can i use the Report API to modify the column of the pivot table on the fly ? Thanks, Nimesh
Changing column based on combo box
Hello, I am a relative newbie and was wondering if this can be done in Zoho reports. I have two tables, one with two columns listing a unique id and question name and another table which lists each of the question name as a column and some more variables to perform slice and dice. I want the first table to be a drop down so when a user selects a question in the drop down that particular question is shown as a column in the report with the data obviously coming from the second table. Does that make
test ZOHO functions
My enterprise is planning to buy a BI tool to create Dashboards, we are testing several tools to see if their functions match with our requirements. Zoho seems to be a good tool but before buying it I would like to be sure it can do everything I want. The demo gave me some information but I have some questions about ZOHO reports : Can I generate all the following chart types ? Can we modify the minimum and maximum values of the vertical axis Can we remove selected labels on charts ? Does the tool
Editing Design of a Tabular View - Zoho Reports
In the other reports I can find an edit design button but do not see how to do so with a Tabular View. How do you change what table it is pulling data from, or even verify what table or query table the report is pulling from? How do you set something as simple as the setting default sort order -- not the last used sort which you do in the report itself, but the sort order it always uses when opening?
Zoho Reports Help
Hi I want to purchase the Zoho Reports Professional program but am trialing the free version to get the hang of it for the time being. Is there anyway one can insert a map or maps into the reports program and use that as a basis for drilling down into the data. It seems that the ability to use charts is quite limited in Reports, although I may not have the knowledge as yet to use it properly. Please assist me. Dan Murdoch dmrs000@gmail.com
Error with Query Table
In my BUP reporting database I have a table called ALL_GL. In this table I have 3 records with the policy_number of MSL0000012. For some reason these records are the only ones not coming over in my Query table. All of the others are. I have deleted the rows and re imported them and it still isnt working. Can you please look at it and see why. Thanks. The strange thing is that records from the same import are showing fine my query is only a UNION so it shouldnt really be doing anything to prevent
Why won't addition functions work consistently?
I am having a problem with a formula column. This has to be the simplest of formulas. Total Wage = Total Normal + Total Overtime + Total Prevailing Wage Each of the above columns are themselves a formula column with a datatype of Currency. Despite the fact that one or more of these columns has data, Total Wage sometimes has no values. I can't figure out why. I have tried Total Wage = (Total Normal) + (Total Overtime) + (Total Prevailing Wage ) I have also tried: Total Wage = (Normal Hours * Normal
Export to Multiple Views - Expandable Folder Options, rather than Showing All Files.
As I'm creating reports for a client, let me share with you what we're doing. 1. We have one database with several columns of information 2. We have 20 markets that have information inside this database 3. We have to create 20 individual dashboards from the information on this database. 4. Inside our database, we have folders - one for each market. 5. Each folder has about 18 reports (each folder contains the same 18 reports, just filtered differently) So, while we can't export the dashboard
Cell Formula
Instead of just being able to add a formula column, how about being able to add a formula to a cell. I know I can do that in Zoho Sheets but I rather use Zoho Reports instead
Retrieve OBJID for chart
Hello, is it possible to retrieve the OBJID for a chart through the API? I can get a list of charts using ZOHO_ACTION=DATABASEMETADATA&ZOHO_METADATA=ZOHO_CATALOG_INFO but I would really like to be able to dynamically build the URIs for my charts for embedding in a portal without having to manually extract the URI for each chart. It would be most useful if the info returned for catalog metadata included in the OBJID for each item. Thanks, Ade.
Next Page