Custom Report- Peripheral Skill Group

Hi,

I am trying to create a customized report by adding SL (Service Level) field to the "Peripheral Skill Group Historical Report".

I am getting SL as 0% in the SL column.

The Skill group interval table shows the correct data. If I paste the report's SQL query in SQL server, I get the same error.

Please help to resolve this issue

System Versions

ICM 10.5.(1)

CUIC 11.0(1)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi Swapnil,

Can you please attach the query which you are trying to run in SQL server and also the screenshot of the error you are getting there ?

Regards,

Mohini

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~