The report needs to be sent over to one of our clients in one report. I'm glad i'm not the only one that struggled with this, i was worried there...

Eventually the export needs to be automated, at the moment however i am running it stright out of SSMS 2008.

Hi Jeff,

Thanks for your reply, unfortuntly the end user doesn't want any spaces in the Header Row when it is in Note Pad, if you use Tab it puts a...

Didn't think of that, nice one thanks.

Hi All,

Managed to find the answer, if you create a group on the column and then go into the Group Properties you can put a page break between each group....

Thanks Chris, that worked a treat.

Sorry forgot to mention, the figures will vary so you may get 100.290000 or 1000.290000 which would need to look like 00000010029 and 00000100029