Skip to Content
avatar image
Former Member

Unsupported scalar function error in crystal report

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 24, 2017 at 08:24 PM

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

    -Dell

    Add comment
    10|10000 characters needed characters exceeded