Thanks. I might be missing something here but we seem to be creating a table and populating it - I don't see how we end up with a physical file....

Perfect thanks! I googled openquery syntax to see what was and was not supported by gave up after a couple of pages of fluff.

Is there a way to check for...

Works perfectly, thanks! Also doesn't complain when it is passed NULL which is a bonus

Thanks, after trying many things I finally got around it by....
Going to the report server, finding the relevant report and selecting 'edit in report builder' from the drop down.

How can I output the actual values under the column headings as shown below?