PDA

Click to See Complete Forum and Search --> : how to set a parameter?


noielen
Jun 23rd, 2006, 03:17 AM
any idea on how to set a parameter in vb to CRXI... ex. if i'm going to display records with status = 1?StrQry = " " '?

noielen
Jun 23rd, 2006, 07:16 PM
help here please... urgent

ROAMER
Jun 30th, 2006, 04:10 PM
Try this code i hope it will help you, for passing parameters to crystal report x.

Set crxApp = New CRAXDRT.Application
Set crxRpt = crxApp.OpenReport(App.Path & "\Reports\DataReport1.rpt")

crxRpt.RecordSelectionFormula = "{demo04.CODE} = '" & CODE & "' AND
demo38.DUMMY} = TRUE; "
'To View the report
CR.ReportSource = crxRpt
CR.ViewReport