OData support

2 posts, 0 answers
  1. Holger
    Holger avatar
    78 posts
    Member since:
    Nov 2012

    Posted 10 Feb 2017 Link to this post

    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

  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 14 Feb 2017 Link to this post

    Hello Holger,

    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
    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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top