How to Update Dataset for RDLC Reports

Question

I have created DataSet for RDLC reports. Now i have changed my Stored Procedure by adding some new Columns to it. DataSet contains different Stored Procedures, now how can i update the DataSet with out deleting and Re Creating it. So that new added Columns are available on DataSet for use.

Answer 1

In visual studio if you have the RDLC open you can open the Report Data window by pressing CTRL+ALT+D.

From here you click on datasets and then right click on the data set to refresh it.

Answer 2

I have solved it..

• Open DataSet
• Right Click on Required Stored Procedure.
• Clicked On Configure.
• Click Next, Next and Finish.

Now go to RDLC Report.

• Right Click on the Dataset and click Refresh.