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

26 October 2011 and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00 Notes Monday 03/10/2011 Stationary Cupboard 09:00 17:00 Notes...

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

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

03 July 2012 range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 this website. The term 'Joel Lipman .Com', 'I', 'myself', 'us' or 'we' refers to the owner of the website whose registered office is available to those who contact Joel Lipman .Com. The term 'you' refers to the user or viewer of our website. The use of...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office workstation setup for this is: HP CMT DC7900 E5300 @ 2.60Ghz 2Gb RAM Windows XP Professional SP2 Internet Explorer 7 As you...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 = preg_replace("/&.{0,}?;/",'', $str); // removes numeric entities? $str = preg_replace('//i', '', $str); // removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 x Accessories > System Tools > Disk drive cleanup tool. Check Windows Eventviewer for all errors. Versions of Microsoft Office installed? Printing: Can you print any other documents? Have you tried printing to another printer? Can you print from any...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 select "Month" (or name of field) from the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this...

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

Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 editor I use with my day job's MediaWiki software and it's pretty amazing. Incredibly cross-browser compatible with some MS Office 2007 styling and fortunately maintains it's previous button layout. The features such as full-screen editing, emoticons,...

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

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

14 April 2011 This event took place on March 25, 2011 and was sponsored by Happy Cog and Typekit (who also hosted the event at their office in the Mission). 2011/03 Mike Monteiro | F*ck You. Pay Me. from SanFrancisco/CreativeMornings on Vimeo.

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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: *

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

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