SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status...

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

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 generation requests. Which you'll agree is economical for both the service and your own server. Services to use: Wimg.ca (unknown number of FREE prints - Tested: Add [http://wimg.ca/]) BrowserShots.org (unknown number of FREE prints - OpenSource)...

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

T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 last position from root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[last()]') FROM [dbo].[XML_EVENTS] -- to return unknown nodes from root node - STAFF SELECT Event_XML.query('/STAFF/*') FROM [dbo].[XML_EVENTS] -- to return unknown nodes from...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 LVN_GETDISPINFOW = (LVN_FIRST-77) Const LVN_SETDISPINFOA = (LVN_FIRST-51) ;#end region ;#region Drive Type Const DRIVE_UNKNOWN = 0 Const DRIVE_NO_ROOT_DIR = 1 Const DRIVE_REMOVABLE = 2 Const DRIVE_FIXED = 3 Const DRIVE_REMOTE = 4 Const DRIVE_CDROM = 5...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 v_FormName = "eBay_Webhook_Payloads"; v_ReportName = "eBay_Webhook_Payloads_Report"; m_Payload = crmAPIRequest; v_Type = "Unknown"; l_SoapActions = List(); if(!isnull(m_Payload.getJSON("headers"))) { l_SoapActions =...

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

Zoho Creator / Shopify: Get all Active Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 that we don't hit an execution statement limit v_ProductSKU = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID from the Shopify sort instead of...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 above the sales person (eg. "Sales Person") Alongside the Value field, enter ${Sales Person}.LABEL Under Label: Display 'Unknown' as, enter a dash/hyphen to indicate not known. Click on the button Apply Then on the dashboard, if you map your user...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 A_Index, 7) LV_GetText(v_Col08, A_Index, 8) LV_GetText(v_Col09, A_Index, 9) LV_GetText(v_Col10, A_Index, 10) v_Reason := "Unknown" if(v_Col09...

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

Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 EOS 5D Mark IV DSLR, f/8, ISO 100, 1/250 second, rim lighting, maximum detail, flattering designs, ambitious, artistic, unknown style::3 simple, bland, grainy, dull::-2 fiber: ::5 Fiberoptic neuron design on a black background::4 neon colors, cyan,...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON {"errorCode":8542,"errorMessage":"Unknown JSON attribute(s) found in the parameter CONFIG."}: This was because I was trying to include the parameter addIfNotExist and I...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 = ifnull(m_JobProgressData.get("jobCode"),1003).toLong(); v_JobProgressStatus = ifnull(m_JobProgressData.get("jobStatus"),"Unknown Error"); info v_JobProgressCode + ": " + v_JobProgressStatus; // // if job is completed (1004) if(v_JobProgressCode ==...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 } } // // create a contact v_SearchContactsCriteria = "Email:equals:" + if(isBlank(m_XeroContact.get("EmailAddress")),"Unknown",m_XeroContact.get("EmailAddress")); l_SearchContacts = zoho.crm.searchRecords("Contacts",v_SearchContactsCriteria);...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 } } // // create a contact v_SearchContactsCriteria = "Email:equals:" + if(isBlank(m_XeroContact.get("EmailAddress")),"Unknown",m_XeroContact.get("EmailAddress")); l_SearchContacts = zoho.crm.searchRecords("Contacts",v_SearchContactsCriteria); for each...

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