Not even Android will offer hardware compatibility
As such, your testing of the iPad was looking for/at the wrong parameters. You needed to look at file compatibility and synchronization. I'm not saying the iPad would work for you, but Android might have done better than you expect.
However, for your purposes, if you're a Windows house (which most enterprises are) then you really should look at Windows 8 and Microsoft Surface RT/Pro. Why? because they're physically lighter than that big laptop you complain about and have much tighter integration with the Windows environment than any other available tablet. Sure, the Surface Pro might be more expensive than your current laptop, but it's much more compact while still offering all the full Windows capability along with the ability to use it everywhere, even standing up and walking down the corridors (as long as you don't mind crashing into obstacles.)