i have write one query in MS sql express 2005

 query is : "SELECT COUNT(a_name) FROM License WHERE animaltype = '" + Request.QueryString["type"] + "' AND feetype = 'S' GROUP BY MONTH(pay_date)"

 

 it return more then 1 value now my problem is i want to add value in my parameter.

 

in crystal report i have created 4 group

[1] animaltype

[2] pay_date

[3] gender

[4] feetype(M,S,SV,R)

 

 

now i want count number of record in  feetype (M,S) show  second group footer (pay_date).

 

so tell me how can i pass my return value from query one by one in

{? feetype} parameter.

 

if any one want more information regard query please mail me on my gmail id:

 

please help me in this report design.

 

i hope u will reply me

thank you

Saroop