Click here to Skip to main content
15,868,016 members
Articles / Web Development / ASP.NET
Article

Dynamic Binding Of RDLC To ReportViewer

Rate me:
Please Sign up or sign in to vote.
4.71/5 (22 votes)
17 Dec 2008CPOL3 min read 341.4K   9.5K   66   24
This article demonstrates how to bind reportviewer control dynamically with Datasource at runtime.

Introduction

I was struggling to find the solution to bind rdlc dynamically to reportviewer .We had a scenario were we migrated our application from .NET 1.1 to .NET 2.0 .After migration embedding reportviewer with explicit objectdatasource was creating a major issue. Whenever we try to assign dataset reference to objectdatasource the IDE shuts down abruptly for no reason. This was one of the bug we encountered while developing. We searched a lot but this unique problem was faced by very few hence the correct solution was not available. We then planned to bind the reportviewer at runtime without taking objectdatasource. Below is the procedure to go about it.

Design Architecture

Sample Image - maximum width is 600 pixels

Production Deployment Issues And Its Resolution

During deployment if the source code is published and precompiled is created, one has to be extra careful to do below activity.

  • Create precompiled for deployment.
  • Replace the .RDLC file from the precompiled source code with the original *.rdlc file. The reason behind this is precompiled corrupt the .rdlc internal code constructs. In order to maintain its schema and design we suggest you to replace the precompiled rdlc with original one.

Prerequisite

Note: In production web server we have light weight .net framework installed so report viewer is not available. Due to which it will throw report viewer dlls not exist.

Click here to install Reportviewer.exe.

Problem Statement

There is customer table with two field customerid and customerName. We need to generate report for this datatable in reportviewer without using objectdatasource.

Create Dataset Schema

Follow the step given below to define dataset schema without connecting to any datasource. This is manual process. This is require each column of the table to added one by one as shown below.

Sample Image - maximum width is 600 pixels

Click on the toolbox icon to proceed further.

Sample Image - maximum width is 600 pixels

Add column to the schema as given below.

Sample Image - maximum width is 600 pixels

Create Report RDLC With Parameter

One needs to drag table from toolbox to panel to draw table section as body part of report. Once done that click on Show Data Source one will view the dataset schema section as given below. Drag columns into table row just below header section. Select Reportparameter from main menu and add one to report. This parameter value can be passed from aspx's form to Reportviewer's RDLC panel.

Sample Image - maximum width is 600 pixels

Drag textbox in report screen and right click to select property of it.

Sample Image - maximum width is 600 pixels

Click on Fx button of value field to associate this textbox field value to parameter set field variable.

Sample Image - maximum width is 600 pixels

Sample Image - maximum width is 600 pixels

Embed Report Viewer in Aspx

Drag Reportviewer into aspx design page and add localpath of the RDLC file. One can invoke storeprocedure and get the database resultset and can assign it to reportviewer. For running a version of this demo, I included hardcoded resultset.

C#
private void BindReportViewer()
   {
       ReportViewer1.Visible = true;

       //Invoke Stored procedure With Input parameter to it.
       //DataSet dsReport = objSP.GetTable(storedProcedure,txtParameter.Text));
       //Hardcoded Values.
       IList >Customer< customerList = new List>Customer<();
       customerList.Add(new Customer(1,"Santosh Poojari"));
       customerList.Add(new Customer(2, "Santosh Poojari1"));
       customerList.Add(new Customer(3, "Santosh Poojari2"));

       ReportParameter[] param = new ReportParameter[1];
       param[0] = new ReportParameter("Report_Parameter_0",txtParameter.Text);
       ReportViewer1.LocalReport.SetParameters(param);

       ReportDataSource rds = new ReportDataSource
           ("DataSet1_Customers_DataTable1", customerList);
       ReportViewer1.LocalReport.DataSources.Clear();
       ReportViewer1.LocalReport.DataSources.Add(rds);
       ReportViewer1.LocalReport.Refresh();
   }

Below is the expected output.

Sample Image - maximum width is 600 pixels

Conclusion

Hope this article will help those who are working on similar problem statement. Any suggestion and advice will help me to improve the quality of this article.

History

  • First Cut-Initial Draft: 11-Dec-2008
  • Updated Production Deployment Issues And Its Resolution: 19-Dec-2008

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead
Australia Australia
Whatsup-->Exploring--> MVC/HTML5/Javascript & Virtualization.......!
www.santoshpoojari.blogspot.com

Comments and Discussions

 
QuestionConnect to database? Pin
aspnoobie19-Mar-10 5:27
aspnoobie19-Mar-10 5:27 
AnswerRe: Connect to database? Pin
santosh poojari31-Mar-10 1:54
santosh poojari31-Mar-10 1:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.