URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 Customize the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 there. Adding Events Again I've put two rooms as examples in the above script. The "Events" table needs as a minimum the 4 fields "Room", "EventStart", "EventFinish", and "Status" ("Tooltip" was for me so that when the user hovers the mouse over the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 COM_Invoke(pwb, "document.getElementsByTagName[input].item[11].click") Set Value of an Input Field - value Sets the value of the Search for Keywords Input Box: Code: javascript: document.all.search_keywords.value = 'Input Value'; void 0...

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

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

19 July 2011 Values – Specify values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="", Parameters!StudentReference.Value, First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter...

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

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

02 September 2011 with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username...

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

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

07 November 2011 Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

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

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...

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

DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 WHERE ID = @ChosenID SELECT @UpdateData = Data FROM #Scramble WHERE ID = @ChosenId -- To dynamically update the Data in the field being scrambled SET @UpdateSqlStatement = ' UPDATE ' + @TableName + ' SET ' + @ColumnName + ' = @UpdateDataIn WHERE CURRENT...

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

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 = $db->query(); for Joomla 1.5.x Basic Query - 1 result $db = JFactory::getDBO(); $query = " SELECT ".$db->nameQuote('field_name')." FROM ".$db->nameQuote('#__my_table')." WHERE ".$db->nameQuote('some_name')." = ".$db->quote($some_value);...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' +...

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

T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates),...

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

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

27 March 2014 attribute "financialyear" of CURRENT_EMPLOYEE (eg. "2014") In a WHERE clause To select records matching a value for the XML field: SELECT * FROM [dbo].[XML_EVENTS] WHERE CAST(Event_XML AS XML).value('(/STAFF/GENDER="MALE")[1]','VARCHAR(10)')='TRUE' AS...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 (must go inside annotation) element Defines an element extension Extends an existing simpleType or complexType element field Specifies an XPath expression that specifies the value used to define an identity constraint group Defines a group of elements...

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

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

09 March 2015 and Joomla 3.3.1. It simply displays a search module form (same as the default install) only with the additional hidden fields: limit, search phrase (all, any, exact), ordering, and areas (set to doc_indexer by default as per the component). The...

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

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

29 October 2018 curl_setopt($ch1, CURLOPT_BINARYTRANSFER, 1); curl_setopt($ch1, CURLOPT_POST, 1); curl_setopt($ch1, CURLOPT_POSTFIELDS, file_get_contents($file)); curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1,...

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

Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the product_details field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line item...

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

Zoho Deluge - Compare time and currenttime with timezonehttps://joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 access token used in OAuth2.0 for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will switch the current time to...

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