Display Quoted Text in SQL Report

• mandavli

  SSCrazy

  Points: 2122

  More actions

  February 8, 2011 at 2:06 pm

  #388807

  I want to display Quoted text in one of textbox. How do I complish that

  like

  transactionId TransactionName

  12 "Some Transaction"

  13 "Other Tranaction"

  I Want Quotes to appear on dispaly or in export file of SQL report

  Quotes are not existing in the Data; I want to add it.

  Thank you

• Niraj-627298

  Hall of Fame

  Points: 3641

  More actions

  February 10, 2011 at 7:54 am

  #1285209

  Hi,

  Please try this expression -

  =Fields!PName.Value.ToString().Format("''"+Fields!PName.Value+"''")

  Let me know, if it helps.

  Thanks,

  Niraj

• Kenneth Gladden

  Old Hand

  Points: 303

  More actions

  September 3, 2014 at 7:55 pm

  #1743056

  Actually in SQL I think it's:

  '''' + Format(FieldName, '####') + '''' to output a leading zero suppressed four digit number surrounded by apostrophes.