Hello Joseph,
The only reason that I can see why you're getting an error, is that the SQL you're providing in the Module Configuration -> Custom SQL datasource section is invalid.
Are you using a stored procedure? I would encourage you to look into the "Allow Free Form" feature and how this can assist you with building a custom SQL Query as the datasource.
By enabling this feature, you gain so much more flexibility and power with Dynamic Views to achieve complex reports with search filters included.
Please review our Dynamic Views User Guide and search for Allow Free Form to help you better understand this feature:
http://www.datasprings.com/userguid...rGuide.pdf Let me know if you have any questions.
Thanks,
Ryan