hi.. i m making a university project on a dental clinic

i have two tables one containing information abt the visits in a dental clinic(tbl_daily_opd) and the other containing the details of the patient(tbl_patient).. tbl_daily_opd contains only the id of the patient.. i m printing tbl_daily_opd in the report with the patient name n id...

i also want to count the number of males and females on a particular date... and how many patients recieved a just medication and now many tooths were extracted(the column 'treatment' in tbl_daily_opd contains this information)..

how do i do this? by passing two queries in CR or is there some option in the expert editor which can accept select queries?

i m using c# in vs2005.. crystal reports 10