Sol Web Solutions Blog

Sol Web Solutions Blog is aimed to help, inform, educate and enable our site visitors.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Login
    Login Login form

Add spacing in SSRS 2008 expression

Posted by on in Reporting
  • Font size: Larger Smaller
  • Hits: 100629
  • Subscribe to this entry
  • Print

I had a requirement to add some spacing after a prefix of a textbox to align with a row below it and make the report more visually appealing. I tried the space() function within my expression, and that didn't work.

Here's what I did to resolve our scenario:

1. Left Double click the textbox that will hold this value/expression
2. Right click the textbox area and select "Create Placeholder" from the flyout menu option
3. In the "Placeholder Properties" pop-up modal, make sure to select
"HTML - Interpret HTML tags as styles" when in the "General" section

4. When creating the expression, I used the following for my padding:
=iif(Fields!datatype.Value="Issues", "Issue:"
& " " , "") & Fields!comment.Value

In my scenario, if the type was "Issues", then I needed to put:
a prefix of "Issue:" + spacing + my comment field




  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Wednesday, 17 January 2018

Help Today

Send an email here!

Sol Web Solutions will be glad to help you anytime with general or technical questions, suggestions or comments.

Website Hosting

Web Hosting

Sol News

We will not share, trade, or sell any of your information in any way. Your privacy is completely respected.