Creating Macro to run Impromptu Report in Scheduler

[melsch]

Hi, everyone!
I'm new to this group so I'm hoping someone can help me.

I want to run an Impromptu report after hours using Scheduler.  I'm trying to create a Macro that will run this, however, I want the process to run without any intervention.  I'm able to get the macro written to bypass the catalog logon but have not had any luck getting it to bypass the Progress database logon.  Our Progress database does not use a logon name or password so normally I would just click Enter to bypass these.  How can I do the same with a macro?  Otherwise, the DB logon screen appears and waits for interaction.

I've seen some syntax suggestions such as that shown below but have not had any success with getting it to work.

'Open the correct catalog for the report
ImpApp.OpenCatalog "O:\SytePwr\Catalogs\fs-plus.cat","Creator",,,,1

Can anyone tell me if this is possible and how to write this into my macro?

Appreciate the help.

Melody

[wyconian]

It's been a while since I used Impromptu but I think the syntax is correct for opening a catalog.  Then you would need to open the report and possibly retrieve all rows.

You can also pass keystrokes via a macro so if your database logon is waiting for you to press enter that might be an idea. 

Take a look at the cognos script manual that comes with Impromptu, you should be able to find that in the documentation, tools section of the program files.