none
Rich text sql 2005 RRS feed

  • Question

  • Hi

    I want rich text to be displayed on SSRS report in SQL 2005. That text is stored in database in html format from html editor textbox in frontend.

    Please help!!

    Thanks in Advance

    Wednesday, August 25, 2010 7:03 AM

Answers

  • Hi Garfield,

    Rich text feature is only supported in SSRS2008 or later version, Jason has gave the right direction. Here steps about adding HTML from a field in your dataset into a text box in SSRS2008 are:

    1. If the Toolbox is not visible, click Toolbox on the View menu.

    2. Double-click or drag a Textbox report item to the design surface.

    3. Drag a field from your dataset into the text box. A placeholder is created for your field.

    4. Right-click the placeholder, and then click Placeholder Properties.

    5. On the General tab, verify that the Value box contains an expression that evaluates to the field you dropped in step 3.

    6. Click HTML - Interpret HTML tags as styles. This causes the field to be evaluated as HTML.

    7. Click OK.

    If you have any concern, please feel free to ask.

    Best regards,

    Challen Fu

    Monday, August 30, 2010 3:15 AM
    Moderator

All replies

  • I dont think this is available out of box.

    Regards,

     


    Phani Note: Please mark the post as answered if it answers your question.
    Wednesday, August 25, 2010 7:20 AM
  • Hi

    I want rich text to be displayed on SSRS report in SQL 2005. That text is stored in database in html format from html editor textbox in frontend.

    Please help!!

    Thanks in Advance


    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ed30471b-114c-4934-bbf8-e5aa97dea093/

    Please check this similar thread .

    Thanks .


    Rajkumar Yelugu
    Wednesday, August 25, 2010 7:28 AM
  • Please go through the blog below:-

    road-blogs.blogspot.com/2010/04/rich-text-in-ssrs-2008.html

    This will explain how to implement it in SSRS 2008, and also an alternative to simple features in 2005 which includes making it bold or different color for different parts of the text

    By default, it is not supported in SSRS 2005 and you cant write html expressions


    Cheers,
    Jason
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Wednesday, August 25, 2010 11:32 AM
    Moderator
  • Hi Garfield,

    Rich text feature is only supported in SSRS2008 or later version, Jason has gave the right direction. Here steps about adding HTML from a field in your dataset into a text box in SSRS2008 are:

    1. If the Toolbox is not visible, click Toolbox on the View menu.

    2. Double-click or drag a Textbox report item to the design surface.

    3. Drag a field from your dataset into the text box. A placeholder is created for your field.

    4. Right-click the placeholder, and then click Placeholder Properties.

    5. On the General tab, verify that the Value box contains an expression that evaluates to the field you dropped in step 3.

    6. Click HTML - Interpret HTML tags as styles. This causes the field to be evaluated as HTML.

    7. Click OK.

    If you have any concern, please feel free to ask.

    Best regards,

    Challen Fu

    Monday, August 30, 2010 3:15 AM
    Moderator