Synopsis:
When trying to print and access the Print Dialog in any transaction form (i.e., Quote, Sales Order, or Sales Invoice) an error will prompt.
Type : System.Data.ConstraintException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Column 'ReportCode' is constrained to be unique. Value 'RPT-000047' is already present.
Source : System.Data
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : Void CheckConstraint(System.Data.DataRow, System.Data.DataRowAction)
HResult : -2146232022
Stack Trace : at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
Solution:
1. Open the Report Center and find the Report that is having an issue. To do so, hover the mouse cursor to the reports to check the Report Code.
2. Export the report to make a backup.
3. Delete the report
4. Import the report.
5. Try to open print and open the Print Dialog in the transaction form
Applicable Version
Connected Business 19 and higher