Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 the context menu to display, I use Command prompt from here For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK > Close Notes: Added by default since...

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

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

19 May 2010 by running the program, right-clicking on the icon in the system tray and select "Edit Configuration...". Hopefully this will be of some use to you. Unduplicater v1.1 is a basic tool to compare two folders and remove duplicates (ignoring file...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed...

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

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

08 July 2011 you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a...

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

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

26 October 2011 row (left-most grey part) Select "Add Group" then "Parent Group..." 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...

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

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

08 November 2012 Sharepoint 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will correct the link when you OK it if you are trying to enter a real UNC path: File://\\myServer\myShare\myFolder\myFile.doc --...

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

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

08 January 2013 every month. Microsoft's Bing has added itself to the fray pretending to offer free services 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...

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

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 immediately. How? There are a few options out there but this one made a noticeable difference. Applicable to the server, it will affect all reports on that server. Apply to each server that requires it. Let your report server administrators do this: On...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

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

Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution...

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

Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 international languages) Select the "Integration" tab Change the “URL Routing” option from Legacy to Modern A further option will appear called "Remove IDs from URLs, set to "Yes" Click on "Save" and you are done.

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