How to create rdlc reports in c#

Advertisement

In this article I will explain How to create RDLC reports in C#.

See my Previous article how to generate rdlc reports using code
How to Page number in rdlc reports
How to add no data found message in rdlc report

I Created a table in Sqldatabase as shown below. 

  

                       
 

Now I am going to implement rdlc reports, using vs2010.

Create a new project 

Select the windows and select form give solution name as show below.

Click ok.

Right Click on the solution explorer select new item

Select the Dataset as shown below, Click on add.

After Clicking add It will displays  the Dataset like this

Right click on Dataset add TableAdapter

I will display TableAdapter Configuration Wizard.

Click on NewConnection .

Add connection window will display now.

Select the server name.

Select database name.

If we want test the connection,Click on test connection Click ok->ok.

Click Next

Click next.

Now we have to choose a command type.

I am doing with Sql select staments in this example.

Click next.

Select the Query builder as shown below

Select the table name, In my DB having only one table

Click on Add .

After adding Close the window.

In querybulider window i want to show all the colum’s information,so I selected all.

We can also test how the data will display but clicking the QueryBuilder and click Ok.

Click next.

Click next.

Click Next.and finally click finish.

Now,right click on solution explorer, click on add new item select the report wizard as shown below.

After clicking on add, report wizard window will display

Select the Data source name what we created in our solution.

Select available datasets.

Click on Next.

 In the arrange fields window,we have to drag all the fields as shown.

Click on next->next.

Click Finish.

We are able to see  .rdlc like this.

Now Click on Form1.cs,From Toolbox in Reporting drag the report viewer as shown below.

In the ReportViewer Tasks, select the Report.

After selecting, Press F5.

We can see output:

See my Previous article how to generate rdlc reports using code

Advertisements

SHARE

Phani Kumar

• 
• 
• 
• 
•