Hello,
we are currently trying out Telerik Reporting / Report Server for usage in our product. Our software product publishes an read only OData service as an interface for report generators. Because Telerik Reporting has no built-in Support for OData we tried to use the "cdata OData ADO.NET Provider" in the standalone designer.
When adding a SQL Data Source to a Report we are successfully able to select the cdata Provider and connect to the OData Northwind sample Service (see screentshot #1). But then in step #3 "Configure data source command" the query builder is not available and the select statement fails with an error message (see screenshot #2). The select Statement works fine in Visual Studio Server Explorer.
Is there anything we can do to get it working?
Best regards
Holger
1 Answer, 1 is accepted
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.
Regards,
Stef
Telerik by Progress