Friday, June 26, 2015

Non breaking Space in SSRS

Been working with creating classical reports in SSRS for a customer lately and there are some tricks that you sometimes need to employ. Today, I found one, so this article will be short. Non-breaking space in SSRS can be set as an expression with the value "=char(160)",

White Sands - a sort of white space - broken by some tracks.
If using IIF or just adding it to the end of the line is up to you. It is at least good to know.

That was a short post and the tensions is building towards the 1:st. If you don't know why, check back on the 1:st and you'll know why.

Gustaf Westerlund
MVP, Founder and CTO at CRM-konsulterna AB
www.crmkonsulterna.se

2 comments:

  1. Good "trick", I found it useful as workaround about how to off text wrapping in tablix cell (which is not supported regularly). Small syntax correction Gustaf, it should be chr(160) instead char(160).

    Thank you for your post.

    ReplyDelete
  2. Good trick, I found it useful for workaround about how to off text wrapping in tablix cell which cannot be done regularly. Small syntax correction in your original post, it should be chr(160) instead of char(160).

    Thanks for your post Gustaf.

    ReplyDelete