I am working in Oracle 6i reports, I want to hide some report columns value at runtime. For example if dataentry operatior run a invoice report the value columns are print like '**********' otherwise it will print original value. The users are controlled in a seprate table. Using that table I want to do this. This tabel contain username,report_id and column name(which column i want to hide at runtime).
I don't want to write any code in column format trigers. It should be common for all columns. Plz post your comments.. Plzzz