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

report datasource

1 Answer 159 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Peter
Top achievements
Rank 1
Peter asked on 12 Jan 2009, 06:14 PM
Hi,
One of the things I am interested in, is this reporting tools ability to deal with data that is in a dataset. I can see from the documentation that it supports dataset, but so does Crystal reports, it just does it in a bad way (IMHO)

I have an existing application, all the data comes from a SQL server or VistaDB database.

I want to be able to feed this data to the report. I don't want the report engine to have to connect to the database and get the data itself. It should be able to use a dataset that I have already prepared in my code base.

That just leaves the question on how to design the report. I don't have a problem connecting to the sql server or vista db at design time to access the data structure for design purposes. However I want at run time to replace the design time datasource with the dataset in my application. This is where Crystal gets to hard, as it always seems to want to hang onto the design time datasource connection details, and you end up having to have the crystal report engine do its own connection and data selection.

Is this easy to do in your tool? Can you provide a code sample on how this is done ?

I would expect to simply be able to say telerikReport.datasource = ds.tables(0)...... and any design time connection information is destroyed..

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 13 Jan 2009, 03:51 PM
Hi Peter,

You would be glad to know that our Reporting product design is based exactly on your description - we do not do data unless you want us to do it. You can use the dataset you have prepared for designing the layout of your report - simply set the DataSource property of the report. However you would also have to fill that dataset in the Report constructor yourself, otherwise ds.tables(0) would not return data.
If you want us to fill it for you, well then you should use our Report wizard and handle your data in similar to Crystal fashion.

Give it a spin and let us know if further help is needed.

Greetings,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
General Discussions
Asked by
Peter
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or