Macro Impromptu reports catalog path

[kejalg]

Hi,

Does anybody know how to get the catalog path of the report and change it using macro?

Thanks
Kejalg

 

[griffindm]

kejalg,

The .CatalogName property will return the file name. The easiest way to change the catalog in a report is to open it with another compatible catalog already open and save it. This can be done easily via a macro.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[christenhusz]

kejalg,

This will return the catalogname in a msgbox.

Sub Main()
Dim objImpApp As Object
Dim strCatName As String
Set objImpApp = getObject("CognosImpromptu.Application&quot
strCatName = objImpApp.CatalogName
If strCatName <> &quot;&quot; Then
Msgbox &quot;The currently open catalog is:&quot; & strCatName
Else
Msgbox &quot;No catalog is currently open.&quot;
End If
Set objImpApp = Nothing
End Sub

hope it's helpfull

greetz,

Martijn