Well it is not the most elegant solution I have ever come up with but it is working.

As I said I can cut and paste the data to the cell in excel, and that is what I have done.

By placing a record into row 2, setting the row properties to hidden and placing it above the frozen pane my report readers can not see the record

and the above TSQL works providing me with the body of my report.

If you know how this should be done, please share it with me.

Thanks

Ian