JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Microsoft Tutorials & Guides

Practical Microsoft tutorials, troubleshooting notes and implementation guides from real projects.

Advanced search

91 entries / Microsoft

Clear filters
If Then Else in Report Builder 2.0 Expressions
SQL Server Reporting Services

If Then Else in Report Builder 2.0 Expressions

Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Field...

Read note 48,312 hits
SSRS Report Builder 2.0 - Error during processing
SQL Server Reporting Services

SSRS Report Builder 2.0 - Error during processing

The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names...

Read note 26,711 hits
Windows 7 Aero Features
Windows OS

Windows 7 Aero Features

Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough...

Read note 49,815 hits
Another ASCII Extended Character Set for PC
Windows OS

Another ASCII Extended Character Set for PC

Typing an ASCII character In DOS: Hold down the <Alt> key while typing the decimal number on the keyboard keypad. (Example: <Alt>178) In Windows for a DOS character: Hold down <Alt> while typing the decimal on the keyboard keypad. (Example: <Alt>230) In Windows for a WIN character: Hold down <Alt> while typing "0" then...

Read note 10,164 hits
Remove write-protect from USB pen in Windows
Windows OS

Remove write-protect from USB pen in Windows

I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb...

Read note 45,971 hits
Windows Live Messenger: Error 80048820
Windows OS

Windows Live Messenger: Error 80048820

This is an issue relating to the Time Server Synchronization error. Basically you start up windows live messenger and get the following error: /images/screenshots/windows_live_error_80048820.png Basically you need to check that the time on your windows clock is accurate or close to real Internet time:

Read note 23,795 hits
Windows 7:  System Clock is constantly going out of sync
Windows OS

Windows 7: System Clock is constantly going out of sync

The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windo...

Read note 248,080 hits
Add "Command prompt from here" to right-click context menu
Windows OS

Add "Command prompt from here" to right-click context menu

Applies to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Opti...

Read note 31,320 hits
$_SERVER['http_referer'] returns blank in Internet Explorer
Microsoft

$_SERVER['http_referer'] returns blank in Internet Explorer

Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Inte...

Read note 22,571 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
810 Site articles
29.7m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.