Search - Joel Lipman .Com

1. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; 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 ...; Created on 05 May 2022
2. The ReportServer Database: / Databases /; ... 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 minutes seconds ...; Created on 08 August 2011
3. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...; Created on 15 June 2010
4. Crystal Reports: Exporting to Excel omits column headers: / Excel /; ... exported via a web-based system, 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 ...; Created on 03 June 2010
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... workspace you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select ...; Created on 25 July 2024
6. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... e URL", v_Endpoint); // // first parameter is the workspace name containing the "Attachments" data table r_Analytics = zoho.reports.createRow("My_Desk_Workspace", "Attachments", m_Data, "zanalytics"); in ...; Created on 05 December 2023
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on ...; Created on 27 April 2023
8. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... to generate meaningful reports. The first dataset should be just the profit per item based on what was purchased. I'm including the Purchase Order ID so that I can refer to it later for shipping ...; Created on 03 November 2022
10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...; Created on 14 February 2022
11. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
12. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 ...; Created on 29 January 2021
13. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... and export using URL - Export a record template as PDF Zoho Creator v4 - Style based URLs for Embedded forms - Loading forms/reports without headers/functionality, Zoho Creator v4 - Navigational URLs ...; Created on 06 November 2020
14. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... a.`link`, a.`access`, a.`userid`, a.`expired`, a.`modified` FROM `v25_db`.`v25_jcomments_objects` a -- INSERT INTO `v34_db`.`v34_jcomments_reports` -- SELECT * FROM `v25_db`.`v25_jcomments_reports`; DELETE ...; Created on 12 September 2015
15. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; ... out there but this one made a noticeable difference. Applicable to the server, it will affect all reports on that server. Apply to each server that requires it. Let your report server administrators ...; Created on 11 April 2014
16. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; ... following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you ...; Created on 08 April 2014
17. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...; Created on 07 March 2014
18. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection ...; Created on 22 November 2013
19. MS Excel: Convert a text to a number: / Excel /; ... copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an error?!?!?!? The answer on the Microsoft website is as helpful as the Microsoft ...; Created on 15 November 2013
20. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data ...; Created on 11 November 2013