Change Impromptu Catalog

[oharab]

My predecessor built quite a few Impromptu reports using several Catalogs scattered across the file system. They all point to the same source (not sure why there are lots of copies) which has changed, along with the catalogs, rendering the old ones useless.
Rather than copy the new catalog over the olds, is there a way of changing the catalog the imr is looking at?
I don't have access to any of the admin tools or anything, just Impromtu.

Any help you can give is appreciated.

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[drlex]

Ben,
If you have access to the macro editor, I tend to use a quick macro to force the report to open against a chosen catalog, and then spend a few minutes amending the source fields to remove the errors.
The macro application is edmacro32.exe and is in the bin folder of your install. Usual PC path is C:\Program Files\Cognos\cer4\bin.
Here's a script:

Sub Main()
   Dim objImpApp As object
   Dim objImpRep As Object
   Set objImpApp = CreateObject("CognosImpromptu.Application")
   objImpApp.Visible 1
   objImpApp.OpenCatalog "\\SANdrive\cognos\catalogues\newcatalog.cat","Creator",,,,1
    Set objImpRep = objImpApp.OpenReport ("\\SANdrive\cognos\reports\Old report.imr")
   objImpRep.CloseReport
   objImpApp.Quit
   Set objImpRep = Nothing
   Set objImpApp = Nothing
End Sub

Change the catalog and report path to suit
Step through with F8
When the report opens, you can use the Escape key to exit and then amend the report as required.

lex

soi la, soi carré