Search functionality in crystal reports
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 sahaniPosted Jun 23, 2011, 8:19 AM
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 sahaniPosted Jun 22, 2011, 4:48 AM
Mayur GujrathiPosted Jun 22, 2011, 1:54 AM
vishal sahaniPosted Jun 22, 2011, 1:01 AM
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 NairPosted Jun 21, 2011, 8:31 AM
You can use jQuery to search those tables aand show the o/o.
refer:Filtering an ASP.NET GridView control with jQuery