Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parameter passing in auto report exporting

Status
Not open for further replies.

binsnam

Programmer
Feb 21, 2002
2
IN
I have a report that has to run at 12:00pm everyday and this report has to be exported in to an RTF file .The problem i face is that i have a parameter which i have to pass to the report,which has to be passed .But am not able to pass teh parameter and a prompt for that parameter props up.My code looks this way:
*******************************************************
Dim crystalApplication As crpeauto.Application
Dim objcrystalReport As crpeauto.Report
Dim crystalExportOptions As crpeauto.ExportOptions
Set objcrystalReport = crystalApplication.OpenReport _
(sRepPath & "\reports\autoauthbconfob.rpt")
Set crystalExportOptions = objcrystalReport.ExportOptions
crystalExportOptions.DestinationType = crEDTDiskFile
crystalExportOptions.DiskFileName = App.Path & "\Daily_authbConfob.rtf"
crystalExportOptions.FormatType = crEFTRichText
crystalExportOptions.UseReportNumberFormat = True
crystalExportOptions.ParameterFields(0) = "Coverper;" + 80 + ";TRUE"
Call crystalExportOptions.Export(False)
********************************************************
Can any one please help me out with this passing of parameters or suggest another better way,as no user data inputting should be needed
 
See faq 149-1479 for automatically scheduling reports, with or without parameters. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top