i have designed the crystal report. then i wrote the formulate for percentage which is working fine. I want to show percentage of each students R-01, R-02 and R-03 based on their obtaining marks.i put the percentage in the Group Footer # 1 along with obtaining and total marks. problem is that it is showing the same percentage.
i wrote the following formula (SUM({tblSetMarks.Mark})*100)/SUM({tblSetMarks.Max})
how to fix it?
Code :
private void btnTest_Click(object sender, EventArgs e)
{
try
{
ReportDocument report = new ReportDocument();
report.Load(@"E:\AB-Reports\AB\rptTests.rpt");
report.SetDataSource(sTable);
report.SetDatabaseLogon("sa", "2005");
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.DisplayToolbar = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}