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

26 January 2024 This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include photos of the faulty products. These display fine in a Zoho...

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

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

03 June 2010 was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our report 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...

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

Joe's CSV Chart Generator (JCG)http://mail.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that 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...

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

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 issue with regards to rendering. An updated and deployed report on the same day will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings (header&footer). Resolved this by clearing my...

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

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

27 September 2011 FileAppend, %ThisData%, %A_Temp%\delete_me.txt RunWait, %A_Temp%\delete_me.txt } PE_FunctionExports( PEFile ) { ; Lists Exported Functions/ Comp@t: WIN32_NT +AHK +LA +LW ;By SKAN www.autohotkey.com/forum/viewtopic.php?p=379086#379086...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.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 written this article, release a newer version that corrects this. I personally downloaded HeidiSQL, setup a connection and exported the database. Job done without making any changes to the LIVE environment!

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

Import Excel CSV file as JavaScript arrayhttp://mail.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...

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

Zoho Creator: Render to PDF with margins and page numbershttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 to PDF - Used more for links to open the PDF renderer in a new tab. Zoho Creator - Developer Guide - Customize Layout of Exported Page

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 */ // return "The function executed. Doesn't mean it did what we wanted to do. Just that it executed."; } Additional: The exported image will have a Zoho Analytics Logo on it. This is a setting. Go to the Organization Settings in Zoho Analytics > Under...

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

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

04 September 2015 dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that 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...

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