Skip to Content
0
Former Member
Mar 01, 2010 at 07:16 PM

Allow users to change database connection at runtime

14 Views

Folks,

CR 12.2.0.290

BOE 12.1.0

I develop CR on desktop and then save to the BOE repository. Users need the ability to point the report to a different Oracle schema. Tables and elements are the same, just the data is stored via streams so that each location has its own reporting schema. So one (16 total) report needs to run against multiple schemas based on which origin the user is trying to report against; one at a time. Other than having a set of reports for each site, how can I allow the users to select the schema to run against at runtime?

Thanx

Mike