If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The...

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of...

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

MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html

27 September 2010 something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

20 September 2011 Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

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

First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 = % _RGB1 _RGB2 _RGB3 StringReplace, HEXString, HEXString,0x,,All StringUpper, HEXString, HEXString Return, HEXString } Just in case, check a valid hexadecimal value: CheckHexC(HEXString) { StringUpper, HEXString, HEXString RGB:=HEX2RGB(HEXString)...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...

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

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images...

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

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common]...

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

Convert a delimited string to tablehttps://www.joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max),...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path...

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

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

21 November 2012 and username, show me the person! http:///Person.aspx?accountname=MYDOMAIN\myusername (where "" can be domain\username or just username. Master of the Universe!...

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

Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/web-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

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

Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using your Google APIs...

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