440-Impromptu: Multiple errors have occured with Impromptu

[w860098]

I am trying to run a new report using a macro (based upon one that is in regular use) and I get the above message when I run it.

The offending instruction would appear to be :-

Set impReport= impApp.OpenReport( "e:\CognosReports\Live\Reports Imp\W004i - Market Goodwill Spending Analysis.imr" , prompt)

The report name would appear to be correct (I get a different error if I 'corrupt' it).

The prompt parameter has been set up as following :-

prompt="2004"+"|"+"Feb"+"|"+"PC"+"|"+" "

These values have been used successfully online.

Has anyone else had such an error occur, or can somebody possibly suggest any additional diagnostics that I can build into the macro (I have already built in log messages to confirm that the catalog has been opened, etc.)

 

[w860098]

I have now been advised that either or both of the last two values for the prompt can be null entries when run online.

 

[GilMerc]

Hi,

I suggest you to put visible application to show each instruction when it's execute and show what's the result. Sometimes we see exactly what's append.

Assure you that object was declare. Cognos Scrip help said 440-Object Error. It's very large possibility.
If you don't put parameter the report will be run correctly?
Your parameters are in the good rank?


Watch your last parameter, " " mean a blank value and not null. If you like to pass null value you must put "".

Gilles.

 

[DoubleD]

If the values you are receiving are nullable you will have to account for that in your macro. If you type (or attach) the macro here, we can probably help you out.

Pain is stress leaving the body.

DoubleD

 

[w860098]

This is the second reference I have seen to visual application.
How do I include code in the macro to request this (or do I have to achieve it by other means) ?

 

[GilMerc]

Hi,

Just this instruction.

Set ImpApp = CreateObject("CognosImpromptu.Application")
ImpApp.Visible 1

Gilles.