Share via

Dataset Filter adding unwanted double quotes

Dixon, Justin 0 Reputation points
2023-03-21T22:40:14.8733333+00:00

I'm using a dataset filter with an "IN" operator. Every time I edit a calculated field in the data set. The application automatically adds unwanted double quotes to my filter values. Why does this happen and how can I stop it?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,911 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-03-22T01:42:51.4466667+00:00

    Hi @Dixon, Justin

    I reproduced your issue.

    I used the "in" operator in a tablix filter and entered "Regular, Overtime" and the result was not displayed. When you go back to the design page to view the filter, it adds three double quotes for each field.

    1

    This may be a formatting issue with typing plain text. I retype the text with double quotes added, like this:

    2

    Then the data can be displayed normally.

    3

    It should be noted that after the data is displayed normally, I reopen the filter, he will display the text without quotation marks, if you click cancel, the data will still display normally, but if you select OK, it will reinsert the triple quotes.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.