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

27 April 2010 Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This...

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

Report Builder 2.0 - Hide Series1http://mail.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1:...

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

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

12 July 2010 in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: OK, it's...

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

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

18 May 2010 no longer valid, I've uploaded their zip just in case to my own site available for non-registered members at http://www.joellipman.com/features/downloads.html?func=fileinfo&id=12. Install IE7 from Microsoft's website. Reboot if necessary Navigate to...

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

Web Browsers Release Yearhttp://mail.joellipman.com/articles/web-development/web-browsers-release-year.html

18 May 2010 Source: http://en.wikipedia.org/wiki/Comparison_of_web_browsers Year Web Browsers Internet Users (in millions) 1991 WorldWideWeb 1992 ViolaWWW, Erwise, MidasWWW, MacWWW 1993 Mosaic, Cello, Lynx 2.0, Arena, AMosaic 1.0 1994 IBM WebExplorer, Netscape...

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

Mark Twainhttp://mail.joellipman.com/articles/_other-misc/mark-twain.html

29 June 2014 The secret of getting ahead is getting started.

• Type: Article
• Author: Webmaster
• Category: Hobbies
• Language: *

Calculating Percentagehttp://mail.joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

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

26 May 2010 in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: Originally...

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

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

03 June 2010 If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttp://mail.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: *

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...

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

K2 Items disappearhttp://mail.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument...

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

Language Codeshttp://mail.joellipman.com/articles/cms/joomla/language-codes.html

13 September 2010 Having started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English...

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

Change the login link in MediaWikihttp://mail.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 As usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 What? This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for...

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

Joes Word Cloud (JWC)http://mail.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 Installation Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your...

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

UTF8 Unicode PHP MySQL for International Charactershttp://mail.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla!...

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

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

28 October 2010 Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the...

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

Create Read-Only Database User in SQL Serverhttp://mail.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as...

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