Custom Data Source?

[Timothy Kelley]

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

[Steve]

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

[Pavel]

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

[Peter]

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

[Tormod]

Will OData be supported? And would it be overly optimistic to hope for this feature in Q3?

[Steve]

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

[Sebastian]

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

[Steve]

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

[Bernhard]

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

[Vassil Petev]

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