SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a...

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

Oracle: order by subquery missing right parenthesishttp://mail.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Regular Expressions in SQLhttp://mail.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called...

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

SSRS Border Problemhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 What? A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS...

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

SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 What? Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. Why? I want an image to display per row as a status...

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

SSRS No Delay for First Report of the Dayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 What? This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds...

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

SSRS Display question mark when date is blankhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 What? I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS...

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

Joomla WHERE clause with ORhttp://mail.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

16 July 2014 What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or...

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

DJI Phantom FC40 - First Flighthttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 Phantom FC40 for $500 USD filming at 1280x720 30fps. The YouTube Capture app has blurred some moments and the quality is somewhat reduced. I had switched stabilization off so the video quality is better than what you see on YouTube:...

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

Two icons created on Androidhttp://mail.joellipman.com/articles/google/androidos/two-icons-created-on-android.html

20 October 2014 What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared...

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

MySQL Updating a database table from another tablehttp://mail.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was...

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

Excel: Extract hyperlink from linkhttp://mail.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 What? A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel...

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

Forgotten Super User Password in Joomla 2.5.x - 3.xhttp://mail.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 What? A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How?...

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

Error 404 Component Not Found when enabling SEF URLshttp://mail.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 What? So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search...

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

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com....

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

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

Trim values along with the tabhttp://mail.joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

13 June 2016 What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to...

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

MySQL Transactions in PHPhttp://mail.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'"); What if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Deluge - Get Full Day Namehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

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