SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 + v_ShopifyProductID + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header parameters: m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends something like the following request (sent using Zoho...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 { v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData = Map(); m_FieldTextData = Map(); m_FieldBooleanData = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 info v_Endpoint2; // r_AddRow = invokeUrl [ url: v_Endpoint2 type: POST parameters: m_Params headers: m_Header connection: "zanalytics" ]; info r_AddRow; } } // // used while debugging / remove once in production if(v_CountTotal >= 3) { break; } }...

• 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 m_Params.put("ZOHO_API_VERSION","1.0"); f_ChartExport = invokeurl [ url :v_Endpoint type :POST parameters:m_Params connection:"zanalytics" ]; */ // // -------------------------------------------------------------------- // using Analytics API v2.0 (this...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 = "https://www.zohoapis.com/crm/v7/Quotes/" + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the...

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

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST parameters: m_Html headers: m_Headers1 ]; } catch(e) { try { r_GeneratePDF = invokeurl [ url: v_EndpointServer2 type: POST parameters:...

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

Joomla Component: Set default params on installationhttp://mail.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 No Job Header. /NJS :: No Job Summary. /UNICODE :: output status as UNICODE. :: :: Job Options : :: /JOB:jobname :: take parameters from the named JOB file. /SAVE:jobname :: SAVE parameters to the named job file /QUIT :: QUIT after processing command...

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

Joes Search Module (JSM)http://mail.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that are uploaded to a...

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

Joes Revolver Map (JRM) Downloadshttp://mail.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 Restored colors and new colors given - Enhancement: Compatible with Joomla v2.5.x - Fixed: Backwards compatible parameters updated - Date Uploaded: Fri, 16th Jan 2015 Download 1.5- Enhancement: Updated widget from RevolverMaps in HTML5 - Enhancement:...

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

Zoho CRM/Creator - Common Errors & Gotchashttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; Solution: My endpoint was the same as a create/add record when it should be suffixed with the ID of the item to update: v_DataEndpoint =...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 r_CreateTimeLog = invokeurl [ url :v_Url type :POST parameters:m_CreateTimeLog connection:"joels_connector" ]; info r_CreateTimeLog; Example #2: Pushing a time log defaulting to the current time as start time: // // init (from dropdowns you have made...

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

Zoho CRM: searchRecords with sorted resultshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer works. Please refer to method 2 using a search API or a...

• 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 this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This defaults certain arguments to any prompt you submit. I don't really...

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

ZohoBooks: Stripe Terminal Integrationhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 } } r_CreatePaymentIntent = invokeurl [ url :v_PaymentIntentEndpoint type :POST parameters:m_Params headers:m_Headers ]; info "Payment Intent Create"; info r_CreatePaymentIntent; // v_CheckObject = ifnull(r_CreatePaymentIntent.get("object"),"-");...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/" + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 r_Permissions = invokeurl [ url :"https://www.zohoapis.eu/workdrive/api/v1/permissions" type :POST parameters:m_Params.toString() headers:m_Headers connection:"zworkdrive" ]; info "Workdrive Permissions:"; info r_Permissions; // // response returns...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 + "/admin/api/" + v_APIVersion + "/webhooks.json"; r_ShopifyOrderWebhook = invokeurl [ url :v_Endpoint type :POST parameters:m_Params.toString() headers:m_Header ]; } // // create inventory level update webhook if(b_RestoreInventoryLevelWebhook) {...

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