Oracle reports parameter problem

[Quoted] I'm writing an "oracle reports builder" report which is called from a php web page that acts as a parameter form for the report. The report take 1 parameter, which is bookingnumber. Easy enough if the user can only enter 1 bookingnumber, but the parameter form that calls the report will allow the user to select a bunch of bookingnumbers (from 1 to appr 30).

How can I make the SQL behind the report work without having to write something like

AND BOOKINGNUMBER = INPUT_BNR1
OR BOOKINGNUMBER = INPUT_BNR2
etc?

I want the code to loop through the booking numbers that I send to the report, like an array? Is it possible?

An alternative could be to have the parameter form write all the bookingnumbers to a temporary oracle table, and the report will run on all booking numbers in that table - does that sound like a better solution?

Any input appreciated.

stein Received on Thu Apr 21 2005 - 13:50:29 CEST