Skip to Content
0

Unsupported scalar function error in crystal report

May 24, 2017 at 02:25 PM

30

avatar image

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)

2.jpg (193.3 kB)
1.jpg (205.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy May 24, 2017 at 08:24 PM
0

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

-Dell

Share
10 |10000 characters needed characters left characters exceeded