Post reply

how to display portion of text in one textbox and remaining portion of text in another textbox in ssrs 2008r2 report

  • December 4, 2014 at 2:45 pm

    #299216

    Hi ,

    I have dataset in the ssrs report that has a field which a total of 20 lines of text. But my requirement is to display part of the text in one textbox and remaining part of the text in different text field. Is there any way that I can do using expressions?

    Thanks alot

    Disha

  • December 4, 2014 at 3:49 pm

    #1762841

    in field1 use this expression to get the first 50 characters (for instance):

    =LEFT(Fields!FieldName.Value,50)

    in field2, basically do the same thing:

    =MID(Fields!FieldName.Value,51,LEN(Fields!FieldName.Value))

  • December 5, 2014 at 7:39 am

    #1762964

    I have implemented that, but looks like performance of the report rendering is not good. As I am generating single pdf for several beneficiaries.

    Thank you very much

    Disha.

  • December 5, 2014 at 8:54 am

    #1763000

    You can also do the same thing in your report query. Let SQL Server handle the heavy lifting.

    SELECT LEFT(mycol,50) AS [firstPart], SUBSTRING(mycol,51) AS [secondPart], ...

  • December 5, 2014 at 9:27 am

    #1763005

    Ok. I will check.

    Thanks alot

    Disha

Viewing 5 posts - 1 through 4 (of 4 total)

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