How to run a Crystal Report with parameters

[ije]

Hello,

Does anyone has some example code they would like to share showing how to run a Crystal report off the users PC, passing to it a few parameters contained in the script?

Even nicer, would be an example showing how to save the results to file automatically.

Thanks in advance,

ije
(ps- i am a newbie to VBS - please be gentle if this is a straightforward task!)

 

[jonscott8]

SET oCRApp = Createobject("crystal.crpe.application&quot
SET oReport = oCRApp.OpenReport("C:\MyPath\MyReport.rpt&quot
oReport.ParameterFields(0) = 2 'set 1st parm value to 2
oReport.ExportOptions.FormatType = 14 'to Word doc
oReport.ExportOptions.DiskFileName = "C:\MyPath\MyDoc.doc"
oReport.ExportOptions.DestinationType = 1
oRep.Export False 'True to see dialog
SET oReport = Nothing
SET oCRApp = Nothing

This is off the top of my head so it may not be 100% syntactically correct, but it should get you in the ballpark. Jon Hawkins