Post reply

Text Concatenation problem

  • April 1, 2009 at 4:00 am

    #219589

    Hi,

    I am trying to concatenate forename and surname on my form using the following expression:-

    =Fields!forename.Value & Fields!surname.Value

    But it is creating a big gap between the forename and the surname.

    I'm not sure where I could be going wrong.

    Any help most appreciated.

  • April 1, 2009 at 5:23 am

    #969733

    Try by trimming the value

    =Trim(Fields!forename.Value)&Trim(Fields!surname.Value)

    If not

    Trim the value while selecting the value from dataset

    Example : select ltrim(rtrim(forename)),ltrim(rtrim(surname)) from tablename

    Still not , try this method

    = (Fields!forename, "DataSet1") & (Fields!surname.Value, "DataSet1")

    Hope anyone will help you.

    Still if you not able to solve revert to me back

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • April 1, 2009 at 5:35 am

    #969738

    Thank you for that I'll give it a try.

  • April 1, 2009 at 5:44 am

    #969743

    That worked!

    I tried:-

    =Trim(Fields!forename.Value)& " " & Trim(Fields!surname.Value)

    Thanks again.

  • April 1, 2009 at 7:36 am

    #969820

    Linked to the same report, I am trying to make a join between 2 tables on different server.

    One DB is called vacancy and the other is called InsightSSRS.

    My from clause looks like this:-

    FROM vacancy INNER JOIN

    ON vacancy.userid = .userid

    INNER JOIN SQL1.InsightSSRS.dbo.CR_ORGANISATION ON vacancy.dbo.vacancy.vacorg = SQL1.InsightSSRS.dbo.CR_ORGANISATION.Org_Ref

    SQL1 is the server which the InsightSSRS database sits on.

    I am trying to make the join with this.

    It is erroring when I preview the report with:-

    The multi-part identifier SQL1.InsightSSRS.dbo.CR_ORGANISATION.Org_Ref could not be found

    Thanks.

  • April 1, 2009 at 8:08 am

    #969859

    Hi

    I think you need to set up a Linked Server between the vacancy SQL-servers and the insightSSRS SQL- server to get that to work.

    /Michael

  • April 1, 2009 at 9:04 am

    #969947

    Ok I'll give it a try, thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply