JOEL LIPMAN

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

209 entries / matching Images

Clear filters
SSRS Repeat Headers in PDF Report
SQL Server Reporting Services

SSRS Repeat Headers in PDF Report

The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked t...

Read note 36,305 hits
T-SQL Record Separator
Transact-SQL

T-SQL Record Separator

I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separat...

Read note 66,446 hits
Joes Network Transmission Detector (JTD)
Product Documentation

Joes Network Transmission Detector (JTD)

So this is a program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network. Basically on a computer that isn't on a network (ie. not connected...

Read note 34,786 hits
Alternative method of displaying Unicode in Autohotkey GUI
AutoHotkey

Alternative method of displaying Unicode in Autohotkey GUI

Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable

Read note 42,999 hits
SSRS External Images don't display
SQL Server Reporting Services

SSRS External Images don't display

The Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos. These images are provided via a website address (http) or networ...

Read note 112,722 hits
Excel PivotTable Filter List Ordering
Excel

Excel PivotTable Filter List Ordering

So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the rep...

Read note 49,887 hits
SSRS Parameters in Oracle Stored Procedure
SQL Server Reporting Services

SSRS Parameters in Oracle Stored Procedure

I'm storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error...

Read note 68,355 hits
Before and After, Highs and Lows
SQL Server Reporting Services

Before and After, Highs and Lows

So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do...

Read note 35,396 hits
SSRS Querying on either of 2 Parameters
SQL Server Reporting Services

SSRS Querying on either of 2 Parameters

The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is...

Read note 71,759 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
822 Site articles
30.1m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.