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

Thanks!

I had a request to create an autonumbering column in SharePoint 2010 for document numbering, and here is how we got the solution to work. I will use elementary school documents as an example.

The user could select one of up to 15 different school subjects when requesting a new document number, and the autonumber should stay in sync with the school subject...so there is no loss in the next available number for that particular school subject.

This is why I can't simply use the ID column that's associated with every list and append that to the eventual variable in a workflow.