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 query without temporari table / cursor
Before making this dataset we must have made a stored procedure in our database then proceed as in number 1 but when creating the dataset we will choose procedured and stored automatically generated DataTable schema matching with stored procedures we have made.
Add the data source in accordance with RDLC datatable in the dataset that we have made.
3. By using stored procedure with a query with the temporary table / cursor
Before making this dataset we must have made a stored procedure in our database. The difference is that we make the stored data in the form of return value temporary table or cursor. With this type of stored procedure then we need to create tables in the dataset schema manually by right-clicking on the dataset designer and create a scheme, then adjust the columns in this schema with the columns generated by the stored procedure.
Add the data source in accordance with RDLC datatable in the dataset that we have made.
Hopefully ASP NET Reportviewer Using RDLC psoting would be useful.
Sincerely,
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 query without temporari table / cursor
Before making this dataset we must have made a stored procedure in our database then proceed as in number 1 but when creating the dataset we will choose procedured and stored automatically generated DataTable schema matching with stored procedures we have made.
Add the data source in accordance with RDLC datatable in the dataset that we have made.
3. By using stored procedure with a query with the temporary table / cursor
Before making this dataset we must have made a stored procedure in our database. The difference is that we make the stored data in the form of return value temporary table or cursor. With this type of stored procedure then we need to create tables in the dataset schema manually by right-clicking on the dataset designer and create a scheme, then adjust the columns in this schema with the columns generated by the stored procedure.
Add the data source in accordance with RDLC datatable in the dataset that we have made.
Hopefully ASP NET Reportviewer Using RDLC psoting would be useful.
Sincerely,
