Script for Report Run and email 1

[spicysudhi]

hi

I am looking for the script to run the reports (both Powerplay and Impromptu) on a scheduled basis and email it in a specific format (HTML, PDF, CSV...etc).

can anyone please give me the script.

thanks,

sudhi

 

[drlex]

Sudhi,
You can find sample scripts to run the reports and save them both in the sample folders installed with Impromptu and PowerPlay and in the Macro Help file . Further can be found on the Cognos KB.

For emailing, the script will be determined by your email appliaction - search this forum for 'email'.

For scheduling, you can either use a batch file to call the macro application and file or use the cognos scheduler.

HTH,
lex
---
Here's a few examples from macros I have:
(Objects and variables defined earlier)

Set objImpRep = objImpApp.OpenReport_("k:\reports\lastinvoice.imr&quot
Set objImpRep = objImpApp.ActiveDocument
objImpRep.RetrieveAll
objImpRep.ExportExcelWithFormat strfiledest
Set objHTML = objImpRep.PublishHTML
objHTML.TOC = 0
objHTML.Publish "k:\html\LastInvoices","LastInvoices"
objImpRep.CloseReport
objImpApp.Quit
...
Set objPPRep = CreateObject("CognosPowerPlay.Report&quot
objPPRep.Open "K:\PPreports\dailysales.PPR"
objPPRep.Publish "K:\html\Sales" 'HTML format
objPPRep.SaveAs "K:\xl\dailysales",4 'Excel
objPPRep.Close
...
Set objOutlookEmail = CreateObject("CDONTS.NewMail&quot
'CDO mail setttings for SMTP
with objOutlookEmail
.From = "Cognos@lexco.com"
.To = strTo
.cc = "administrator@lexco.com"
.Subject = strSubject
.Body = strprompt
.MailFormat = 0
.AttachFile strfile
.Send
End with
set objOutlookEmail = nothing

 

[spicysudhi]

thanks very much.

regards,
sudhi