I need to create a report that will pull data from our Oracle environment and that environment has 5 distinct servers (all with the same uaername/password) that represent 5 different branches of our business. I know that I can create 5 separate reports with 5 distinct data sources, but I was wondering if anybody had any ideas how I would accomplish that with just one report and one datasource. There is one easy data point that I can use to identify which server/oracle instance to hit.
Thanks,
wb
Thanks,
wb