Sunday, 22 July 2012

How to create RDLC Report in C#

RDLC - Report Definition Language Client-Side

Step 1: In Solution Explorer - right click on add select new item. Select Report wizard with name like "report1.rdlc".




Step 2: In Solution Explorer - right click on add select new item. Select DataSet.



DataSet designer window is display. Right click on it and add Table Adapter.



Now Table Adapter Configuration window is display. Click on New Connection



Add Connection window is display. Now
  • Server Name- Fill your server name
  • Log on to the Server - Click on "Use SQL Server Authentication" and fill your username and password.
  • Connect to a database - select your database name.
  • Test Connection - click on it. If test connection is succeeded, then click on OK.
Click Next then select use SQL statements radio button and click next.

 
Click on Query Builder and add Table and close. There is an option of Execute Query. So use that to execute your query.

Finally, connection string is added on app.config file.

Step 3: Now, on your report1.rdlc, add datasource then Arrange Fields window is display then Drag and drop fields accordingly


Click Next and see the preview . Choose layout and style accordingly. And then click on finish.

Step 4: Add a Window Form, Form the toolbox select reporting and add Report Viewer on it.



Choose Report - Add your report "report1.rlc"
Choose Data Source - Add data source

then click on next and finish.

Now Run your application.

2 comments:

  1. I've been looking out all over for this blog about How to get boyfriend... assumed that I had bookmarked it a couple weeks in the past however couldn't find it and it was ache to search out your website once again. pdf-daily.com

    ReplyDelete
  2. Thank you very much for this useful article. I like it. auto facebook stream viewers

    ReplyDelete