Add Image Mouseover effect in AutoHotkey GUIhttp://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip command below. CurrControl :=...

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

Windows 7: System Clock is constantly going out of synchttp://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 was successfully synchronized... You can opt to untick the checkbox next to Synchronize with an Internet time server to prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK Leave...

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

Project Plan for Freelance Websitehttp://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 will go to when they type your domain name. Important: You only need the domain name and no additional packages (not even email as our servers handle that). UK Domain Registration Services (for .co.uk, org.uk, .net.uk, etc): http://www.123-reg.co.uk/...

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

Windows 7 Aero Featureshttp://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by leaving a comment.

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

Crystal Reports: Exporting to Excel omits column headershttp://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

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

15 June 2010 Following up on my article on correcting disappearing 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....

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

RokDownloads Manager does not list fileshttp://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless we continue to pay for the subscription. Understandable to some extent,...

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

Parameters not being used in report processinghttp://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 tt.[SiteId] AS 'Site', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', tt.[RoomId] AS 'Room', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking Notes', c.[Name] AS 'Contact', c.[Company] AS 'Dept', c.[Phone] AS 'Phone' FROM...

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

Formatting a date in an MDX queryhttp://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 31 THEN 'st' WHEN 2 THEN 'nd' WHEN 22 THEN 'nd' WHEN 3 THEN 'rd' WHEN 23 THEN 'rd' ELSE 'th' END AS Ordinal, All very posh. Even Microsoft don't have helpful documentation on using SWITCH in an MDX query. Chances are they can't get it working either:...

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

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

14 January 2011 Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook...

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

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

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

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

CSS keeping the footer at the bottomhttp://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 a semi-transparent layer that overlapped it half-way. I managed to fix this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own...

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

Newbies guide to be the local computer guyhttp://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..."...

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

Joes Bug Tracker (JBT)http://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 whatever content based on however your Joomla! website is configured. My day job uses Team Foundation Server, Agile/Jira and even a bespoke project management system I wrote; so the brief for this component had to include features I've used all along...

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

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

11 October 2011 Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator...

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

Joes DNS Correction (JDC)http://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more...

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

SSRS Dropdown parameter cannot be blank!http://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters...

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

Basic Oracle Stored Procedure Structurehttp://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS,...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 date-of-birth based on the student ID number Agenda Outline Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in...

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

No rows returned in Oracle causes SP to failhttp://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me,...

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