Last post Mar 27, 2012 12:44 PM by Ashutosh Pathak
Mar 27, 2012 11:17 AM|MyronCope|LINK
using VS.Net 2005
I'm using a report project to create a report and I am on the data tab. I would like to use a stored procedure that I created in the database as the source for my data, how to set this up?
Mar 27, 2012 11:28 AM|kedarrkulkarni|LINK
see detailed explaination
hope this helps...
Mar 27, 2012 12:44 PM|Ashutosh Pathak|LINK
in your data tab, first create a datasource(pass the connection string to it or use shared data source if you have created) >> Create a dataset in this datasource by Right Clicking on the data source and then Add Dataset >> in dataset go to the query tab
>> select Stored Procedure from Query Type radio button group >> pass the name of your Stored Procedure >> Execute it >> Click OK.
PS: if your procedure takes parameters it will by default set the parameters name when you execute the procedure in your dataset. You can later modify those parameters to make them work as per your need.