Report Sever name when using multiple servers
We are migrating from forms/reports 6i to 10g. It seems in 10g we have to now hard code the reports server name, either in the property pallet of the report in the calling form or by using 'SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,report_server_name);' We have 3 servers, development, acceptance and production. We do not want to have to modify the code for each server, etc (or not at all if we do not have to). I guess we could create a database table and populate it with the server name and then select from that, or maybe define a variable in the defualt.env file? Or is there a configuration file that it can be defined in?
0