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

14 December 2011 doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters set to the dummy value. For me it just opens an empty report with the charts saying "No Data Available" but...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the end-users to select a Joomla! article in the...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Data Not Yet Available Which isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct...

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

Background Gradient Disappears on Long Pageshttp://mail.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 Harmless you might say. Works fine on a small page but I have discovered limitations with the majority of browsers when having to spread gradient backgrounds across a long page. It would appear to be fool proof because of the "background:#f7f7f7"...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

23 April 2013 Feedback This solution took me two days to solve despite following an innumerable number of sites advising but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know of other ways to...

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

Reorder Columns in a Tablehttp://mail.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products......

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

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 and I do not have the extra time to allocate. They will do the investigative work to get the service up and running again. Having a small chain-of-command and quick development cycle, there are advantages to working on my own: I can keep costs low, I...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old...

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

Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 one record with a value of 0, then change it to 1. If it's name is "root..." and title is "Root Asset" then leave this as having a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related Error: "You...

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

Convert to Proper Case in T-SQLhttp://mail.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Why? If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using...

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

Joes Google Map for Joomla (JGM)http://mail.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 includes Points of Interest (POI). Considering I spent a good month styling Google Maps for Android OS on a mobile app, having access to the Google Map API v3 in JavaScript is a doddle... And incredible fun! I've added the options to style the map while...

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

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

29 October 2018 $the_file_and_path, $mime_type, $new_name); This method was the first one I could get working but it's a bit excessive having to send two requests (albeit in one function) especially with imposed limit requests. I can halve this so let's upgrade! Method...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how I've achieved this...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and perseverance....

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

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

12 August 2020 URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate access/refresh tokens using OAuth2.0. Usually used with an invokeUrl: response = invokeUrl [ url:...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 zet run: Error: Cannot find module 'portfinder'. Run.a npm cache clean --force. I didn't bother resolving this other than having a terminal with the command zet pack ready every time which returns me the ZIP file to upload by editing the widget in...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 v1 and XML. How? The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that the process would be: allow a user to apply...

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