IntroductionThe reports consist of HTML containing multiple pages of data.
How to designThere are different steps for designing report using RDLC file. It consists of objects, such as images , table, line etc. Also You can design header and footer inside it. So lets start
Step-1 : Create a Database table into your website.
Step-2 : Add one DataSet (.xsd file) to the solution explorer using 'Add New Item'.
Step-3 : Right Click on your DataSet window , Add tableAdapter to init.
Step-4 : After adding TableAdapter , make connection to the database , so select database from dropdown menu.
Step-5: Select ' Use SQL Statements' in given radio buttons, you can select one of radio button from given radio buttons.
Step-6: Press Query Builder button and make select query. Also press Next button.
Step-7 : Choose method to select CheckBoxes , which is bydefault select (don't any changes) , press next button.
Step-8 : Click to finish button.
Step-9 : Add 'Report' (Report.rdlc file) into Solution Explorer using 'Add New Item'
Step-10 : Right click on your Report file window, insert page header and page footer.
Step-11 : Add One TextBox control to the Page Header from ToolBox. Also write init like " Student Performance details"
Step-12 : Add one table to the middle selection of rdlc file, now new window will appear on your screen.
Step-13 : In new window, Select DataSource from DropDown menu .
Step-14 : In table, Select second row of first column, Bind first column from DataTable column (using top right corner icon)
Step-15 : Similarly again bind all remaining columns.
Step-16 : Add new web form (Default.aspx page) using Add new Item to the solution explorer
Step-17 : Add Script Manager and Report Viewer control into webform from ToolBox.
Step-18 : Choose Report using show smart tag , also select rdlc file
Step-19 : Run your Application.
Step Generating the following output onto the browser window.