Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously...

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

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

27 March 2014 FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and get both the code and the lookup value: -- What I have: no export format...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 true, "writersCanShare": false } Reminder: if you are adding the description, then pass this as a parameter to the above function. Source(s): Google Drive API v3 Google OAuth 2.0 Playground Google Developers Console - APIs RFC 2387 - The MIME...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value)....

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

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 If you run this as a standalone, then this will simply tell you what the link is to go to. Agree and note the code parameter passed in the URL (ie. "&code=..."). Also note that any generated code immediately expires any previously generated code....

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 to say connected. Done! Now you can use this in your custom function with the invokeURL without the need for a header parameter: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection:...

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

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 Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 Name, I'll give it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won't work if you don't include this...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 Order. How? The quick answer is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 m_Data.put("To",v_CustomerNumber); // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger off a scheduled workflow of...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as an Integer/Long/Number datatype As the first part of your code, enter the following as code...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 POST is not allowed for the requested resource"} The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL) {"code":2,"message":"The request passed is not valid."} The .setParamName() function is setting the...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 please check if mandatory value is entered correctly."}: Check your connection string. {"code":"9832","message":"Mandatory parameter(s) missing"}: Not sure why as the only mandatory field I had was the name field. Create a sample record with just the...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 be answered by "Construct Answer by Fetching Data" The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save" click on...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 the whole lot. How? Using the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ZohoCRM webhook, because...

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