Custom Data Source?

10 posts, 0 answers
  1. Timothy Kelley
    Timothy Kelley avatar
    37 posts
    Member since:
    Oct 2005

    Posted 26 Mar 2012 Link to this post

    I'm currently using DataDynamics Report(DDR) designer in an enterprise solution and I'm considering switching to the Telerik solution because the former product is in limbo.   I created  a .Net Custom Data Provider that simply passes SQL text to a web service and the service returns a DataTable.  The DDR designer or viewer can't tell the difference and works as though it is connected to a Sql Data Provider.
     
    Does the telerik designer and viewer support this functionality?
    Do you have an example?

    Tim Kelley

  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 28 Mar 2012 Link to this post

    Hi Tim,

    The SqlDataSource Component uses ADO.NET classes to interact with any database supported by ADO.NET, so you should be able to connect to your custom provider, just make sure you specify a providerName.

    Kind regards,
    Steve
    the Telerik team
    NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
  3. DevCraft banner
  4. Pavel
    Pavel avatar
    5 posts
    Member since:
    Jun 2012

    Posted 26 Jun 2012 Link to this post

    Hi Steve,

    are there any plans to support custom data sources (e.g. data source from external assembly which inherits from ObjectDataSourceBase) in the future version of the Report Designer? If yes any time frame?

    Thank you!

    Pavel
  5. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 26 Jun 2012 Link to this post

    Hi Pavel,

    Since the standalone Report Designer is a client application, there is no programmatic control over the reports i.e. there is no Object/OpenAccess/Entity Data Source. However in subsequent release we would add support for data feeds i.e. you would be able to consume any data that is exposed through a data service. In the meantime you can utilize Timothy's approach.

    Kind regards,
    Peter
    the Telerik team

    FREE WEBINAR ON THE NEW REPORT DESIGNER! Join us on Friday, June 29 at 10:00 AM PST for a comprehensive demo of the official version of the standalone Report Designer and find out how easy it is to empower your users with creating, editing and sharing ad-hoc reports. You may even win a free Telerik Ultimate Collection license! Register today >>

  6. Tormod
    Tormod avatar
    38 posts
    Member since:
    Jul 2012

    Posted 01 Aug 2012 Link to this post

    Will OData be supported? And would it be overly optimistic to hope for this feature in Q3?
  7. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 01 Aug 2012 Link to this post

    Hi Tormod,

    As my colleague explained, we are about to add support for data feeds (OData) so one will be able to consume data if exposed through a data service for subsequent version. We cannot engage with a time frame, but our goal is towards this.

    Kind regards,
    Steve
    the Telerik team

    BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

  8. Sebastian
    Sebastian avatar
    16 posts
    Member since:
    Jun 2010

    Posted 03 Aug 2012 Link to this post

    Hi,

    how to I create a connection to a SQLite database file using the standalone Telerik Report Designer.
    I've installed the latest SQLite ADO.Net Providers (1.0.81) and don't see how to create a connection string using those providers.

    Can you please give a hint how to do that ?


    Kind regards
    Sebastian
  9. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 03 Aug 2012 Link to this post

    Hello Sebastian,

    Close all VS instances and any report designer instances, download and install System.Data.SQLite v.1.0.66.0 instead and add the following markup to the Telerik.ReportDesigner.exe.config file:

    ......
    <startup useLegacyV2RuntimeActivationPolicy="true">
        <supportedRuntime version="v4.0"/>
      </startup>
    </configuration>

    When you open the standalone report designer, add SqlDataSource component and select SQLite Data Provider from the combobox, set your connectionString e.g. : data source="C:\Sample Databases\MyDataBase.sl3" and you're all set.

    All the best,
    Steve
    the Telerik team

    BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

  10. Bernhard
    Bernhard avatar
    5 posts
    Member since:
    Oct 2012

    Posted 02 Oct 2012 Link to this post

    Hello Steve,

    is there any plan to support also the newer versions from sqlite (1.0.82)? They support the very valuable wal mode.
    Or exists there any workaround for using it?

    best regards
      Bernhard
  11. Vassil Petev
    Admin
    Vassil Petev avatar
    1765 posts

    Posted 03 Oct 2012 Link to this post

    Hi guys,

    I just wanted to address the questions regarding the usage of custom data sources. The upcoming Q3 2012 version of the Report Designer will support custom data sources. For more information, please check the Roadmap.

    We will be showing the new features during Q3 webinar week, so feel free to register for the free event: Sign up for Q3 2012 What's New Webinar Week


    All the best,
    Vassil Petev
    the Telerik team

    HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Back to Top
DevCraft banner