This is a migrated thread and some comments may be shown as answers.

Custom Data Source?

9 Answers 445 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Timothy Kelley
Top achievements
Rank 1
Timothy Kelley asked on 26 Mar 2012, 07:40 PM
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

9 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 28 Mar 2012, 12:00 PM
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.
0
Pavel
Top achievements
Rank 1
answered on 26 Jun 2012, 11:48 AM
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
0
Peter
Telerik team
answered on 26 Jun 2012, 04:14 PM
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 >>

0
Tormod
Top achievements
Rank 2
answered on 01 Aug 2012, 05:07 AM
Will OData be supported? And would it be overly optimistic to hope for this feature in Q3?
0
Steve
Telerik team
answered on 01 Aug 2012, 07:15 AM
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 >

0
Sebastian
Top achievements
Rank 1
answered on 03 Aug 2012, 09:35 AM
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
0
Steve
Telerik team
answered on 03 Aug 2012, 03:21 PM
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 >

0
Bernhard
Top achievements
Rank 1
answered on 02 Oct 2012, 08:12 PM
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
0
Vassil Petev
Telerik team
answered on 03 Oct 2012, 01:57 PM
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!

Tags
Report Designer (standalone)
Asked by
Timothy Kelley
Top achievements
Rank 1
Answers by
Steve
Telerik team
Pavel
Top achievements
Rank 1
Peter
Telerik team
Tormod
Top achievements
Rank 2
Sebastian
Top achievements
Rank 1
Bernhard
Top achievements
Rank 1
Vassil Petev
Telerik team
Share this question
or