How do I "paste" a hyperlink into a cell...
Question: I need to paste a hyperlink to a PDF document (example: http://www.adc.com/pdf/1234567 ) into a specific cell in a column whose data type is set at "URL". Note: I can enter the link manually into the cell so I know the link works... however due to the length of the link this is impractical. Any assistance would be greatly appreciated. Thank you. Michael
Problem at Report UI (beta 3)
Dear Support, I was trying the new beta version at Zoho Report, so I'd noticed that the Title and Tool Bar in Pivot Table View and Graphics was missing. I returned to old version and the Title and ToolBar was fixed now. So I'd related this issue to version beta. Thanks. Paulo Miguel.
Commas in Column Titles
Hello, I am importing a spreadsheet from my website composed of 6 rows and around 36 columns. The data successfully loads for most columns but fails on two where the column title contains a comma. How do I work around this? Thanks, Steve
Determine column order of underlying data
I use the private link feature to throw our Zoho reports around the firm, and via "Edit Private Link Permissions" it is easy enough to choose what columns to show. But how can I determine in what order that same columns are shown?
Automatic Save in Zoho Reports
How do you change the Automatic save time in Zoho Reports? Deanna
Subtotal in each page
Hi, I have a table where I need to add subtotals for that page and so on. How to do this please? Thanks
How do you change 100 text within a column - Zoho Reports
Hi, How do you change only having 100 text within a column in Zoho Reports? I would like to have this changed to 250 text, for certain columns in my reports - can this be done and if so How? Deanna
Lock Columns in Zoho Reports - so no editing
Hi Zoho, I can't find anywhere if you can lock columns in zoho reports so you or anyone else can not edit certain colums. I understand the no edit feature from a user adding, however what if I want the user to have access to the zoho report spreadsheet, but don't want them to edit certain columns? Deanna Mannix
Upload tool is failing to add new tables
Upload tool is failing to add new tables It is reporting a success, but the tables do not show in Zoho. If I try to manually add a table with the same name, it says that the table already exists. Obviously it uploaded and there is a disconnect in works. Please advise.
Structure of customers
Please, How to create report with structure of customers (in rows i.e. top 5%, top 20 %, top 50% of customers based on revenue)?In data area I need to have number of customers. I have only transactional log. Can I prepare it? Thank you very much
consultation with cursors
Hi! I need to do the following in ZOHO reports using cursors. declare @SemanaActual money; declare @SemanaAnterior money; declare @SaldoFinal money; declare @SaldoInicial money; DECLARE vendor_cursor CURSOR FOR select distinct A.Semana,A.SemanaAnterior FROM AdventureWorks.dbo.OperacionesJuan A OPEN vendor_cursor FETCH NEXT FROM vendor_cursor INTO @SemanaActual,@SemanaAnterior WHILE @@FETCH_STATUS = 0 BEGIN if (@SemanaActual=1409)--semana inicial begin select @SaldoFinal=coalesce((select
Filtering Y Axis Items
I have a need to have the same table column in the Y axis more than once. I want to be able to apply a filter to only one of the instances of that column being shown. Can I specify which instance of the Y axis column is filtered? For example I want to display 2 counts of the same item, let’s call them car sales count. However, I want one column to show me total car sales count and the other where car sales were more than 5,000 dollars. Is that possible?
Will the ability to add trendlines to graphs be added?
We are very happy with all the different graphs settings which are possible with ZOHO reports, but the one thing we miss a lot is the ability too add trendlines to data. Is there a work-around to add trendlines or are you planning to add this ability?
Error message exporting to Excel
Hi, When trying to export the underlying data from a graph in .xlsx format the resulting spreadsheet cannot be opened by Excel 2010. We get the error message invalid file exstension. When exporting the same underlying data to .xls format the resulting spreadsheet can be opened with Excel 2010 but shows the error message shown beneath: <div style='display:none'> STATUS_MESSAGE_START Sorry, you cannot export this data into Excel, as it contains more than one million cell values. STATUS_MESSAGE_END
how to make scheduled email as html email with report inside?
hi right now scheduled email sends reports as attaches (pdf, html) how can i tune email so that i can see report inside email body? do not need open attached pdf or html file just html formatted email with report (tables, charts) inside
Import from Creator creates duplicates
I have a feed scheduled to import from Creator. Each time the schedule runs, a duplicate set of data is created in the Reports table. How can I get Reports to recognise if imported data is the same as existing data and update rows rather than creating new ones - ideally using the Zoho Creator ID as a unique key. Thanks.
Zoho Reports - New features rolled out on June 24, 2014
Enhancements in Advanced Analytics Add-on for Zoho Projects Advanced Analytics Add-on for Zoho Projects now provides the following new options. Import New Projects Automatically - Selecting this option will add data from any new projects that you create in Zoho Projects automatically into Zoho Reports reporting database without any manual intervention. With this you need not edit the synchronization setup each time you add new projects to sync them for reporting purpose. Retain Archived Projects
Comma in Column Heading
Hello, I am importing from an xlsx spreadsheet file from a website. 34 out of 36 columns replenish data correctly, but 2 fail, it seems because the column header contains a comma? The imported column headers seem to be ok when I view them in Zoho, complete with commas, but the incoming refreshed data doesnt seem to match with the header correctly? Thanks, Steve
Aggregate Formulas with 2 fields
(countif("STATUS"='SALE'))+sum("CALLS") Trying to add the total of the CALL fields only if the Status field equals SALE. Both of these formulas work fine when create them separate but when I combine them they do not work. Does anyone have any suggestions on how to make this work? Thanks
SQL Table Report
I am trying to add custom pick list to the SQL in the analytic sql table report, its not allowing me to do it. Any help would be appreciated.
SQL Server Connection fails
Despite specifying the details in the database_connections_params.conf file, my login fails. What could be the reason. I am referencing the HOSTNAME by name, not by its IP address. Do you think that could make a difference? I would like to resolve the issue as quickly as possible. Please help.
Export Report - PDF - Graphic Distortion
Hi Zoho, When I try and export a report to A4 PDF, Layout as in Dashboard (see attachments 'export 1.jpg' and 'export 2.jpg'), the end result appears distorted (see 'distorted zoho report.jpg'). Please advise as to whether the dimensions of the Exporting tool can be adjusted to repair this. Thanks,
Integration of zoho campaigns?
Is it possible to integrate also zoho.campaigns in zoho.reports? How can I integrate these applications? Many Thanks in advance and best regards Björn
Importing from a "New" Google Spreadsheet creates duplicate records
We have several Google spreadsheets that are automatically imported into our Zoho Reports tables. We use the criteria "Add records and replace if already exists". We always use the record ID as the unique identifier. Since setting up some imports from the "New" Google Spreadsheets, duplicate records are created in our Zoho Reports tables on subsequent import runs, but the duplicates have blank record ID's (the field we're using as the unique identifier) Attached are screenshots of the: Duplicates
Bar Chart Set Up
Hello, Can someone please help me to design a type of chart that I'd like to use frequently? On the x-axis, a list of a few columns, each of which contains data in the form of 1 or 0, and the y-axis to display the percentage of that column that is equal to 1 out of the total number of entries in that column. Can someone help with this? Thanks, Susie
Creating report using Multiple Modules
Greetings all! I am trying to create a report, that combines 3 different primary modules. I need to be able to gather details from the New Task, New Event, and New Call areas. All are listed under Activities, but do not show up as related modules when I select any of them as the primary module. Is there any way to pick multiple primary modules so I can access all the fields needed for my reports? Please let me know if you need any additional information from me to help make my question more understandable.
Filter a Panel
I create a panel called Cero, which I share with you, with all the sales info. But now I would like to duplicate this panel for each month. For example, a panel for May's sales other for June's sales, etc. Is there a way to filter in a panel all the tables a graphs by date. Im not referring to users filters because I dont want that the users see the info from other months when he is on a specific month. Thanks for your help.
UploadTool The content of the element must contsist of well-forme character data or markup
Hi i'm having this error when work with some queries from MS SQL Server. Apparently the problems is regarding with the comparison operator (<> not equal to & <= less than), please i need assistance with this. By the way i attached the database_sql_query.xml and logs. Best regards, RR [Fatal Error] database_sql_queries.xml:138:647: The content of elements must consist of well-formed character data or markup. Error !!! Exception occured while parsing the import options XML. The content of elements
How to create a chart that show Facebook fans over time
I believe this is an easy one but I am having an issue creating a report. I have a table that contains the export from Facebook that depicts insights over time. I am trying to create a chart that shows the increase of fans over time. The export I have from Facebook shows the Life Time Total Likes per day. I want to show the total likes at the end of each month, right now when I create a chart and select the x-axis to be month/year and the y-axis to be lifetime total likes it shows a bunch of point
Adding users/owners
I have 3 database owners and am trying to add a 4th I get a box come up saying: Sorry, you cannot share to a new user. Your plan limit allows you to have only 5 users. Kindly Upgrade your plan to share to more users. please rectify urgently
Set the same format for many columns
Hi support, I want to set all the 40 columns with decimal value with the same format (decimal place). How can I do it at the same time, not by adjust 40 columns one by one? Please help. Thanks
Exporting and Sharing Dashboards
I am the admin for our application and have created many reports and dashboards. All of my users can export these files if they desire. However, if any user creates a dashboard, they do not have an option to export. In terms of sharing, they can only share to the whole database group. If they just build their own report though, these problems do not exist as they can share at the individual level and can export. Why is there a difference for the dashboards?
Zoho Reports - New features rolled out on June 6, 2014
Support to Publish with Filter Criteria Zoho Reports now supports Filter Criteria option while publishing the views. With this feature, you can apply a filter criteria to display the filtered data in your embedded view or published Permalink as needed. Support to Share Folder Now Zoho Reports provides an option to share the views in a folder. This will reduce the tedious work of selecting the views from the entire views list available in that database, when you share them.
Rows will not delete from tables
Is anyone else having trouble deleting rows from tables?
Create a Query Table
I have shared the table "Radicación de Facturas with you". What I need to get from this table is a query where the cost (Column "Valor") of each service( Column "Servicio") is totalized per invoice ( Column "Nro Factura") Thanks
How to utilize an existing matrix data set with Zoho Reports
Hello My company's budget is currently captured in an excel spreadsheet relating estimated or budgeted expenditures by various categories (column) across future dates (ie many columns). I would like to use Zoho to report on this data set summing and analyzing by not only the categories but also by date. As the data is already in a matrix and not database format ie one row per datapoint, how can I modify or use the Report tool to accomplish my reporting needs? Thanks for any advice you can provide
Can I upload many CSV files at the same time?
Hi, I need to upload about 10 csv files to Zoho report. Can I upload all of them at the same time? I have tried and find that I can do that but I need your confirmation that there is no harm to upload many files at the same time Thanks
Zoho Reports - New features rolled out on Aug. 8, 2013
We are happy to announce that support for Activities module in Advanced Analytics Add-on for Zoho CRM, one of the most required features, is now available in the service. With this you will be able to create reports over Events, Tasks and Calls data in Zoho CRM, for better analysis & reporting. For Activities module we have added 20+ insightful reports & dashboards for your convenience. This module will be synchronized for new users setting up the Advanced Analytics Add-on. Existing users can synchronize
Problem with google drive document update
Hi Congrats for this great tool ! Once my problem will be solved, I will be so happy to work with it ! I have created a table fetched from a .csv file stored in googe drive. This is OK When I update the document in G Drive and I ask zoho report to refetch the document (Import/refetch...) It fetches the old version of the csv file ! I have tried to delete the csv file in g drive and zoho report still manages to fetch it... Is there any known glitch the could cause this ? Thank you !
Dynamic URL's for feeds
Is there a way i can provide a dynamic url? For example, my data feed requires a from date: www.example.com/jsonfeed?fromdate=25.05.2014 How do i make Zoho provide todays date?
Next Page