I have created the report in Crystal and there are 12 parameters, 2 of which are date to and from, and these are mandatory.  The report user has the option to choose either none, 1 or multiple of the remaining parameters.

I have tested the report in Crystal and it works fine

Now we come onto the issue!

I have uploaded the report onto SDE Reports Configuration server, set the report parameters and specified the report access.

I then go into SDE select report, enter date to and from, click show report and get this error:

'ReadRecords() : (-2147191859) - A number, currency amount, boolean, date, time, date-time, or string is expected here'

But the report works fine in Crystal....

The parameters used are:

Incident.Status Description

Incident.Completion Code

Incident.Source Description

Incident.Impact Description

Incident.CI Code

Incident.Service Name

Incident.Template Short Description

Incident.Opened Group