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.

Advanced search

477 entries / matching AI

Clear filters
CSS Background Without Causing Scrollbars
Cascading Stylesheets

CSS Background Without Causing Scrollbars

Quick note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I separated off the clouds as another div layer, specified the...

Read note 31,507 hits
SSRS Hide results table if empty
SQL Server Reporting Services

SSRS Hide results table if empty

Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my...

Read note 92,803 hits
SSRS - Lost window with datasets
SQL Server Reporting Services

SSRS - Lost window with datasets

Re: Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open alread...

Read note 35,343 hits
Room Availability Calendar in Business Intelligence Development Studio
SQL Server Reporting Services

Room Availability Calendar in Business Intelligence Development Studio

Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I...

Read note 64,551 hits
Developer's Checklist: Taking over a project
Web-Development

Developer's Checklist: Taking over a project

So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forge...

Read note 68,485 hits
MySQL: Find records in one table that are not in another.
MySQL

MySQL: Find records in one table that are not in another.

The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via th...

Read note 36,973 hits
SSRS Expand specific drilldown by default
SQL Server Reporting Services

SSRS Expand specific drilldown by default

I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report...

Read note 27,106 hits
Upgrading a Joomla 1.5 module to Joomla 2.5
Joomla

Upgrading a Joomla 1.5 module to Joomla 2.5

So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be ref...

Read note 28,037 hits
URL passed settings in Reporting Services
SQL Server Reporting Services

URL passed settings in Reporting Services

Thought I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL.

Read note 52,527 hits

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
816 Site articles
30.0m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.