Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 A "Crystal Decisions" documentation. Blank columns appear when exporting to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 based on their religion, race, sex, political beliefs, or whether they are gay or straight. This is worse than flaming, because it also hurts other members of the board who fall into the catagory you insult. TEU is a place where everyone is equal, and...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 may not be used in connection with any product or service that is not JoelLipman.com's, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits JoelLipman.com. All other trademarks not owned by...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 of the compilation's users beyond what the individual works permit. Inclusion of a covered work in an aggregate does not cause this License to apply to the other parts of the aggregate. 6. Conveying Non-Source Forms. You may convey a covered work in...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 Invalid statement found Line:(20) However, I'm not bad at producing errors so here's another snippet that will also cause the error: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 down to the zoho.crm.getRelatedRecords() not retrieving related records which are clearly visible when using the CRM. The cause of the problem is the same as covered in my article Joel Lipman - ZohoCRM: zoho.crm.searchRecords only returns certain...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for the same reasons. I installed the standard 1.5...

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

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

25 January 2010 the above code so that even if you have other objects in the GUI, hovering the mouse over other objects will no longer cause the search button to flicker. More...? How about having the cursor change to hand when you hover the mouse over the image: /*...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 come across as commercial flashy sites. Their own website is glossy and dynamic. Very nice! Installing everything can cause a mess but otherwise nice solid and robust code.

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

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

22 October 2010 Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is loaded...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 in the above instructions accordingly. The use of some environment variables (eg. %ComSpec% or %windir%) in the command may cause an "Access Denied" error on some networks. Use the hardcoded path.

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 would initially display properly but then the white background would disappear when the page finally loaded. How? The root cause was because the template I was using was not actually specifying "white" as the contents background-color and was in fact...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Battery Constantly Drained on iPhonehttps://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it...

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

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well?...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Extract dates from...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type: text/javascript'); header('Access-Control-Allow-Origin:...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I was setting a cover page (as per the client's requirements) with a background image and the logo...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a field or on the validate process. And because info...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 This is a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 to PDF. But when you download the PDF and view this outside of the Zoho instances, the photos don't display. This is because the photos were just links in the Zoho Creator image field, links to another Zoho app that is behind a user wall (ie. login and...

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