Demonstration of RDLC report with search and passing parameters (ASP. net mvc)

Last night I demonstrated the "ASP. NET MVC application show RDLC Report" http://www.cnblogs.com/insus/p/3665295.html RDLC report. In the implementation process, there are many problems that can be solved one by one. However, this article only displays all records on the RDLC report. As some netizens have said, can a report with a search record function be made. Therefore, Insus. NET tries to implement it in the following process.

With the previous experience, it should be difficult to do it.

 
Create a stored procedure in the database:

 

This stored procedure has three parameters. Later, Insus. NET sends the values to the RDLC report.

Under the Entities directory, locate and open FruitEntity. cs and add the following method:

 

Next, we create RDLC report, detailed can refer to the previous article ASP. net mvc application to show RDLC report, http://www.cnblogs.com/insus/p/3665295.html is just a complete state.

 

 

Because this article involves parameter issues, you need to input parameters for RDLC. Therefore, when designing a report, you should also add relevant parameters, such as the highlighted place of yellow. Create a parameter in RDLC. For example, column:

Specify the parameter name and two options:

 

The other two parameters KindName and FruitName are added in the same way as CategoryName.

 

In the AspNets directory of the application, create An aspx webpage:

 

The following ButtonSR click event:

 

Create an operation on the controller:

 

Create a view

 

Real-time Demonstration: