All dogs are a crap shoot.....because the environmental influences will play into the dogs ability and trainability.
That being said, getting a puppy from a breeder who has been sucessful at producing working dogs - in many venues - will load the dice to get you what you want.
I had a pup in my "C" litter - the pup was a monkey....he would scale the walls of the puppy pen, climb over and upwards on storage boxes and end up on top of the washing machine or halfway up blocked stairway.....he went to a SAR home, and ended up as a State Trooper - who is a successful narcotics, border patrol, SAR dog...one who at 2 years old tested by a German judge/LE officer-trainer who scoffed at the notion that the dog did not have bitework training. He hadn't, he was genetically capable and strong.....
A stable, balanced pup should be able to be trained in most any sport. And, if your interest so lies, dual titled.....IPO, agility, flyball, dock dogs, AKC OB....Willy, you have seen IPO3 dogs of my breeding doing flyball...the dog who is agility titled should have been IPO trained - she would have excelled at it...have played at agility with several and all take to it like ducks to water...yet these are dogs who are strong in IPO sport too....herding - although none titled before I sent Kira to Meghan, I was pretty sure because of demonstrated ability/instinct and pedigree that she would be suitable...for IPO as well as herding....
One key is finding a puppy whose breeder understands their lines, is consistant with using elements within pedigrees and who is producing solid, stable dogs - the rest is up to you to accomplish...you get only the raw material from a breeder.
If you want an absolute guarantee, then get a dog who is already doing a sport, is health tested and spend time bonding with him.
Csabre Sch1, Hexe Sch2, SG Bengal, Lynx, Komet, Kira HGH & Kougar v Wolfstraum ~ Ziberia IPO1 ~ ATB Basha, Kougar & Kyra, Fenja, Sch3s, Cito, Sch2, Danger RH & Alice Sch1s ~Kelsey