hey
i can connect using the code from xojo to MSSQL but no from Reports ADK From Xojo waySqlStr="Driver={SQL Server};Server=localhost;Database=adg;UID=sa;Pwd=1223"
Haven't noticed a screenshot at first. So it isn't a connection issue.
Looks like your query contains ORDER BY clause. As it may be nested, for SQL Server it is necessary to define sorting in the report itself, not in the query.