Ukgav suggested getting a proto type running which I'll try to do (on a local instance of sql) but it won't be until the end of July. It's a good point about reporting services being slow loading huge shape files and thanks for that link.

Best wishes

Paul