Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter...

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

F_ck You. Pay Me.https://joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Tim Minchin - 1984https://joellipman.com/articles/_other-misc/tim-minchin-1984.html

16 April 2011 The brilliant Tim Minchin using my favourite book as a response to "the Big Fat Quiz of the Year" show hosted by Jimmy Carr. {youtube}CZ7U3Cu4Mr4{/youtube} https://www.youtube.com/watch?v=CZ7U3Cu4Mr4

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

CSS Fieldsethttps://joellipman.com/articles/web-development/css/css-fieldset.html

25 April 2011 Add horizontal space between label and fieldset fieldset label.inline { display: inline-block; margin-left: 2em; } Change color of fieldset grouping line fieldset { border: 2px ridge #7abcff; }

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

Code Troubleshooting Checklisthttps://joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 So I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 What's this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an...

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

Increase Recent Documents Number in Windows XPhttps://joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://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://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://joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 So I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup...

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

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

27 September 2011 These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...

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

SSRS Repeat Headers in PDF Reporthttps://joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......

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

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

26 October 2011 My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking...

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

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

28 November 2011 MySQL 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...

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

Strip HTML in MySQLhttps://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://joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 What? In not as many words as others, 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...

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

Convert seconds to total time in PHPhttps://joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 What? This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes...

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

MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 What? Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting...

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

Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...

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

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

03 August 2012 What? Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various...

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