SSRS 2005 tabs/newline characters display in table

Posted by Paul Creasey on Stack Overflow See other posts from Stack Overflow or by Paul Creasey
Published on 2010-03-25T18:10:48Z Indexed on 2010/03/25 18:13 UTC
Read the original article Hit count: 433

Filed under:
|

Hi,

How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs?

For example:

SELECT
    VW.System_name + CHAR(13) + CHAR(9)  + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name

In SSRS (and SSMS Results to Grid Mode) table will render as:

 TRIPLE   > HYBRIDS    > HYBRID_CASHFLOWS

But i would like (as rendered in SSMS Results to Text Mode):

TRIPLE
 > HYBRIDS
     > HYBRID_CASHFLOWS

How can this be done in SSRS 2005?

© Stack Overflow or respective owner

Related posts about ssrs

Related posts about ssrs-2005