Hi smile,

Using the below article i have created the example.

Basic Crystal Report Tutorial with example in Windows Forms (WinForms) Application using C# and VB.Net

Check this example. Now please take its reference and correct your code.

SQL

CREATE TABLE Admission(AdmissionNo VARCHAR(10),ClassID INT,SectionID INT,SubjectID INT,Max INT,Mark INT)
INSERT INTO Admission VALUES('R-000001',72,232,130,50,34)
INSERT INTO Admission VALUES('R-000001',72,232,129,50,30)
INSERT INTO Admission VALUES('R-000001',72,232,128,50,23)
INSERT INTO Admission VALUES('R-000002',72,232,128,50,34)
INSERT INTO Admission VALUES('R-000002',72,232,129,50,23)
INSERT INTO Admission VALUES('R-000002',72,232,130,50,21)
GO
CREATE PROCEDURE GetAdmissionDetails
	@AdmissionNo VARCHAR(20) = NULL
AS
BEGIN
	select AdmissionNo,ClassID,SectionID,SubjectID,Max,Mark
	,dense_rank() over(partition BY SUM(Max) order by SUM(Mark) DESC) AS RANK
	,Round(sum(Mark) * 100/ sum(Max),1) as SubPer
	from Admission 
	where AdmissionNo=@AdmissionNo OR @AdmissionNo IS NULL
	group by AdmissionNo,ClassID,SectionID,SubjectID,Max,Mark
	ORDER BY AdmissionNo,RANK
END

Code

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace _155143_Crysta_Report_Percentage
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DisplayReport();
        }

        protected void DisplayReport()
        {
            CrystalReport crystalReport = new CrystalReport();
            AdmissionDataSet dsCustomers = GetData(txtAdmissionNo.Text.Trim());
            crystalReport.SetDataSource(dsCustomers);
            this.crystalReportViewer1.ReportSource = crystalReport;
            this.crystalReportViewer1.RefreshReport();
        }

        private AdmissionDataSet GetData(string admissionNo)
        {
            string constr = @"Data Source=.;Initial Catalog=Test;uid=sa;pwd=12345;";
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand("GetAdmissionDetails"))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@AdmissionNo", !string.IsNullOrEmpty(admissionNo) ? admissionNo : (object)DBNull.Value);
                        cmd.Connection = con;
                        sda.SelectCommand = cmd;
                        using (AdmissionDataSet dsCustomers = new AdmissionDataSet())
                        {
                            sda.Fill(dsCustomers, "DataTable1");
                            return dsCustomers;
                        }
                    }
                }
            }
        }
    }
}

Screenshots

Report Design

Output

Note: Based on your required data return it from stored procedure.

Hi smile,

Check this example.

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        DisplayReport();
    }

    protected void DisplayReport()
    {
        CrystalReport crystalReport = new CrystalReport();
        AdmissionDataSet dsCustomers = GetData(txtAdmissionNo.Text.Trim());
        crystalReport.SetDataSource(dsCustomers);
        this.crystalReportViewer1.SelectionFormula = "{DataTable1.SubjectID} =" + '"' + cmbSubject.SelectedItem.ToString() + '"' + " AND {DataTable1.ClassID} =" + '"' + cmbClass.SelectedItem.ToString() + '"';
        this.crystalReportViewer1.ReportSource = crystalReport;
        this.crystalReportViewer1.RefreshReport();
    }

    private AdmissionDataSet GetData(string admissionNo)
    {
        string constr = @"Data Source=.;Initial Catalog=Test;uid=sa;pwd=123;";
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand(@"select AdmissionNo,ClassID,SectionID,SubjectID,Max,Mark
                                                    ,dense_rank() over(partition BY SUM(Max) order by SUM(Mark) DESC) AS RANK
                                                    ,Round(sum(Mark) * 100/ sum(Max),1) as SubPer
                                                    from Admission 
                                                    where AdmissionNo=@AdmissionNo OR @AdmissionNo IS NULL
                                                    group by AdmissionNo,ClassID,SectionID,SubjectID,Max,Mark
                                                    ORDER BY AdmissionNo,RANK"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("@AdmissionNo", !string.IsNullOrEmpty(admissionNo) ? admissionNo : (object)DBNull.Value);
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (AdmissionDataSet dsCustomers = new AdmissionDataSet())
                    {
                        sda.Fill(dsCustomers, "DataTable1");
                        return dsCustomers;
                    }
                }
            }
        }
    }
}

Screenshot