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
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.