The Query Builder
included in the Standalone Report Designer is not the same as in the VS Report Designer. In VS we use the built-in functionality provided by VS. In the Standalone Report Designer we added own implementation based on Telerik Data Access which supports this list of databases.
You will have to type manually queries, where the implementation of the .NET provider should include logic allowing the reporting engine to get information about the structure of the query and any parameters in it.
In general, the SqlDataSource component uses the selected .NET data provider, associated .NET classes, provided connection string and query to create a connection and command and to execute the query. The query is executed during the SqlDataSource configuration in order data schema to be retrieved - the retrieved fields are listed in the Expression Editor
Please verify that the command can be executed. If there are additional settings for the data access layer, add them in the Standalone Report Designer's config file.
Also test to set manually the properties of the SqlDataSource in the Property Grid, instead of running the SqlDataSource Wizard.
Telerik by Progress
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items