It seems as if yours is a matter of passing parameters to Crystal Report.
If this is the case, then look at what Babu, iamgautham and dinesh123 wrote:
from:
http://www.codeguru.com/forum/showth...ameter+crystal
There is a formula editor in the Crystal report where u can build the formula.
U can pass the formula from the code to Crystal report SelectionFormula parameter.
Eg:
CrystalReport1.SelectionFormula =" {dept.EMPLOYEE ID} = {employee.EMPLOYEE ID}"
U can get more help from the Cystal report help.
from:
http://www.codeguru.com/forum/showth...ameter+crystal
using automation server(cpeaut32.dll)
after creating application, report objects etc..

Private mobjcrpParam As CRPEAuto.ParameterFieldDefinition
Private mobjcrpParams As CRPEAuto.ParameterFieldDefinitions

Set mobjcrpParams = mobjcrpRep.ParameterFields
'' where mobjcrpRep is the report object
mobjcrpRep.ParameterPromptingEnabled = False
'' to prompt the parameter window or not
Set mobjcrpParam = mobjcrpParams.Item(1)

Dim paramValue As String
paramValue ="HELLO"
mobjcrpParam.SetCurrentValue paramValue
from:
http://www.codeguru.com/forum/showth...0&pagenumber=1
Re: Crystal Report
hi,
That formulas(0) value is incorrect.
First, you have to create formula in crystal report design time.
assume "myVar" is your formula variable
Then you pass the value to that variable like
CrptHistory.Formulas(0) = "myVar = 'Hello'"

yours,
Babu

'------------------------------------------------

Re: Many Problems in Crystal Reports
hi,
for example you want to print name = 'Raj'
' you should enter the single quote for string data type
cr.SelectionFormula = "{Employee.Name} = 'Raj'"
'you no need to enter single quote for numeric data type.
cr.SelectionFormula = "{Employee.RecNo} = 10001"

do your level best.
Babu