Error:
An error has occurred during report processing. Exception has been thrown by the target of an invocation. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
![]() |
An error has occurred during Report Processing
|
This tutorial is about how to solve the above mention error.
This error is occurred when the unique, foreign-key field is existing in Table Adapter
of DataSet. And this Table Adapter is used in the report Data Source.
![]() |
Table Adapter |
Solution:
Its solution is very simple. Go to that Table Adapter in a
DataSet which you use in a report. Select the unique, foreign-key field and
then right click on it go to the “delete key” option and delete it.
![]() |
Table Adapter Field Propertie | Delete Key |
Save DataSet Table Adapter and run report again.
This comment has been removed by the author.
ReplyDeletenice article.thank you for sharing useful post.
ReplyDeleteweb programming tutorial
welookups