cognos Impromptu WIth VB by giving them prompts value

[JatinKhurana]

Hello,

I have read a thread that was about running the Impromptu with VB script. That really helped me but I want to open a report by giving them Prompt values using VB script.

 

[drlex]

So, what are you having problems with and what's your code so far?
CognosScript is very similar to VB script, so you should be OK, as Impromptu is an addressable application, and the prompts should be passed as strings, using a pipe as a delimiter

Passing year (2013) and month (3) to a report using CognosScript, a code fragment:

   Dim objImpApp As Object
   Dim objImpRep As Object
   '
   Set objImpApp = CreateObject("CognosImpromptu.Application")
   objImpApp.Visible 1
   objImpApp.OpenCatalog "E:\catalogues\Acme.cat","Creator",,,,1
   Set objImpRep = objImpapp.OpenReport("E:\Reports\AcmeSales.imr","2013|3")

soi là, soi carré