I do this all the time. Firstly, in my report database ( which has a linked server to each data server ) I have a table set up based...