datareport creation doubt

[vjeshemv2000]

hai all,
i have created a vb project and stored data into a databse named faculty. now i want to extract the details from the database. the fields included in the table are slno,faculty,subject,batch,ctr1...ctr6,overall per...
my requirement is when i selected any one of the faculty then the report will shows like in fig2(datareport 2.jpg which is attched.). the currect report design is shown in fig1(datareport1.jpg which is also attached)

it is possible if yes pls reply me

thank you

[elaek]

You can use :
Reportobjectname.SelectionFormula="{TableName.FieldName}=Criterium".

If the Crystal report object name is: Report1
If your tanlename=Table1
If your field name for selection =Faculty
If Creterium is "Faculty=Mascara"

So you have to write:
Report1.SelectionFormula="{Table1.Faculty}='Mascara'"