Unclosed quotation mark before the character string

  • 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

  • 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'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply