Author: Dwayne Hoffpauir, EDS Corporation
Beginning with v6, BusObj full client users can use the results of one data provider to pass an InList to a second data provider, using the “Select query results” operand. This is not possible in v5, but the attached utility provides an alternative.
[quote:dfc128ca38=“Author’s notes”]The utility is an Excel add-in. To install:
Save the file to your hard drive
In Excel go to Tools, Add-Ins
Browse to the file on your hard drive, and click OK
Select the add-in, and click OK
In your Business Objects report, create a prompt:
Pick your object (say, Serial Number)
Choose the In List operator
Choose Type a new prompt and use something like Enter Serial Number(s)
To use the utility:
Refresh the BusObj report, and the prompt will appear
Toggle over to Excel, and select the list (any range, contiguous or non-contiguous) of serial numbers
Press Ctrl-Shift-L (or Alt-F8 and run the macro) to format the list (semi-colon delimited) and place it on the clipboard
Toggle back to BusObj, paste the list in the prompt box, and the query is ready to run
[/quote]
Please note that the utility will limit the list to 1,000 values (the Oracle limit). If your database has a different limit, you can change the code accordingly.
Another benefit is that this utility will work for Web Intelligence documents as well.
Create BusObj InList.zip (8.0 KB)
Dwayne Hoffpauir (BOB member since 2002-09-19)