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

07 January 2011 ASC, Room ASC, tt.[StartTime] ASC, tt.[FinishTime] ASC I even separated off the @GivenDate and @GivenCampus and re-assigned them mid-script which made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot...

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

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

25 April 2011 Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that has a background image was under the left and right columns... The main content layer was...

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

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering from the backup I’d made silently. I guess it’s part...

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

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

28 April 2011 Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a...

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

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming...

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

MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 names... Users...the one with users names... Teams...another lookup table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE...

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

Fun with DllCall in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified...

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

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

25 November 2011 -- http://autohotkey.com/ * Joes Brains v0.1 alpha -- http://joellipman.com/ Future Considerations: Any suggestions? Send them to...

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

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

14 December 2011 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 set...

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

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

19 January 2012 as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should...

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

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For...

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

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

20 August 2012 who disallow access to their support forums after the subscription period expires are on the rise. I'm going to annoy them all by posting solutions here: for Joomla 1.6.x - 2.5.x: Out-of-the-box template: -- add subfolder if this is not in the root of...

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

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

11 September 2012 parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to...

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

Search a database for a string (MySQL, T-SQL)http://mail.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of their website. Why? In my job, it is important that we have a development environment for the...

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

Cheat Sheet for mySQL vs t-SQLhttp://mail.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset])...

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

Quickly update all content in mySQL database replacing a stringhttp://mail.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 World Hello World 2 Article 2 yes no no Hello World Hello World 3 Article 3 yes no no Hello World Hello World Now update them SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; UPDATE `MYTABLE_content` SET `introtext` = REPLACE(`introtext`,...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://mail.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 all our Oracle databases the same version? It's due to the fact that these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm...

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

AwStats Data Parser (ADP)http://mail.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to...

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

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the first column of the data...

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