December 2005 - Posts - Derek Adkins

Setting report parameters in codebehind pages.

I needed to set SQL Reporting Services parameters in the code behind page. And this solution I found works perfectly! Much better than messy concatenations with URL parameters etc.

http://odetocode.com/Articles/156.aspx

Posted 19 December 2005 09:56 AM by derek | 2 comment(s)

Reporting Services Divide by Zero problem.

Hi all,

I hope someone can shed some light on how to correct this problem. I'm calculating a cents per kilometre value on a report in Reporting Services, and I'm using the following expression:

=IIF(Fields!ODO.Value <> 0, (Fields!MAINT.Value + Fields!SERVICE.Value + Fields!TYRES.Value) / Fields!ODO.Value, 0)

Now, for some reason, it's ALWAYS doing the divide. Even when the ODO field is zero. I've tried various brackets to try force RS to check the value of the IF statement before doing the divide but it doesn't work.

I want to prevent the report showing "#Error", and put ".00: in there instead.

PLEASE HELP! Thanks!

Posted 09 December 2005 11:34 AM by derek | 29 comment(s)

Filed under: .NET

The Matrix runs on Windows

I saw this here.

Click here for full size

Frikken brilliant!

Posted 06 December 2005 09:15 AM by derek | no comments

Filed under: Distractions

Ever forgotten the Admin password on XP?

Here's how to get it fixed:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=305

From http://www.bbspot.com

As long as you have the Original XP CD handy...

Posted 02 December 2005 02:13 PM by derek | 1 comment(s)

Delirious? concert last night

What can I say about Delirious? A FANTASTIC concert last night in Boksburg. The lights, the music, the atmosphere.... all excellent! Highly recommend that you go.. There's still time! They're having concerts all over the country during the next 4 days.

nov 30 05	Johannesburg	SA	Word & Life Church, Cnr Fisher & Trichards Rds, Sunward Park, Bocksburg, Johannesburg, South Africa Doors: 7pm Info + Tickets: www.wordandlife.com tel: +27 (0) 11 913 4567
dec 01 05	Durban	SA	Jesus Dome, Durban Christian Centre, Garth Road, Mayville, Durban, Soth Africa Doors: 6pm Info + Tickets: www.dcc.org.za www.computicket.co.za tel: +27 (0) 31 242 5000
dec 02 05	Port Elizabeth	SA	Word of Faith Christian Centre, William Moffett Expressway, Mangold Park, Port Elizabeth, South Africa Doors: 7.30pm Info + Tickets: www.wordoffaith.org.za www.computicket.co.za tel: +27 (0) 41 399 4400
dec 03 05	Cape Town	SA	Good Hope Centre, Sir Lowry Road, Cape Town Doors: 6:30pm Info + Tickets: www.goodhopechurch.com 083 915 8000 or 011 340 8000www.computicket.co.za tel: +27 (0) 21 703 9400
dec 04 05	Pretoria	SA	Hatfield Christian Church North, Corner of Willem Cruywagen & Brits Rd, Akasia, Pretoria, South Africa Doors: 6pm Info + Tickets: www.trev-concerts.co.za tel:+27 (0) 12 542 9000 tickets@trev-concerts.co.za, Impact Bookshops; Hatfield Christian Church North