JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

192 entries / matching Images

Clear filters
SSRS Change Background Color of Image
SQL Server Reporting Services 30062

SSRS Change Background Color of Image

Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color.

Read note
SSRS Stop Scrolling Behind
SQL Server Reporting Services 39759

SSRS Stop Scrolling Behind

I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should d...

Read note
SSRS Subscriptions cannot be created
SQL Server Reporting Services 35505

SSRS Subscriptions cannot be created

This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How?

Read note
Call to a member function mark() on a non-object in Joomla CMS
Joomla 40169

Call to a member function mark() on a non-object in Joomla CMS

This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your si...

Read note
SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase
SQL Server Integration Services 111953

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase

So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE.

Read note
Improve Default Joomla Search
Joomla 64023

Improve Default Joomla Search

So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line...

Read note

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.7m+ Reads / hits