I am having a strange issue when generating a report from a query result. I am using TDA 3.0.0 base edition.
I execute a script in the editor then try to send the results to Data Report Designer. I encounter the following error message:
Error converting data. Could not convert to .Net type
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
If I create a table from the results, there are three columns maked Not Null. Once I made all of them Nullable, I can send the data to the Report Designer without any problem.
Any anyone help with the issue as I still need to generate the report from the query instead of the table?