Click here to Skip to main content
15,124,187 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
SQL
When click on Print report button to print the report which contains the data from two table i used foreign key constrain, i got error mentioned above please help me how to fix such error ?
Thanks.
Posted
Comments
BulletVictim 28-Jan-14 8:25am
   
From just reading the error it seems that the problem is within your data itself, where you have either specified a duplicate entry in a column that has no duplicates specified, left a row blank where there is a no nulls constraint, or the foreign key cannot reference the source(i.e there might be data missing on one of the fields where the foreign key gets its value).
Might not be that at all, but it's the first thing I would look at
ZurdoDev 29-Jan-14 21:46pm
   
What's your question? Your data is messed up.

1 solution

Set EnforceConstraints = false; in Designer.cs file(from xsd).
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900