Hi,

I am new to Seal Report and have been trying to figure how the drag and drop functionality works in the data source creation tool. From what I have figured out, if I drag any number of elements from one table to Drop Row Elements it successfully generates a query on it own every time. However, anytime I try to get another table involved where a valid join relation ship is possible, it fails to dynamically build a query presenting this error:

---

Error building the SQL Statement...

Please fix these errors first.

Error when building the query:

Unable to link all elements using the joins defined...

Add Joins to your Data Source

OR remove elements or restrictions in your model

OR add relevant elements or restrictions in your model.

---

Is there no way to dynamically make JOIN connections like JasperReports does or is it something you just have to do manually?

Thanks! I managed to successfully make a join using this. However, I have to specify the column names in the JOIN clause: employees.<ColumnName> = jobs.<ColumnName> otherwise it won't compile. Is there anyway for it to automatically pick two columns with a connection or does this have to be done manually? I am asking because the people using this might not be familiar with SQL.