how to get specific data using crystal report

See more:

SQL-Server

SQL-Server-2008

, +

Hi SQL and Crystal Expert,

I am new to this crystal reporting and have some question on how to implement this...

In SQL I can create an statement where I can use a "WHERE command"

SQL
Table
Name Surname Age Sex Recordd
Noel Serrano 12 M 224????
Noel Serrano 15 M 224????
Noel Serrano 14 M 224????
and so on... assuming i have lots

In SQL if I wanted to show the record where age = 12 is easy
SELECT * from TABLE where age =12

then I will get the line
Noel Serrano 12 M London

but how to do this in crystal report? I want to use the filter "age = 12" then I will show the specific "recordd" on the report from the line where noel is age 12.

Thank very much..
Zir