Thanks James. And yes it would be better to use Cryatal Reports, however at ArcGIS 10 ESRI no longer support CR. The problem with using CR if I have an issue ESRI will not assist in in unsupported feature. Interestingly enough, the local ESRI here have sugested using CR even though it is no longer supported! Puzzle me that batman?
There ae no ArcObjects that I can find for controlling the builtin ArcGIS Reports and as such I can't even find a way to create an Add In with something like VisualStudio (not without creating an entire library to control COM which I simply don't have the skills to do!).
I don't want to export to different data type as this will create multiple instances of the source of truth and nor should I have to. There has to be a way to do this with something a siple as model builderorthe like.