SSRS Change Background Color of Imagehttps://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)https://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 valuehttps://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 Constantshttps://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 Webhookhttps://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 Productshttps://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 Personhttps://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 Attachmentshttps://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 Promptshttps://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: *