Multi Lines of Text field: blank news lines at the end RRS feed

  • Question

  • I am using SSRS to create quotes that will be send to customers.  The sales people sometimes want to add blank spaces between items for visibility reasons.

    Is it possible to have empty line breaks at the end of Multi Line Edit box?  I was thinking of adding characters that the Report Service will read as a line break and carriage return character.

    Christo Vermeulen

    Friday, October 17, 2014 8:29 AM


All replies

  • I think you could use a column or row between your items, and set the visibility based on a parameter. You could put a parameter at the top of your report and if it checked, show the empty columns or rows for spacing.

    Persian Dynamics CRM Community | انجمن متخصصان فارسی زبان

    Friday, October 17, 2014 9:15 AM
  • Please try this expression on textbox.

    =First(Fields!firstname.Value, "DataSet1") + VbCrLf + VbCrLf + 
         First(Fields!lastname.Value, "DataSet1")

    Also refer this.

    Regards, Saad

    • Edited by Mohd Saad Friday, October 17, 2014 9:53 AM
    Friday, October 17, 2014 9:49 AM
  • Thank you for the reply.  The problem is that sales people should be able to add any number of blank line spaces.  

    Christo Vermeulen

    Friday, October 17, 2014 10:07 AM
  • Hi Saad, I need the sales people to be able to add empty lines in the 'description' field of a QuoteItem.  So unfortunately this will not solve the case as I need to implement something on the crm UI web form.  

    Christo Vermeulen

    Friday, October 17, 2014 10:09 AM
  • check this post

    Regards, Saad

    Friday, October 17, 2014 10:22 AM