cancel
Showing results for 
Search instead for 
Did you mean: 

Unsupported scalar function error in crystal report

Former Member
0 Kudos

Dear Experts ,

I am using odbc connection in report , Just i want to change the date time column value in "YYYYMM" format and count the no of record . I am using below query in command , where i am getting error "Unsupported scalar function" . Please suggest .

select count(CONVERT(VARCHAR(6), closed_at, 112)) as monthyearcount, CONVERT(VARCHAR(6), closed_at, 112) as monthyear from change_request group by CONVERT(VARCHAR(6), closed_at, 112)

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

You don't have a "From" table in the command. How is it supposed to know where to get the data from?

-Dell