Just one last thing since you seem to know your stuff (tell me get lost of you want :-) )
Having gained access to the RS server and underying tables I'm trying to make sense of how they all relate.
looking at your script and also doing some analysis of fields names within the tables, i starting to make sense of the DB.
Do you happen to know of a schema/data dictionary for the RS database that would show the links beteen the tables etc..
If not, its OK, you've helped me more than enough.