List of Values failure: fail to get values. [Cause of error: Failed to open the connection.

[jimcookson]

Hi,

Using CRX1 reporting off SQL Server 2012.

I have a view on SQL Server with a couple of basic inner joins. Querying the view through a CR on my desktop. The formula is:

{v_ClassManagementAttendance.date} > DateTime (2017, 07, 31, 00, 00, 00) and
not ({v_ClassManagementAttendance.full_name} in ["Left Course", "Not Required", "Public Holiday"]) and
{v_ClassManagementAttendance.department_name} = {?Department}

Running this on the desktop, the parameter opens, I select a department and the report runs without a problem.

Uploading the report through CMC and testing through either preview or on the InfoView console gives the following error: Unable to retrieve Object:
List of Values failure: fail to get values. [Cause of error: Failed to open the connection. department_name 2 Details: [Database Vendor Code: 17 ]].

If I remove the parameter from the report and upload again, the report works without error in preview and InfoView. Any help appreciated.