Posts

Showing posts from March, 2010

ASP NET Reportviewer Using RDLC

One way of making reports on the web and windows applications is using Reportviewer object. Below is how to use reportviewer in making reports which requires 3 components, namely: datasets, design report (rdlc), and reportviewer object. In this post will discuss the 3 techniques to produce reports with use datasets, as below: 1. By utilizing the original table 2. By using stored procedure with a query without a temp table / cursor 3. By using stored procedure with a query with a temp table / cursor Here is a detailed explanation of these techniques. 1. By utilizing the original table Dataset can be created by adding the items on the project and select the type of dataset. After dataset added to the project, do a double click and then later modify the dataset by adding the tables in our database by completing a drag on the table that we choose. Add the data source in accordance with RDLC datatable in the dataset that we have made. 2. By using stored procedure with a