How Do I Select A Drop Down List Item On Crystal Report?

See more:

C#

ASP.NET

Visual-Studio

, +

I have a simple search box in my web app and i want to provide options of searching the employee table for either name, employee id or position etc. Ie, basically a drop down and then a text box to enter the value. The columns currently being chosen are from the same table.

I have assumed i need 2 parameters equating both such that one refers to the column name and the other to its value. Is it right? And if so, how do we pass the sql query on formula editor?

i have used Record Selection Formula. The code Ive written there is:

if ({?cat}="NAME") 
then {?val}={FATHIMA.NAME} 
else if({?cat}="POSITION") 
then {?val}={FATHIMA.POSITION}

where "NAME" and "POSITION" are column names. I have passed them manually as items in a drop down list. But the report gives an empty result. "cat" is the parameter holding the selected value from the drop down.


I have even tried coding it like this:

if(Length ({?name_sel})>0)
then {?val}={FATHIMA.NAME}
else if(Length ({?pos_sel})>0)
then {?val}={FATHIMA.POSITION}

with my c# code being:

string col = DropDownList1.SelectedItem.Text;
       if(col=="NAME")
       report.SetParameterValue("name_sel", DropDownList1.SelectedItem.Text);
       else
       report.SetParameterValue("pos_sel", DropDownList1.SelectedItem.Text);
         report.SetParameterValue("val", TextBox2.Text);

Please help! :(