Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

(0) Share

Report

Posted on by dnewman

I'm running DSL 2011 with Feature Pack 1.

After migrating, we're having a problem with our SSRS based reports. When we try to use the IN operator on the Select Tab, it creates invalid SQL by adding extra single quotes around the parenthesis and the values.

E.g., when the query should be some.field IN ('test'), it is some.field IN '(''test'')' instead, which is invalid SQL. This causes System Message 6201, Error 56018 ... "Incorrect syntax near '('test')'.

Anyone else seen this? Is there any way for me to fix it?

Thanks

*This post is locked for comments

All responses (4)

Answers (0)

Kathryn Warner on at

Like (0)

Report

RE: Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

I too am getting this error. Will they ever address this bug?

I am trying to move several SSRS reports into SL. It seems SL cannot handle the most basic of SSRS reports. Is there a guide that states exactly what SL can handle in SSRS?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

Hello... is there any hotfix for this bug?
dnewman 85 on at

Like (0)

Report

Re: Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

How do I track the status of the bug? We are having to get all "creative" to reproduce our typical IN operator needs... Users love the IN operator :-)
Adam Leonard 2,151 on at

Like (0)

Report

Re: Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

Hi,

I've tested and duplicated this on the standard GL Trial Balance report and I was able to duplicate the issue. I've written up bug 25034 to address.