Magoo5289
Apr 29th, 2004, 04:43 PM
I am trying to enter an SQL statement directly into SQL Query Designer, and while this sql statement works within access and within crystal as an access query, it is generating an odbc error within crystal when I try to enter it as a direct SQL statement. ODBC error Too few parameters. Expected 2.
Here is the SQL command I am using.
SELECT [_8__Operations__Reports__Metrics__All_Calls].Qualifier, Count([_8__Operations__Reports__Metrics__All_Calls].Ticket) AS [Closed on First Call], Left(Right([Ticket],4),2) AS Responsible
FROM _8__Operations__Reports__Metrics__All_Calls
WHERE ((([_8__Operations__Reports__Metrics__All_Calls].SVCLevel)="Level 1") AND (([_8__Operations__Reports__Metrics__All_Calls].CCat)="#1 Help Desk Support") AND (([_8__Operations__Reports__Metrics__All_Calls].FistCall) Is Not Null))
GROUP BY [_8__Operations__Reports__Metrics__All_Calls].Qualifier, Left(Right([Ticket],4),2);
The plan is to get this query working through crystal using access as a datasource and then to switch the datasource over to lotus notes odbc and that should be it. Does crystal not handle all of the SQL commands that I am using, such as count and the left and right commands?
Here is the SQL command I am using.
SELECT [_8__Operations__Reports__Metrics__All_Calls].Qualifier, Count([_8__Operations__Reports__Metrics__All_Calls].Ticket) AS [Closed on First Call], Left(Right([Ticket],4),2) AS Responsible
FROM _8__Operations__Reports__Metrics__All_Calls
WHERE ((([_8__Operations__Reports__Metrics__All_Calls].SVCLevel)="Level 1") AND (([_8__Operations__Reports__Metrics__All_Calls].CCat)="#1 Help Desk Support") AND (([_8__Operations__Reports__Metrics__All_Calls].FistCall) Is Not Null))
GROUP BY [_8__Operations__Reports__Metrics__All_Calls].Qualifier, Left(Right([Ticket],4),2);
The plan is to get this query working through crystal using access as a datasource and then to switch the datasource over to lotus notes odbc and that should be it. Does crystal not handle all of the SQL commands that I am using, such as count and the left and right commands?