infolink

Monday 26 May 2014

An error has occurred during Report Processing



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. 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. 

DataSet Table Adapter
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
Table Adapter Field Propertie | Delete Key

Save DataSet Table Adapter and run report again.

2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. nice article.thank you for sharing useful post.
    web programming tutorial
    welookups

    ReplyDelete