SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 and no one has forever). Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 Display flushdns errorlevel - Display registerdns errorlevel - Change color to green if successful, red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How?...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 screenshot: Click on "Save" to accept this Note: It is important to add these parameters rather than trying to retrieve the details with a zoho.people.getRecordByID("P_ApplyLeave",v_RequestId) in the function because on application, the record doesn't...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 // specify your Creator record ID holding the image v_CreatorQuoteID = 9876543210987654321; // // get the full details of the Creator record r_GetFullRecord =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 Tab_Section_7; // if(isNull(input.Tabs) || input.Tabs == "Quote") { show Tab_Section_1; } else if(input.Tabs == "Product Details") { show Tab_Section_2; } else if(input.Tabs == "Photos") { show Tab_Section_3; } else if(input.Tabs == "Shopify") { show...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 that this is for fixedpriceitems only. For auction ones, you would need to adjust the parsing code below to capture auction details. This includes a split for any multi-line item orders: // // declare variables to store order details in a JSON or...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 the top-right for "Settings" You should be in the "Organization Settings" Click on any page in the left sidebar (eg. Plan Details), your Org ID is in the URL as the last number after the slash (eg. "20012345678") Note this down for later use Create a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 */ v_BooksOrgID = "12345678901"; v_BooksInvoiceID = 0; v_ZB_CustomerID = 0; // // get this order details from ZohoCreator c_ThisOrder = Order[ID == v_OrderID]; // // get this customer record from ZohoCreator c_ThisCustomer = Customer[ID ==...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 of this user (this CRM is set to GMT-07:00 with daylight savings in effect) v_ThisTimeZone = "Europe/London"; // // get details from lead record r_LeadDetails = zoho.crm.getRecordById("Leads",p_LeadID); // // get created time (no need to check if null?)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 use-case This is a snippet that gets the tags of a contact and copies it over to the deal record: l_Tags = List(); // r_DealDetails = zoho.crm.getRecordById("Deals",p_DealID); if(!isNull(r_DealDetails.get("Contact_Name"))) { r_ContactDetails = invokeurl...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 ??? - ??? ******************************************************************************* */ v_Pipeline = ""; r_RecordDetails = invokeurl [ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ];...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 "" // wait for completion and if paragraph is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to some popular LLMs: [Score: 7/10] I gave the transcript.txt file (all...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 Keep Category=Module, set Page=Detail Page (Standard), set Module=Contacts and set the layout if you want. Under Event Details, set Type=Page Event; Event=onLoad Click on "Next" Give it the following code: // attempt try { // get the ID of this record...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 field called "Vendor Contact" var v_VendorContactID = ZDK.Page.getField('Vendor_Contact').getValue().id; // get the record details for this contact record (note this is ZDK.Apps.CRM but my syntax highlighter lowercases this) var r_ContactDetails =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. There should be a copy of the GNU General Public License included in each download. If not, see www.gnu.org/licenses.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *