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

11 April 2014 difference. Applicable to the server, it will affect all reports on that server. Apply to each server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program Files\Microsoft SQL...

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

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

09 June 2014 Configuration Manager. This may not be the fix for you but it was for me: Open Start > All Programs > SQL Server 2012 (or your latest) Expand "Configuration Tools" and open "Sql Server Configuration Mnaager". Right-click on "SQL Server Integration...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar to the following:

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

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

02 September 2015 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 engine that...

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

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

23 September 2015 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

MySQL Transactions in PHPhttps://www.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 Our tables must use an engine that supports transactions ie. InnoDB. Don't be silly like me and spend hours wondering why your transactions aren't working on MyISAM tables.

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

Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 follow the below steps: Find the CSS class name of the reset button (usually "zc-live-secondary-btn") Add a notes field to your form Click on the HTML button to add HTML Add the following HTML: .zc-live-secondary-btn{display:none;} Done

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 This article is a quick note on how to change your Joomla CMS "Read More" to "Register to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 + ".csv"; v_CSVFile = l_NewCSVrows.toString("\n").toFile(v_CSVFilename); // // send via Email v_Subject = "From your friendly neighborhood developer"; v_Message = "Please find attached the Audit Log for the events dated " +...

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

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " "...

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