Welcome to the Dynamics GP Support and Services Blog. This new blog is designed to provide you the insights, knowledge and challenges that our support engineers tackle every day.
No Data Returned When Using a JOIN in SmartList Designer
If we create a JOIN using two tables where one or the other ( or both ) have a large number fields, such as the Sales Transaction Work table, the SQL statement that is created exceeds the limit on the number of characters that can be used for a query in SmartList Designer.
We will need to change the fields we select – select only the minimum fields necessary to report your data:
This way, the query string will fall under the cut off threshold.
I hope this helps you get started with JOINS in SmartList Designer!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics