BusinessObjects Board

Scanning all Reports

Hello,

I have a Problem and can’t find a good solution. :hb:
At first, we have BO XI R3 and our Reports are mixed (DeskI and WebI)

In our Database is a field ‘region’ with following values:
1, 2, 3 or 4 (1=North, 2=East, 3=South and 4=West)
and we have some reports that use this field in the Select or Where clause.
Now my company made a redeployment. Now the field ‘region’ can have the values 1, 2, …, 8 (1=North, 2=Northeast, 3=East, …)
Actually the reports show the false regions.

Unfortunately we have several hundreds of reports.
How can I easily find the reports containing the field ‘region’?
Something like this?
read all reports → read each SQL from the reports → if there is the field ‘region’ in → save to txt-file or show the name of the report


hartm11 (BOB member since 2012-10-18)

Welcome to B:bob:B!

Try using this utility for DeskI reports:
DeskI Documents Inspector

For WebI reports, try using this:
WID Scanner


Marek Chladny :slovakia: (BOB member since 2003-11-27)