Unclosed quotation mark before the character string

• Nagasree Mendu-135478

  SSC Journeyman

  Points: 79

  More actions

  September 12, 2004 at 11:07 pm

  #109007

  Hi,

  I am using SQL Reporting Server and have designed a report with a bar graph. On clicking on the bar I need to open a child report. And I need to pass the graph related data to child report.

  This works fine till I have no special charecters like #, & etc in the data. if I have a # in the data I am encountering the following error when navigating to the child report. I tried using urlencode also.

  • An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    • Query execution failed for data set 'Test'. (rsErrorExecutingCommand) Get Online Help

      • Unclosed quotation mark before the character string 'TAB'.

  Any help highly appreciated.

  -Nagasree

• John Jakob

  SSCommitted

  Points: 1720

  More actions

  September 14, 2004 at 8:44 am

  #522974

  Well, I know very little about Reporting Server, but could your query be written with the "CHAR()" operator? For example:

   

  Instead of:

  SELECT 'This is a string with a # symbol'

   

  Replace with something like:

  SELECT 'This is a string with a ' + CHAR(35) + ' symbol'