User Hourly Rates - Template
I am trying to get my users hourly rates added to the User Hourly Rate - Template. The template is not pulling any information regarding the user and/or projects from Zoho Projects so that I can manually enter the users rates, or set it as a default. Please advise as to how I accomplish this. Thank you~
Comparison with prior year in widget
I would like to create a widget that shows how much we sold "by this point" last year, and I'd like it to update automatically. I can't figure out a relative setting that would allow me to do that. Anyone solve this problem?
Using Order ID as unique identifier
HI, I have an Excel sheet, where I have the line items of orders from our web site. The unique identifier for each record is the Order ID. Each line item for an order has this number in the first fields of that line in Excel. When I import into Zoho Reports it is not treating this ID as the identifier, so when I try to use it - it is treating it as a number so I am not able to run the reports I need. Can you let me know if I am doing something wrong? Thanks Dave (for Geoffrey)
Error code from UploadTool
Looking to use VisualCron to run the UploadTool on a schedule. Does the UploadTool return any success / error codes with regards to failure of uploads? We need to send an email to relevant users if an error / abort happens.
Detect the chart which is broken
Hi, Is there any way that I can quickly see which charts are broken ( no data in view) ? I have hundreds of charts which are published as public and embedded into my website since my data is changing rapidly so I guess some of my charts are broken periodically and I need to remove them from website . So I have to detect those broken chart from Zoho reports. How can I detect those broken Charts ? Thanks Arfater
Setting up Periodic Upload / Synchronization - Task Schedule in Windows Server
Hi to all, I had an issue that i just solve. And i think writing this solution will be usefull to other users. I want to schedule a task in windows server for uploading data from Relational Database To Zoho Reports. I set up the setting in /conf/common_params.conf and /conf/database_connection_params.conf And when i schedule a task for starting /bin/UploadFromDB.dat file with the instructions on https://reports.wiki.zoho.com/Uploading-Data-from-Relational-Databases.html#Setting%20up%20Periodic%20Upload
service desk custom field not showing
Hi, I use Zoho Reports with Servicedesk, automatically exporting every two hours de database to the cloud. I added a few custom fields for requests, my problem is that they are not appearing in Zoho Reports, when I try to apply a filter only the default fields show up. How can I fix it? Thanks,
How to create a link to export one-click query or report to excel
My customers uncomfortable when to export the report or query dashboards need to do some additional steps. How do I set up a link in one click? It would be nice to be exported to use filters on dashboards and without filters.
Add "use filter" in the table query
For all reports is a function, and for queries only filter for each column. The users are not comfortable using it.
Stage History Detail
I am trying to create a report that fetches all the potentials which had a change in Stage during the past year but we can’t find any formula to get potentials whose Stage were changed past Year. Could you please help me to find formula available in the Reports section in Zoho CRM?
Can't see custom Zoho CRM Tasks fields in Advanced CRM Analytics report builder even though we're set to auto-sync
We have setup Zoho Reports so that it syncs automatically, every 24 hours, with our CRM database. We created several custom fields in the Tasks module several weeks ago that I can not see in the Report Builder. This is strange behavior, as I *have been* able to use custom fields in reports on many occasions before. For some reason, I am not seeing them now. Also, since we are automatically setup to sync, I don't have the option to do this: Setup >> ZohoApps >> Advanced Analytics >> Settings >> Opportunities
Unable to connect with custom database created in ZOHO reports section
Hi, We have created CUSTOM Database in ZOHO CRM using URL like this https://reports.zoho.com/ZDBHome.cc?home=true I want to insert/select/delete/update records of table created in this Database , Please help. Do the APIS method URLs work for the report database too ? like this if i change Leads to table name https://crm.zoho.com/crm/private/xml/Leads/insertRecords?authtoken=00f6ab2897d75755a2ed314b49b846e5&scope=crmapi&duplicateCheck=1&version=4&xmlData=<Leads> <row no="1"> <FL val="Company">Company1</FL>
How I see tables or charts from another database to put in Dashboard
Example; I have two databases Database1 and Database2 in the database1 I have a chart named X. I like to ussing the Chart x from database1 in the Dashboards I create in the Database2. Is somebody help me
Running CSVUploadConsole.sh on PHP
Hi, Can anyone help me on this issue. When i run CSVUploadConsole.sh on PUTTY or some SSH, it works perfect. But when i want to run this on a PHP page it doesnt work. I get null. Here is my code; " shell_exec('sh CSVUploadConsole.sh mycsvfile.csv mydatabase mytable APPEND myuserforcrmreports -A myAuthKey')" Note: i run my php page at the same folder with CSVUploadConsole.sh Thanks, Umut
Report on project task work hours
I am planning to use the Zoho Projects task 'Work' field to enter work hours. This will be used to enter the estimated hours for a task. In Zoho Reports I can access Timesheet data to get the actual hours logged for the task using timesheets. I want to be able to compare the actual hours for a task versus the estimated hours entered in the Work field but I can't find where I can access the Work field in Zoho Reports. Is this field available?
Contact Report Missing
I think I accidentally deleted the contact report "template" and when I use the Accounts and Contacts, it does not show contact fields. How can I get it back??
Need a Calculate to show a Project's % Complete
I am trying to create a report that shows the total number of projects that are active and percent complete based on that. Any tips or trick to help me out would be much appreciated.
Showing Current and Previous Year on a Chart
I have a single table with columns "Date" and "Usage", I would like to to show on a chart, a combo chart with 2 series - the past 12 months, and the previous 12 months, to show a year on year comparison. How would I do this? Thank you Martin
Revenue report generation
How do I generate revenue report for last 1 year ? Where do I enter the details? Your help is really appreciated. Regards, Sathya
Edit the text size of the chart legend
Is there a way to edit the size of the text in the chart legend? Editing the font size for all other aspects of the chart is pretty obvious and straightforward. Is there a reason this is more complex? Is there even a way to do it?
Inactive links when you export a query in Excel
After you export the table query in Excel all the links, even if the data type "Link" are displayed in the form of text, which is extremely inconvenient for work
Select fields of API Zoho Reports in PHP
Hello everyone :) How I can Select a field of a table zoho report with API in PHP and I show it (Date field)? I find a lot of documentation on PHP Thanks
KPI Report Help: Group By and Comparison Indicator
I'm a noob at this because I am evaluating buying ZOHO for my company, but I can't believe I haven't been able to crack this with half a day of trying, googling and searching the blogs and forums. I'm trying to create a KPI widget that uses the "comparison indicator" feature, but I can't figure out how. I suspect my problem is something to do with the table I've setup. Column 1 is a Plain Text Column with Months of the Year, like January, February, March. Column 2 is a Numberic Column with whole
Pass command line parameters to UploadTool
Is it possible pass parameters to the upload tool from the command line - especially a parameter that could be used within the sql query to limit data retrieval? When doing periodic uploads it would be nice to have functionality based on:- eg: select * from table where fieldname > {parameter_1} Parameter_1, parameter_n could be passed on command line by task scheduler?
How do I add a custom field from Opportunities to Zoho Reports?
I created a custom field in Opportunities and I want to be able to report on it in Zoho Reports. How do I get the field to show up in my Zoho Reports builder? Thank you.
Not all projects showing up in ZOHO Reports
All the projects created by ALL the users are not showing up in ZOHO Reports. I need to be able to run reports on all projects not matter who created them within zoho projects. how do I go about doing this?
Empty dashboard (no data) when user filter value is unselected
We are trying to build a dashboard to display charts and tables that will help us to analyze the sales history for a selected customer. In the “User Filter” selection box of the dashboard, the Zoho Report’s user should first select the desired customer’s name (filter the list by name), and then all the charts and tables will display information that belongs only to the selected customer. What value could we add on the “Default Filter Value” of the “User Filter” menu, so no data is displayed as default?
Zoho Reports - New features rolled out on Oct. 1, 2015
Support to Auto Format Units of a Numeric Column Now Zoho Reports provides an option to auto format the unit value as thousand (K), million (M) and billion (B) based on the data in the corresponding column. Recently, Zoho Reports introduced formatting the numeric columns values with thousands (K) or millions (M) or billion (B) unit notations. Now with this Auto option, Zoho Reports auto detects the data in each record and formats the unit accordingly. This allows the flexiblity of setting the right
Allowed IPs associated to users
Hi, it would be great if Zoho Reports could allow to associate IPs addresses or ranges of IPs to users or groups of users. For example for the “Employees” users group (or for employees users) that only work on one location (most of our users) we would allow them to access Zoho Report only from one fixed IP address, and for the “Managers” user group (or managers users), we should impose no access restriction. Thanks!
Emailing Individual Records
I would like to be able to email individual records. Is there a way?
Incorrect Row Limit
I am trying to upload a CSV file that hass 50K rows. I am getting errors that I can not do so because the data exceeds 500,000 rows. I have cleared the contents and deleted the empty rows below my data to no avail. Any ideas?
UploadTool - The system can not find the path specified
Error: The system can not find the path specified. \ZohoReports\UploadTool\temp\Query_* What I do ?
Zoho Reports - New feature rolled out on Jul. 24, 2015
Chart specific Drill Down Path Now Zoho Reports allows you to set a drill down path for your chart axis from within Charts settings. This enables you to define drill down paths a lot quicker for a chart. You can find this option in Settings section, which allows you to define the complete path in the same dialog. This path is specific to the chart where you are defining it. When you open the Drill down settings, any drill paths paths already defined at the table level will be displayed by default.
Zoho Reports - New feature rolled out on Sept. 23, 2015
Charts Enhancements Display Missing Values Now Zoho Reports provides a new option to include the tick label for the data point, which does not have any value. This is available for both the date and the category columns. So far when you plot a chart with a date or category column, if a particular data point does not have any value, then the chart would skip this from the plotting it in the axis. With this new option you can choose to even display the point which does not contain a corresponding value
Chart to show total number of tickets and trending analysis.
Hi, My chart below shows the total amount of support tickets created at each office. 1. How can I show the total amount of tickets created from all offices? 2. How can I show a line chart for a trending analysis over a 3 months span? Thank you very much.
"Unknown" Tasks Status do not show up on a pie chart
How do i show tasks with an unknown status in a pie chart?
Pie Chart - Tasks with Status Unknow not able to view
How do I show in a pie chart all tasks regardless of their status (meaning: unknown,open,upcoming, complete, etc) in a pie chart?
Zoho Budget Number Field
What is the budget information stored on the Zoho Projects can be used in Zoho Reports?
Zoho Reports - New features rolled out on Sept. 9, 2015
Multiple Groups Support for Sharing & Collaboration Zoho Reports now allows you to create multiple groups to share & collaborate easily in a reporting database. You can group a set of users based on functional roles/needs to create a group. Within this group you could easily share data, reports and dashboards to enable easy collaboration. Till now there was a limitation to have only one group in a database, which has now been removed. Email Reports and Views as In-line Mail Zoho Reports now allows
Report WIdth when Publishing and Embedding in Blog
Hi Zoho, I am working with a group that is publishing a number of Zoho reports to a Google Sites wiki. Some reports do not display a scroll bar , even though you can't see everything in the right-most column. I've experimented with different widths (800, 1000, 1200) but that doesn't seem to make a difference. Any suggestions? Thanks, Kim
Next Page