BO R3.1 and R2 reports listing

system · February 23, 2009, 10:23am

Hi all,

i have a question to ask.
i’m planning to move the contents (webi, deski reports) from a BO R2 server to a BO R3.1 server. Before migrating those reports, i have to check both side existing reports and have a list of it.

is there any way to list out the BO server’s reports?

Thanks for advise!

BOXI0 (BOB member since 2009-02-17)

system · February 23, 2009, 10:40am

you can use the excel provided here

However you will need to change the reference library to point to XI 3.x when extracting the reports from that environment.

HRS

Sushir Patel (BOB member since 2006-04-19)

system · February 24, 2009, 2:47am

Thanks for your reply!

Between, my client server don’t have Microsoft Excel installed…
is there any way else to do it?

Thanks

BOXI0 (BOB member since 2009-02-17)

system · February 24, 2009, 7:51am

Check this post
Change the SQL in the VBA code to this

Select  SI_NAME From CI_INFOOBJECTS Where SI_PROGID='Webi' And SI_INSTANCE=0

For full client DeskI reports replace webI with FullClient

You can also use query builder(from admin launchpad for XIr2 and start-programs-BOBJ-query builder for XI 3.1) and try above query

.

haider (BOB member since 2005-07-18)