It seems I have non-line breaking spaces instead of sensible, normal spaces which would of course stop the wrapping. Some strange unicode. I can replace char(160) with a...

Weird, it looks very much like my data. When I copy the notes from my table into a query in SSMS I'm getting something that looks like a red...

Fitz,

We were obviously typing at the same time! See my comments above. Yes your example would have worked correctly for me.

Martin

Fitz,

Interestingly I took the actual notes for a dozen examples and created a query as union of these text fields :

(select 'reviewing advisory' as Notes

union all

select 'review cc edits...

Steve,

The raw data looks ok. In SSRS yes the box grows in height automatically but the letters wrap at the end of the width of the box regardless of...

Hi Fitz,

It's all reports (I created a very simple one just know to re-test that) for any of the notes fields we have in the database. I'm not sure...

Hi Fitz,

It's a field (char(255)) in an existing table. The example I gave was how it was displaying in SSRS with it wrapping after the "Th" and before "ursday".

Melissa,

Thanks for the link to your blog, that was useful and timely post! The link from there at the end provided good technical reasons for using stored procedures.

Martin

Many thanks for your detailed, useful comments. The cacheing of the query plan may well be the key for me.

Thanks Luke, I thought that was going to be the route, just needed it to be confirmed.

Thanks for confirming I wasn't just being a muppet! I shall rest easy now, knowing it wasn't just me.

Thanks for both your suggestions. I've, for the moment at least, used text boxes in the page footer to host the totals. I'll also try out putting a...

As far as I can see you can't put a table/matrix into the footer.

You can use similar formatting style to Excel e.g. #,##0;-#,##0;# in the format properties of the field

That must of been the one permutation I missed!

Many thanks that works.