Cannot get the current row value of column "[ADsDSOObject].FIELDNAME" from OLE DB provider "ADsDSOObject" for linked server "ADSI". Could not convert the data value due to reasons other than sign mismatch or overflow.

Reason:

When you query a multi value field from AD, regardless you enter one value or multiple values. When you remove all the values. Erros goes away.

Solution:
Use single value fields such as employeeid, employeenumber etc.

Snapshot for error

Multi-value field

Single value field

error rendering control crystal report viewer

The problem occurs due to incorrect version installation of crystal report for visual studio 2010. Following are the solutions as i'm able to apply successfully.

1. Permanent Solution:
Unintall crystal report engine and crystal report setup for visual studio & re-install it both with same version for example for version 13_0_2
  i. CRforVS_13_0_2 (Same for both 32 / 64 Bit)
 ii. CRforVS_redist_install_32bit_13_0_2 (for 32 Bit)  / CRforVS_redist_install_64bit_13_0_2 (for 64 Bit)

2. Temporary Solution:
replace register value from following lines.

<%@ Register TagPrefix="CR" Namespace="CrystalDecisions.Web" %>
< %@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

Note. The above packages can be downloaded from following location;
http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp

Server is not configured for RPC

A common error is returned when you try to run stored-procedure on Linked server.  However if you querying directly from table there is no error.

By default RPC Out setting are set as False.

By changing the RPC out value to True. The issue is resolved.