This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
ITSM In-App Reporting 9.1.00
Remedy/Smart reporting 9.0 and above versions
When trying to use "Group Data" function based on column in Smart Reporting report for Numeric/ENUM field(Status, Status Reason),report stop working and returns below error
ERROR (552): The SQL database operation failed.; Conversion failed when converting the nvarchar value 'open' to data type int.
To reproduce the case pelase perform below steps.
1. Create a report and add Status field in the report.
2. Go to column and select group data option
3. Create group like below.
4. post saving the group data field it will return the error message in the report.
ARJDBC driver does not recognize the group label for numeric field if it is in character format.
This is defect and reproducible in latest version(1808) as well. Defect : SW00518366
as a workaround please create a calculated field to group data based on the requirement,
CASE WHEN Status IN ( 'Assigned' , 'In Progress' ) THEN 'Open' ELSE 'Closed' END