How to filter crystal report in c#?

Question

When I select values from drop down then click on show button it should show the crystal report for that selection.

Thanks,

Answer 1

string myQuery = "{Report.FieldName} < '1000'";

crystalReportViewer.SelectionFormula = myQuery;

Answer 2

IF u are filtering via programatically u can type, crystalreportViewr1.selectionformula="{Report.Fieldname}='"+filterdata+"'"; this is for filter the string data type. for int data type to be filtered, crystalreportViewr1.selectionformula="{Report.Fieldname}="+filterdata;