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
*******************************************************
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