Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes41 results
The ReportServer Database
... rst error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minut ...
Blank columns issue when exporting to Excel (Data Only) from Crystal Reports
... -report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configur ...
Crystal Reports: Exporting to Excel omits column headers
... em, this extra dialog doesn't appear when our users export their reports. Not that it solved it as only some different headers appeared on the exported report when we followed that suggestion. Consider the following report in design view, o ...
Zoho Creator: Embed Forms/Reports on a Page
What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters ...
OpenAI ChatGPT + Zoho CRM: Fix the MCP Connection Error
... the connection URL supplied for that server. The message itself reports an OAuth metadata mismatch; it does not identify one universal cause. My recommendation is to give ChatGPT read-only tools. It can search records, retrieve details and ...
👍 Zoho CRM's Notes now gets Reactions and a new look
... when other data centres will receive the change. These are user reports and requests, not confirmed behaviour or documented fixes. In particular, do not assume that reacting sends a notification or that it affects a note’s edit permissions ...
Zoho CRM: Sync Deal and related record owners from Zoho Desk
... s and request up to 2,000 matching records per query. If a query reports additional matching records, the function returns before starting the owner updates. It does not silently process only the first page of that result. References Zoho D ...
Zoho People Analytics Regional Configuration
... confused with the standard Analytics feature under Zoho People > Reports. In Zoho People: Navigate to Reports Select the Advanced Analytics tab If the Advanced Analytics tab is not visible: Log in as a Zoho People Super Admin Go to Setup us ...
Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages
... ail of the app owner in analytics>"; v_WorkspaceName = "Zoho CRM Reports"; v_ViewName = "ZohoSurveys - Spider Chart"; // invalid oauth is check your TLD (eg. .com or .eu or ...) v_Endpoint = "https://analyticsapi.zoho.com/api/" + v_OwnerEma ...
Zoho People: Get Performance Records over API
... ient has seen the Goals or Objectives report under "Organization Reports" but would like some additional fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync ...
Zoho Analytics: Create a Monitoring System with Images
... has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll se ...
ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report
... name containing the "Attachments" data table r_Analytics = zoho.reports.createRow("My_Desk_Workspace", "Attachments", m_Data, "zanalytics"); info r_Analytics; // // add to analytics m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_Analy ...