Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

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

Posted on by 85

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

  • 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 Profile Picture
    Community Member Microsoft Employee on at
    RE: Using In Operator on Reporting Select Tab Creates T-SQL Syntax Error

    Hello... is there any hotfix for this bug?

  • dnewman Profile Picture
    dnewman 85 on at
    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 Profile Picture
    Adam Leonard 2,151 on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans