🚀 go-pugleaf

Nikhil,

You probably want to have a look at one of the database publishing
products such as Datazone's Miramo at http://www.miramo.com Datalogics
DLFormatter at http://www.datalogics.com or FiniteMatters
PatternStream at http://www.patternstream.com There's also a product
called UniMerge from Refined Reports (but they don't have a web site).

Each of these will probably do some aspects of your requirements
admirably, it's just a question of what does most of your needs and
are you comfortable with the cost and support.

There are a few VARs around that will help you put together a system
to meet your requirements. It might help if you put together an RFP
(request for proposal) outlining specifically what you hope to
accomplish, include the tools that you have available, send it to the
vendors and see what shakes loose.

You might get direct contacts due to this posting as well.