I am writing reports in CR 10 against a Oracle9i Enterprise Edition Release 9.2.0.6.0 db via a direct connection.
My db has multiple schemas and my reports never cross schemas. I will frequently make new copies of reports and point them to a different schema. Instead of modifying items in each report (such as headers, date ranges, etc) when I make these copies, I want to have one or more custom functions to programatically set these.
My thinking is that if I can evaluate the schema name and then pass it to the custom function, then I can program my function to return to proper results based on what schema the report is pointing to.
Can anyone help?
My db has multiple schemas and my reports never cross schemas. I will frequently make new copies of reports and point them to a different schema. Instead of modifying items in each report (such as headers, date ranges, etc) when I make these copies, I want to have one or more custom functions to programatically set these.
My thinking is that if I can evaluate the schema name and then pass it to the custom function, then I can program my function to return to proper results based on what schema the report is pointing to.
Can anyone help?