How to write a formula for calculating the no of Rows in a column in Crystal Reports

Hi Pravin..

Its Working.Thanks For the Reply.

Hi Anju..

Just try this code..

DatabaseConnection.conn.Open();
cmd = new SqlCommand("Select count(*) FROM tblName where TType = 'VOID'",DatabaseConnection.conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ds.Receipt_No.dcUserColumn.DefaultValue = rdr[0].ToString();
}
rdr.Close();
SqlDataAdapter da = new SqlDataAdapter(sql,DatabaseConnection.conn);
da.Fill(ds, "Product");
MessageBox.Show (ds.Tables[1].Rows.Count.ToString());
DatabaseConnection.conn.Close();
CrystalReport1 rcp = new CrystalReport1();
rcp.SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rcp;
crystalReportViewer1.Refresh();


You can Refer this link
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx 

Hi Datta,
I'm able to calculate the total no of rows in TType column,but i need to calculate only the
VOID rows in TType column.

EX:The TType column looks like
     TTYpe
     1.Sale
     2.Sale
     3.Void
     4.Void
     5.Void
     6.Transfer
With Summary i can calculate total no of rows i.e=6
No of VOIDS: ?.(How to calculate,The Answer should be 3)