iReports and MS SQL Server

Ok… So this really was not easy. If you google this you’ll find a bunch of crap that doesn’t work.

How to get iReports 4.x to work with Microsoft SQL Server 2008?????

Here’s what I did.

1) Downloaded the JDBC Drivers from Microsoft.
2) When you unzip it it will give you 2 .jar files. These are the core code.. the rest is just a waste of digital space.
3) If you’re on a x64 machine you need the sqljdbc4.jar file.
4) Paste this into the directory you install iReports under ireports\libs\
5) Restart iReports

Then it will work! If this doesn’t comment here… I’ll help you. DO NOT!! copy both files like I did. LOL it won’t work! That was my problem. I need the x64 file. No where in the document did it explain this.

Top 10 CRM Systems for Mid-Market

Before you go and bash my list this my opinion based on 15 years experience and working directly with hundreds of clients and evaluating tons of packages.

  1. Saleslogix
  2. Salesforce.com
  3. NetSuite
  4. SugarCRM
  5. SplendidCRM
  6. mySAP
  7. MS Dynamics CRM
  8. SageCRM
  9. ZohoCRM
  10. vTiger

Just because I rated it #1 doesn’t mean its a fit for your business. Like accounting packages they all have their pros and cons. For example, if you run a retail store or car dealership, Saleslogix is not the best option for you. It doesn’t handle B2C type businesses very well. What you need to do in just about every case is talk to a consultant (like me!) and figure out the the best CRM option for your business.

Lead vs Prospect

What is the difference? So many people get this wrong that it prompted to blog about it.

A lead and a prospect are too completely different elements. One could argue that a suspect and a lead or similar. I would tend to agree with that argument.

My simple definition of a Lead: A potential consumer who you are not sure is qualified to purchase your goods or services.

My simple definition of a prospect: A consumer who has is qualified to purchase your goods or services, but has yet to make a purchase.

This has nothing to do with time as some salespeople often think. If a person is not making a purchase today doesn’t mean they are not a qualified prospect. Let’s look a scenario where people often make mistakes.
Company a sells special widgets. Salesperson calls on this lead and finds out the lead just bought a special widget from a competitor and not in a position to purchase again for another 24 months. The salesperson then records this lead as “unqualified” in their CRM database. WRONG!!!!!!!! This bites so many people in the butt. This is a HIGHLY qualified prospect. Just because they didn’t buy from you doesn’t disqualify them. In fact knowing they are with a competitor makes it easier to market to them. You should already know the strengths and weaknesses of your competitors.

Now what if you sold cars? Does this mean everyone who drives a car, which is just about everyone qualified? Not always. If you sold Class A luxury vehicles and your lead’s age is 45+ and household income of under $30K/year. Chances are they can not afford to buy that new BMW 750i. Even more so, you should not sell it to them. Now on the flipside… if a person who has a household income of $300K/year or more and you sell cars $9995 and under. They are not qualified and it would make no sense to try and make them a customer.

Now… I can hear the comments brewing about the last paragraph. What if? What if? There is always a trump card. If a person walks in and says I want that car here’s the money. You sell it to them and take the money. However, we’re talking about taking someone through the sales process not just a closed sale.

What should you do with all your unqualified leads???? Most people just mark them for dead. That’s one sad and twisted way of looking at it. First thing, Treat everyone as you would your best customer. Second, turn unqualified leads into powerful community influences/referral partners. That person who makes $300K/yr might have many friends or employees in need of cars under $10K.

So I am hoping everyone reading this article (all 10 of you…lol) will help me in getting rid of the term unqualified lead and clear up the confusion between a lead and a prospect.