Using Table Selection in Parameter

[GMAN33]

CR XI Developer
Oracle 9
Oracle Server connection

Hi All

Not sure if this is possible, but here it goes

I work in a clinical environment using an Oracle Database to collect data for clinical drug trials. Each time we create a new study within the DB, it is assigned a three alpha-numeric identification code (A01, B01, etc) so that it can be easily identified throughout the tables. For each study created, a new table is also created called A01_DOCUMENTS, B01_DOCUMENTS, etc, that contains the patient pages received into the DB and these tables have the exact same structure (fields) but only contain the study specific data and not every other study.

I have several reports that contain one of these above mentioned tables so that the report is study specific. Well when I need to create the same report for another study, what I have been doing is changing the source from one table to the other, and then mapping the fields.

Is there a way that I could do this in a formula and make the report global and use it within a parameter?

I hope this was explained ok

Thanks guys