Changing report package

[cschnu]

I have an existing report in which i need to change the package it is linked to. The report needs to be migrated from Package A to Package B. Package B contains all the views that package A does as well as more views that are needed. Is there a quick way to find and replace package A name with package b name. So any all the report queries change [PackageA].[View].[Field] to [PackageB].View.Field]?

[uttam.mistry]

i used do it as follows without problem:

1. copy report to clipboard (from options)
2. open notepad or any good editor
3. past report in notepad
4. find and replace [PackageA].[View] with [PackageB].[View]
5. select all and copy
6. in report studio - options- open report from clipboard
7. change the report package from A to B (i think you know how to it)
8. save report ..

hope this helps

[Universe09]

You can also create a exact copy of the report then follow this steps:

1: Open File Menu
2: Click Report Package
3: Select the New Package

[cschnu]

You can also create a exact copy of the report then follow this steps:

1: Open File Menu
2: Click Report Package
3: Select the New Package

Right but it won't change all the references from the old package to the new package.

[Gollapudi]

Hi,

Just go to Cognos Connection where your report exist, and go to its properties there you can see the Package name based on which the report is working, you can change it, this is the actual way, the other ways has been given by our friendz in their previous mails.

Thanks,
Gollapudi.

[cschnu]

Hi,
Just go to Cognos Connection where your report exist, and go to its properties there you can see the Package name based on which the report is working, you can change it, this is the actual way, the other ways has been given by our friendz in their previous mails.

Thanks,
Gollapudi.

Yes but you will get the error below, if you don't change all references to the current package you are linked to. The notepad method is what I was looking for, thanks.

Code Select Expand

QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object 'PackageA.View.Field' that does not exist.