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

08 April 2014 based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent areas but displays the report background color instead: Right-click on the cell you...

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

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

02 September 2015 I found I could disable the third-party SEF extension and enable my Joomla SEF settings... ??? This is a Joomla 3.x issue.

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

SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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

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

14 December 2016 $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK")...

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

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

16 June 2021 sendmail [ from: zoho.loginuserid to: zoho.adminuserid subject: v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge:...

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

Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://joellipman.com/articles/crm/zoho/zoho-finance-suite-schedule-pattern-not-matched.html

12 June 2023 A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. Unless you can monitor when these type of schedules are failing,...

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