SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 the credentials we were using to access the the photos, so: Ensure the "Unattended User Account" can see the photos. - This solved the problem for us Some forums suggested to put this user also in the "Browser" roles of the Reporting Manager Problem #2:...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 of the connecting database user, but herein lies the problem. When you read my workaround, you'll say that I haven't solved anything; but this is a production database I want to export for offline backup. I have to raise and log a formal change request...

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

How to redirect the visitor after the contact pagehttps://joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 thankyou page and menu item for ID, change this in the code to redirect to the item ID - remove menu item Ultimately this solved the problem of redirecting the user after they complete the contact form: If you were wondering how to get the default...

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

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

03 June 2010 is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it solved it as only some different headers appeared on the exported report when we followed that suggestion. Consider the following...

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

Returned a data type that is not validhttps://joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 Caused by SQL statement returning first column date as CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) AS Month Solved by changing SQL statement to t1.Date AS Month This will return the SQL date but using your report builder or business intelligence...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each one says if studentreference is...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' +...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! •...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 -keypasswd -alias -new -keystore (replace with your windows login, with your JKS file) and with the app alias. The above solved it for me I had registered my computer SHA1 with the Google API console instead of the app SHA1, but here are some red...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters....

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample data. If you are expecting a 3rd comma in the value, then apply the regex again. The Final Solution:...

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

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

12 March 2022 3060 (in PCIe 3.0 x16 Slot) from extending to multiple monitors (would only display 1 monitor or 2 mirrored monitors)... I solved this by taking the old GPU out and doing the steps listed in this article. Originally bought a Corsair 750w White RGB...

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