Bind rdlc dynamically to reportviewer using stored procedure

Question

_{Friday, May 14, 2010 6:28 AM}

dear all..

 I am using asp .net 4.0 report viewer...how is bind rdlc dynamically using stored procedure..send me some useful links r some example using stored procedure.in asp .net4.0 .

Advance thanks

regards

selva

 

All replies (3)

_{Thursday, May 20, 2010 5:34 AM ✅Answered}

Hi Selva,

Based on your scenario, you might want to build local model report(.RDLC file) in ASP.NET. If you want to retrieve the dataset using the stored procedure, you should pass the parameters to it from the user interface. So you can create a cascaded user control in ASP.NET pages to pass the parameters to your store procedure to retrieve the dataset for your local report. This thread has given the detailed steps and relevant code you can get a reference from it http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/04d58240-7ae7-4cf7-a6f0-b5067225b0ad

Relevant knowledge http://technet.microsoft.com/en-us/library/aa337091.aspx

Regards,

Challen Fu

---

_{Thursday, May 20, 2010 6:12 AM ✅Answered}

Hi,

The following article talks about dynamically assigning values to RDLC report. You can use your stored procedure instead of the SQL query and get the data.

Also, this one works in asp.net 3.5 and i believe 4.0 should be no different.

 http://www.am22tech.com/s/22/Blogs/post/2010/05/03/Designing-and-developing-RDLC-reports-in-aspnet-using-ReportViewer-and-Datasets.aspx

---

_{Friday, May 14, 2010 1:05 PM}

Please refer below links

http://www.c-sharpcorner.com/UploadFile/robo60/StandaloneRDLCReports11142007183516PM/StandaloneRDLCReports.aspx

http://www.codeproject.com/kb/aspnet/ReportViewer.aspx