Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds Count by str_replace took :...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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 Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build....

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a while to write and I would like to use it as a reference for when I forget...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 -> Disabled or Enabled You will still need to suffix the frontend URL with ?tp=1 Joomla 1.5.x This is another feature which took me a few years to notice in Joomla. If you've ever installed a template for Joomla and spent hours working out where or how...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were the instructions for applying the template and integrating it into Joomla...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 This took me a whole afternoon and involved a lot of hope as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...

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

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

25 January 2010 GuiClose: ExitApp The images I used in this GUI are: and . These have to be saved in the same folder as the AHK script. It took me a while to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

06 May 2010 and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the above statement along the lines of SELECT _SMDBA_.Incident.[Incident #]...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 my CD-Rom, I put in the disk but when I eject the CD there's nothing in there!". I can't really have a go at customers as it took 4 IT technicians deliberating over 30 minutes (remote support so we weren't there in person): The computer had two CD-Roms....

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 stream. One common problem people have is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 but these can sometimes confuse the program) Rant It's flimsy, crude but does what it has to do. The program itself took only about 6 days to make, it was a quick solution to a service that could not be obtained for free or without a lot of work...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

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