SQL Server Performance

keep multiline textbox formatting (tabs) in report

Discussion in 'SQL Server Reporting Services' started by bubberz, May 1, 2007.

  1. bubberz New Member

    We have multiline text box of datatype ntext, and users will use tabs to format the data for better readability in our application.

    How can we keep this formatting in SSRS 2000? Right now, it simply goes away and resembles nothing like the application.

    Thanks!
  2. satya Moderator

    Not sure I have understood your requirment, do you have any issues in displaying that 'text' data in the reports or any issues with formatting of report?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. bubberz New Member

    Hello!

    Let's say I write the following in my application's multiline textbox:
    This is line one.
    This is line two with an indent or tab.
    This is line three with an indent also.

    The report will simply show the above three lines w/o the tabbing:
    This is line one.
    This is line two with an indent or tab.
    This is line three with an indent also.

    ....., and the users would like to keep this tabbing as it makes the data easier to read and follow.
  4. satya Moderator

    Yes that can be accomplished, look athttp://aspalliance.com/819 in this case.
    http://sqlserver-qa.net/blogs/bc/ar...intelligence-features-in-sql-server-2005.aspx - links to reporting services too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. bubberz New Member

    Hello!

    We're using SSRS 2000, your articles are for 2005.

    I don't see anything to format the text box to keep the formatting like the application does in the textbox control.

    Thanks!
  6. satya Moderator

    Hmm, I missed that and you have to check under BOoks online in this case and if I find any reference then I will update here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page