March 25, 2015 at 5:57 am
Hi, i'm using SSRS 2008. In a Tablix-Field I have the Parameters prename and name. If there is no prename in the database i get a space at the beginning.
For example:
Phill Johnson
 Mayer (space character at the beginning because the field prename is blank)
Is there a possibility to prevent this space at the beginning?
thanks for the answers in advance.
March 25, 2015 at 7:13 am
How exactly did you put those fields in the tablix? Did you use an expression?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 7:19 am
Like that with two parameters:
[prename] [name]
March 25, 2015 at 7:30 am
You can check if the first parameter is empty. If it is, only use the second parameter. If it isn't, concatenate both.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2015 at 4:29 am
Ok. Where and how can i do it?
March 26, 2015 at 4:36 am
Right-click on the field, click Expression.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply