ARTICLE
Implementing Search in Reports using ReportViewer
The ReportViewer control provides Find and FindNext methods to find a text in the report. This article explains how you can implement search functionality in reports programmatically.
Download
Files:
The ReportViewer control provides Find and FindNext methods to find a text in the report. The Find method takes two parameters - the text and the starting page number.
Now let's create a Windows Forms application and add a TextBox and a Button control to the form. The button click would search the text entered in the TextBox.
I have Form with a TextBox and a Button control. See Figure 1.
Figure 1.
I definite the following variable in the class:
Private firstFound As Boolean = False
The following code written on the Find Button click event handler.
Private Sub FindButton_Click(ByVal sender As Object, ByVal e As EventArgs)
If firstFound Then
Me.reportViewer1.FindNext()
Else
If Me.reportViewer1.Find(FindTextBox.Text, 1) >= 0 Then
firstFound = True
End If
End If
End Sub
Now if I type "Chand" in the TextBox and click the Find button, the first row is selected. Clicking Find again select the next row that has text Chand in it. See Figure 2.
Figure 2.
Download the attached project to see more details and working code.
To learn more about how to generate reports from database, XML documents, and objects, check my articles published in SQL Reporting Services section of this site.