Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 off the executable (EXE) within or run the Autohotkey file (AHK) if you have AutoHotkey installed on your computer. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 need to release service packs and updates. OTHER NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 every day in the range SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE = $0001 Const WM_DESTROY = $0002 Const WM_MOVE = $0003 Const WM_SIZE = $0005 Const WM_ACTIVATE = $0006 Const WM_SETFOCUS = $0007...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 DATEPART(week, ExecutionLogStorage.TimeStart), DATEPART(year, ExecutionLogStorage.TimeStart), Catalog.Name Chart-wise: create a line chart [Sum(Counter)] will be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 recommend seeing if you can't check at the database level first. I will in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 record activated similarly to the following: SET RECSEP WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column which marks rows (identifying when...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've called it ajax.form.php and the contents of which are: This...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1...

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

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 Don't overwrite any existing core files with this one, it's completely unnecessary as this is a 3.24Kb file. Step #1 of 1: Create and include the following PHP file, I've named this file "article.php" (thanks to my amazing imagination). The contents of...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 background: #f4f5f5 url(../../images/background/ambientturquoise/ambientturquoise.jpg) 0 0 no-repeat; } If using an image, create a folder and add the image matching the path in the previous step:...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 2 2012-07-23 419 2012/2013 3 2012-07-30... 467 2012/2013 51 2013-07-01 468 2012/2013 52 2013-07-08 I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 the map to the settings you want. Copy the entire javascript code they give you. Login to your Joomla website admin panel Create a new Custom HTML Module In the "Custom HTML", either disable rich-text editor or click on the HTML button Paste the code...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't want it to be a slideshow as well? Create a folder in your “My Pictures” folder in your home drive (check that this is the one on the homedrive and preferably not...

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