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

Reports Using Stored Procedures

1 Answer 308 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 17 Apr 2008, 01:26 PM
 
 
I have been trying to create a Teleric Report which references a Stored Procedure via a DataSet.  I have been unable to place a TableAdapter directly on to a telerik report.  Further I have not been able to place TableAdapter into my visual studio 2008 ToolBox while focused on a Telerik Report.  Anyone else encounter this ?

The work around.  Here is how I have accomplished using the stored proc dataset.  I use the report wizard to create a new dataset, which does not prompt for stored procedures.  Once this is complete, a TableAdapter is automatically placed on the report.  At this point I manually modify the Dataset/TableAdapter to reference a Stored Procedure.  This seems to be a very roundabout way of doing things. 

Is there an easier way ?

Kind Regards
Daniel

1 Answer, 1 is accepted

Sort by
0
Svetoslav
Telerik team
answered on 18 Apr 2008, 02:52 PM
Hi Daniel,

I suppose you are talking about the DataAdapter-derived components (SqlDataAdapter, OleDbDataAdapter, etc). By default these components are not present on the VS2005 toolbox and you have to add it manually if needed. For more information please see Add data adapter and connection objects.

Another possible solution would be to add the code that creates and initializes the data adapters by yourself, for example in the report's constructor after the InitializeComponent() method.

Sincerely yours,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
Tags
General Discussions
Asked by
Daniel
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Share this question
or