crystal reports for the query with where condition
hi, i know to develop crystal repors for the queries like
select* from customers by adding .rpt file and connection it to sqlserver 2005 and by drag and drop of required columns(this way we can retrieve total column data in the table)
but how to develop the crystal report for particular user
(select * from customers where username='ravi') for this only one row is the result, i want to develop a crystal report like this by giving the username as condition
so please help me on this