Print Page | Close Window

How can add multiple values in one parameter field

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3476
Printed Date: 19 May 2024 at 1:47am


Topic: How can add multiple values in one parameter field
Posted By: sarooptrivedi
Subject: How can add multiple values in one parameter field
Date Posted: 18 Jun 2008 at 4:24pm
 hello sir,
 
 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:
mailto:saroop.trivedi@gmail.com - saroop.trivedi@gmail.com
 
please help me in this report design.
 
i hope u will reply me
thank you
Saroop


-------------
reply me on my mail id:saroop.trivedi@gmail.com.
crystal report help.


Print Page | Close Window