Welcome to my website!https://www.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 Joe. I like to think of myself as a web-developer but then I like to get involved with anything related to computers. I've been writing websites and scripts commercially since 1997 and I'm using this website to store notes as I go along. I specialise in...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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

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

05 April 2011 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 (ToDate) is the...

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

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

03 June 2011 issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions by Wikipedia If you are having difficulty...

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

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

26 October 2011 on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct...

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

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

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

06 December 2011 change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who uploaded, timestamp...

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

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

26 April 2012 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 on...

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

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

03 August 2012 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 websites, I...

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

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

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

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg....

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but...

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the method to restrict the introtext to the public and fulltext (read more) to...

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