Posted 10 September 2018, 3:09 pm EST
I am evaluating ActiveReports Server to identify if it will suit our company’s needs. Documentation would indicate this is so, however I have hit an early road-block.
I am trying to create a Shared Dataset on the server which accepts a parameter of type UniqueIdentifier, however I am continually getting the following error on verify:
“Conversion failed when converting from a character string to uniqueidentifier.”
The query for the DS is:
SELECT * FROM Employees WHERE CompanyId = @CompanyId
I add a parameter to the DS (data type of string), setting the default value to: AC4CAF47-CCD5-438E-9FBB-4CC9EE9FEECF
However I receive the error when validating. I have tried with/without quotes, with/without braces, nothing allows me to save this DS with a string parameter for this UniqueIdentifier Field.
I have tried using an integer parameter on an integer field and this works fine. It seems to just be the UniqueIdentifier field causing the issue.