Home › Technical Problems › Report Viewer Error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Report Viewer Error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Posted on January 29, 2012 by Amogford — 2 Comments ↓

Got this error when running a report in report viewer. The query ran fine in SQL Server.

The report would also show when refreshed.

I found the answer was to open the dataset the report was based on, find the column maked as a key – (see picture) and delete the key

The report then ran fine.

 

 

Posted in Technical Problems
2 comments on “Report Viewer Error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints”
  1. materac do spania says:
    May 25, 2013 at 8:32 pm

    I was examining some of your articles on this site and I conceive this web site is very informative! Keep putting up.

    Reply
  2. projektowanie stron says:
    May 28, 2013 at 3:17 am

    I view something genuinely interesting about your weblog so I saved to fav.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>