Report not showing apostrophe data

• SQL_path

  SSCrazy

  Points: 2810

  More actions

  May 22, 2012 at 8:29 am

  #256843

  Hi,

  I do get all the data in my stored proc but when I run my report ssrs, it skips the rows which have apostrophe in Name column.

  I rechecked that There is no FILTER on the report. There is Name data set in my report and it has exact same available values as the ones in my stored proc result

  any hints would be appreciated.

  thanks.

  create table #123

  (NAME varchar(25) null)

  INSERT INTO #123 (NAME)

  SELECT 'O''Neill'

  UNION ALL

  SELECT 'O''Brian'

  UNION ALL

  SELECT 'smith'

  UNION ALL

  SELECT 'Brown'

  select * from #123

  drop table #123

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  May 22, 2012 at 8:51 am

  #1491142

  I've just done a quick test, 2 data sets, one based on the sample data given as a data set, and another as a proc based on the data in a proper table in my test db. Both datasets show the apostophe, so I am inclined to say its something report or environmental based

• SQL_path

  SSCrazy

  Points: 2810

  More actions

  May 22, 2012 at 9:02 am

  #1491152

  yes it is for sure on the report's end. Any idea how to fix that? thanks

• toddasd

  SSCertifiable

  Points: 6298

  More actions

  May 22, 2012 at 9:52 am

  #1491179

  Those are all single quotes ('), not apostrophes (`). I replace all single quotes with apostrophes on input and don't have to worry about double (triple, quadruple?)-single quoting again.

  ______________________________________________________________________________
  How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

• SQL_path

  SSCrazy

  Points: 2810

  More actions

  May 22, 2012 at 10:20 am

  #1491200

  Thanks, how do I do it? In the dataset NAme or in the proc?

  something like this?

  @Pararm =Replace( Parameters!Param.Value, "'", "''" )