As you can see in the below image, I have taken a designation table from the database and added to the selected table list

After that, I had selected a column from the table and show them in the details section of the crystal report.

For creating a parameter field right clicks on the Parameter Fields option and click on New option to create a new parameter field.

In the new parameter section of the crystal report, give the name of the parameter and click OK. Here I gave a designation as a parameter name.

After that take Record selection formula from the special field in the crystal report and then right-click on the Record selection formula and Select Expert à Record.

After Select Expert à Record Choose Field dialog box will open, select the field from the table on the basis of which you want to display the report and click OK. Here I selected an employee_designation field as a base.

After that Select Expert – Record window will open, select the parameter field from the right Dropdown list and also select the is equal to option from the left Dropdown list if you want to show the details according to parameter value passed.

Design application form as shown below by using a label, textbox, button, and crystalReportViewer control from the toolbox.

After putting controls on form let’s move to the coding part and on the click event of button write the following code to pass the value in the parameter field.

    Private void button1_Click(object sender, EventArgs e)

     {

    {

              //creating an object of Report Document class

            ReportDocument reportDocument = new ReportDocument();

 

              //creating an object of ParameterField class

            ParameterField paramField = new ParameterField();

 

              //creating an object of ParameterFields class

            ParameterFields paramFields = new ParameterFields();

 

              //creating an object of ParameterDiscreteValue class

            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

 

     //set the parameter field name

            paramField.Name = "designation";

 

              //set the parameter value

            paramDiscreteValue.Value = textBox1.Text;

 

              //add the parameter value in the ParameterField object

            paramField.CurrentValues.Add(paramDiscreteValue);

 

              //add the parameter in the ParameterFields object

            paramFields.Add(paramField);

 

              //set the parameterfield information in the crystal report

            crystalReportViewer1.ParameterFieldInfo = paramFields;

 

              //preparing root for preview

            reportDocument.Load("D:\\rohit\\crystal reports\\CrystalReport1.rpt"); 

            crystalReportViewer1.ReportSource = reportDocument;

            reportDocument.SetDatabaseLogon("userid","password","servername", 

                                             "database");

         }

Here we can get output according to the parameter passed for employee_designation field.