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.

1 comment:

  1. I am a regular reader of your blog. the blog is very interesting and will be much useful for us.
    Email Marketing Chennai

    ReplyDelete