Crystal Report With Search Functionality in ASP.NET

Here I will display an Employee report. The user can see any employee report by typing his/her name.

Now we will learn this step-by-step.

The following is my SQL Server table, for which I will show a Crystal Report.


Image 1.

Open Visual Studio and select File -> New Web Site.


Image 2.

Right-click on the project in Solution Explorer then select Add New Item then select DataSet.


Image 3.

Now Right-click and seelct Add -> Data Table.


Image 4.

Now right-click on the Header and select Add -> Column.

Be sure the column name and their Data type are the same as in your data table. You can change the data type by selecting your added column. Then right-click on something and select the Data type property.


Image 5.

Now right-click on the project in Solution Explorer then select Add New Item then select Crystal Report.


Image 6.


Image 7.

Select Project Data -> ADO.NET Data Sets then select your new Data Set then select your table then click Next.


Image 8.

Now select the columns for the report and click on Finish.


Image 9.

Now on your aspx page add a text box, button and a report viewer as in the following: