Derek Adkins - All Comments

re: Reporting Services Divide by Zero problem.

Greg — Fri, 07 Nov 2008 14:50:48 GMT

I like dave's solution with using code. It is easier to read than MHasan's solution. I changed the name of the function to SafeDiv because Dave's function name NDZ doesn't say much.

re: Warning: KEY DELTA in Isando

Bonita — Fri, 17 Oct 2008 08:10:39 GMT

I took my car for a service to Key Pinetown and what excellent service I got from the time of making the booking to the time of collection they did a great job and not to mention the great customer service,they even gave me a lift back home and kept me informed and collected me when the vehicles was ready,one thing I can add is that I went there with a positive attitude,maybe they picked this up and returned the positive attitude after all they are dealing with people - Well done guys keep it up

re: Reporting Services Divide by Zero problem.

James Thurgood — Thu, 11 Sep 2008 00:39:37 GMT

the solution by M.Hasan is the best, easy and works like a charm - thanks mate

re: Warning: KEY DELTA in Isando

Douglas — Tue, 09 Sep 2008 22:55:46 GMT

I am supposed to take my car in for service soon 60000km waranty service with Key Delta Isando and now you making me really worried cause I have already made necessarry arrangements, dont know what to do now.

re: Reporting Services Divide by Zero problem.

Wil — Tue, 09 Sep 2008 15:34:22 GMT

Hi the answer mayb there somewhere but cant seem 2 see it my problem is similar but not quiat:

=iif(Fields!Phone.Value is nothing,"No Disponible",iif(Len(Fields!Phone.Value) < 10 or Len(Fields!Phone.Value) > 10,Fields!Phone.Value,Format(cdec(Fields!Phone.Value),"(###) ###-####")))

Where if the value is a NULL or nothing I get "No disponible" n if the value is "1234567890" I get "(123) 456-7890" but if it is "456-7890" I get #Error n know why just wondering if something can b done about it

re: Using the SharePoint Solution Generator tool to create new list feature definitions

Roman — Wed, 03 Sep 2008 07:11:30 GMT

I solve problem when delete this comments. But I have a question, what porpose of this comments? Have you any ideas?

if it possible, mail me your ideas Roman_Stapunov@epam.com

re: Warning: KEY DELTA in Isando

Julian Mazery — Thu, 28 Aug 2008 08:09:36 GMT

I have had 2 Astras in my time. The cars themselves are excellent. It is a pity that they are serviced by monkey's. Not once have I been satisfied by Delta. My girlfriend has an Astra and her dealings have been the same. I think if your car is out of it's warranty, find a reliable mechanic and use them.

From Durban

re: Warning: KEY DELTA in Isando

Anel — Tue, 26 Aug 2008 10:18:36 GMT

Opel...NEVER AGAIN! I bought a 2006 Corsa CDTI Sport with 11 000km from Opel Centurion and here's my list of issues I've experienced since day 2!

1. Day 2 - the car's battery went flat and they had to replace it. I was also told that I need to service the car because it's a year old! After I've asked Kobus (the salesman) to through a service into the deal and he said no. How do you sell a car and tell a client to service it after 2 days! O yes...they had to replace the electric windows aswell!!!

2. 2 Weeks later - the clutch went. It took them (Midrand Delta) 2 months to get the parts. Never mind the waiting, when I got the car back, there was a 10 cm crack in my windscreen and the electronics was broken (Speedometer, Ref counter, etc.).

3. Took it back to get fixed and when I got it back again, they somehow damaged the ABS sensors so they had to replace that. I also realised that they didn't fit a shutterproof windscreen so I requested them to fit my car with the original Opel windscreen because that's what it had before THEY damaged it - they then did replace it.

4. Got it back and a few days later the Airbag sensors went. They struggled to get this fixed!

5. 7 Jan 2008 - Took the car in because there was a funny nock noise in the engin. After weeks they told me that they have to replace the injectors. I waited for WEEKS - lack of parts! Got my car back and it was leaking diesel. So they had to replace the injectors AGAIN.

Got it back again and this time it costed my R170 to drive 36km. The injectors leaked diesel again. It was soo bad that there was smoke coming out of my bonnet and underneath my car. Lauwrence from Centurion told me that it's save to drive like this...only did I find out later that diesel can actually catch fire if it gets too hot.

So they fetched the car and AGAIN replaced the injectors. Got the car back and it was jerking and the turbo didn't kick in. Then they replaced the dieselpump and some sensor on the turbo.

I finally got my car back towards the middle of May 2008.

I told them that the car is smoking more than it used to. They said that they will look at it when it comes in for it's service. So I took it in for a service and they said that nothing is wrong. I also told them that the petrolcap stripped and they said nothing is wrong..even though they charged me for it (and it's still under warranty). I told them that they need to look at the brakes, bought my own brakes and they said it's still fine.

Since I got it back from the service I've struggled to get an appointment with them (Centurion) because the car was smoking even worse. AND I can't fill my car. I can only put in 26L and then the tank is EMPTY. Eventually I got an appointment and it's been 4 weeks now and NO phone call from them (Centurion Opel). I followed up with them and they don't give me straight answers. I spoke to the place (not allowed to say) where they've sent the car to and that person told me that they need to replace the injectors and diesel pump AGAIN! Opel Centurion does not want to pay, they think I'm putting in dirty diesel in my car and wants an analysis of the diesel. I found out yesterday from 'the place' that there's water in my diesel and that they don't think that Centurion will pay for it. I phone Centurion and again they were very brief, telling me that someone will phone me. I'm STILL waiting for a call from them.

I will NOT pay for this. I told them about this since the day I got the car back and they did NOTHING! Anyway...the first time they had to replace my injectors I stayed in Centurion and moved to Menlyn right after I got the car back. Do you want to tell me that I'm the unlucky person to put in dirty diesel in two different areas 20km appart? AND why isn't my fiance's car giving trouble? We use the same garage!

re: Using the SharePoint Solution Generator tool to create new list feature definitions

sandeep — Sun, 17 Aug 2008 22:48:52 GMT

i never got that error ? all of my features still have the comments.. it might be something else in ur case ...

re: Warning: KEY DELTA in Isando

John — Fri, 01 Aug 2008 05:37:35 GMT

Yeah guys Key Delta is KAK, Took my corsa in for its 15000km service, told them that the handbrake light lights up when I turn to the right hand side. I got the car back with a few hickups bout the price they charged me for the service, anyway I drove the car like I stole it to see if it's a-okay. The next day drivin to my girlfriend the rear tyres started making weird noises, pulled over just to find they never tightened the rear wheels,it was on the verge of falling off.

re: Warning: KEY DELTA in Isando

EWALD — Sun, 20 Jul 2008 04:05:13 GMT

WHE ALL KNOW THAT OPEL IS ONLY GOOD FOR A 100 000KM, IT IS HIGH COMPRESSION ENGINES.

re: Reporting Services Divide by Zero problem.

João Pereira — Mon, 14 Jul 2008 14:00:09 GMT

I have this litle big problem when i divide by zero, the RS shows the #error isn Report, my expression:

=iif(Fields!TRANS.Value <> 0 and not Fields!TRANS.Value is nothing ,(Fields!VB.Value/Fields!TRANS.Value),nothing)

When i use a textbox no make the division, reports the same error..

Where is my error!

Can give a tip..

re: Reporting Services Divide by Zero problem.

Martin_B — Mon, 23 Jun 2008 11:04:18 GMT

Just wanted to say thanks for the solution. Saved the day for me.

Your a bunch of stars

re: Reporting Services Divide by Zero problem.

Martin_B — Mon, 23 Jun 2008 11:04:18 GMT

Just wanted to say thanks for the solution. Saved the day for me.

Your a bunch of stars

re: Reporting Services Divide by Zero problem.

Dee — Thu, 29 May 2008 04:04:53 GMT

Thanks guys - all the solutions worked for me!