how to count gender in crystal report

Question

Dear Team how to count gender in crystal report we use this formula but not working If {TableName.Gender} = 'Male' Then cntmale := cntmale + 1; If {TableName.Gender} = 'Male' Then cntmale := cntmale + 1;

Amit Gupta · Answer

Hi Pratik Why don't you count the result at the time of binding the crystal report i.e. DataTable and if you want to show the counts in crystal report you can pass as a parameter in it. // assuming datatable is filled with rows var dt = new DataTable(); int cntMale = dt.Select(Gender = 'Male').Length; int cntFemale = dt.Select(Gender = 'Female').Length; Hope it helps.