asked
Crystal Report - SQL Query
SELECT COUNT(CASE WHEN ([INTERACTIONREF] IS NULL OR [INTERACTIONREF] ="") AND LEFT([ASSOCIATED INCIDENTREF],2)='IM' THEN 1 ELSE 0 END) AS [MONITORING EVENTS] FROM [Sheet1_] WHERE [CALL LOGGED] BETWEEN {?FromDate} AND {?ToDate} I have written the above query in Add Command of Database Expert, when I am executing the query it is throughing error as "Syntax Error - Missing Operator". Any help Please.
This web site runs based on your votes. Please indicate all the helpful answers below by clicking on the thumbs up next to them. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
Try changing this: [INTERACTIONREF] = "" to this: [INTERACTIONREF] = '' See what that does. I think the double quotes are messing things up.
Not sure then. It must be something within Crystal Reports and not the query itself.
As @Grant mentioned, first correct the the double quotes. Further depending what provider the cysterl reports are using, you will need to update the paramters in the where condition. In case OLEDB provider is used, you have to remove the paramter names and keep only the question marsk there. All Connection Mangers except
ADO.NET uses single question mark for parameter WHERE [CALL LOGGED] BETWEEN ? AND ?
ADO.NET is using @paramName WHERE [CALL LOGGED] BETWEEN @FromDate AND @ToDate Of course Crystal Reports can have it internal logic for parameters subsctitution in the queries. But the the above is standard for passing SQL Server parameters.
16 People are following this question.
