SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911:...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module Settings". - Enhancement: Parameters switched from radio to list type. - Enhancement: Aesthetic tweaks for Joomla v3...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets...

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

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters] AS [Parameters] , e.[ByteCount] AS [Size] , e.[TimeDataRetrieval] AS [Data Retrieval] , e.[TimeProcessing] AS [Process...

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

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

17 July 2019 m_Payload.put("grant_type",v_GrantType); r_AuthToken = invokeurl [ url :v_EndPoint type :POST parameters:m_Payload ]; info r_AuthToken; Once you have a refresh token, it is not necessary to generate another refresh token as it does not expire. You would...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 REST API v2.1 on EU datacenter r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :POST parameters:m_Data.toString() connection:"myconnection" ]; or if converted to JSON, the request would read as: { "data": { "Subject":...

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

Joes Google Map (JGM) Downloadshttps://joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.1- Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters:...

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

Zoho Deluge: Convert Map to URL Parametershttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot...

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

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 m_Params.put("scope",r_Api.Scope_s); r_eBayResponse = invokeurl [ url :v_TokenEndpoint type :POST parameters:m_Params headers:m_Headers ]; //info r_eBayResponse; if(!isnull(r_eBayResponse.get("access_token"))) { // info "New Token Generated";...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql = invokeUrl [ url...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://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: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 v_ShopifyApiVersion = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", v_AccessToken); // // set...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the...

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

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

06 March 2023 request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the...

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

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

03 March 2025 r_AddTags = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Deals/" + p_DealID + "/actions/add_tags" type :POST parameters:m_Params.toString() connection:"azcrm" ]; info r_AddTags; } } } /*...

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

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties....

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