Search functionality in crystal reports

Question

Hi All
I need to create a custom search functionality in crystal reports.what i need is ,when the page loads it should show the entire report and i have a text box and a search button.the user can enter text in the text box and the report should display on the searched records.ii have been restricted to use parameter fields
eg if the report contains teh foll fields

name age city
xyz 21 abc
mno 44 def
pqr 21 mmm

if the user enters xyz then only the first record should be displayed or if he enters 21 on the 1st & 3rd record shoud be displayed.

vishal sahani · Answer

I have been restricted to use jquery now.or any script.i need to use the asp controls & functionalities to display the result.. what i hav tried is I take the data from the user & get the desired data from sql and then bind the dataset again.but what happens is in the dataset i get the desired row but when i display teh report again it just replaces the data in that particular column with teh text.eg if i search abc it replaces the cities column with abc.. i have taken a text box and a button and im firing the query on button click.but instead of showing the results it is replacing the values

vishal sahani · Answer

I am doing the same thing i have taken a text box and a button and im firing the query on button click.but instead of showing the resulsts it is replacing the values..

Mayur Gujrathi · Answer

take one textbox or any other control you like on form might be on top on which you are taking crystalreport viewer and beside it take one button also and onclick of button fire query you want considering input in that textbox

vishal sahani · Answer

I have been restricted to use jquery now.or any script.i need to use the asp controls & functionalities to display the result.. what i hav tried is I take the data from the user & get the desired data from sql andthen bind the dataset again.but what happens is in the dataset i get the desired row but when i display teh report again it just replaces the data in that particular column with teh text.eg if i search abc it replaces the cities column with abc

Suthish Nair · Answer

Crystal Report will get rendered into html tables only. You can use jQuery to search those tables aand show the o/o. refer: Filtering an ASP.NET GridView control with jQuery