I made a report that's working great for everybody

 

We all connect over Terminal Server with different accounts to run our Crystal Reports and there is one report that goos crazy

 

it gives perfect results when i run it on user 1 but on user 2 i get the following error:

 

Het ophalen van de gegevens uit de database is mislukt.

Details: ADO Error Code : 0x

Source: Microsoft OLE DB Provider for SQL Server

Description:  The conversion of char data type to smalldatatime data type resulted in an out of range smalldatetime value SQL State : 22007

Native Error: [Leverancierscode database: 296]

 

There is only 1 parameter and that's a number and has nothing to do with date's.

 

Greets Adam