Home » Developer & Programmer » Reports & Discoverer » How do I make new fields on oracle reports template? (Oracle reports 11g, Windows 7, Oracle Weblogic 11g)
How do I make new fields on oracle reports template? [message #645849] Tue, 15 December 2015 09:21
lakemichigan2
Messages: 6
Registered: October 2015
Junior Member
Hello,

I'm trying to get the schema name, instance name, and record count per page on my report.
I figured out how to get the schema and instance name on individual reports using a placeholder column and the before report trigger:
function BeforeReport return boolean is
begin
  
	select sys_context('userenv', 'current_schema')
	into :cp_schema_name from dual;

	select INSTANCE_NAME
	into :cp_instance_name from v$instance;
  return (TRUE);
end;


Now I have schema and instance name at the bottom of every page of the report.

I can't figure out how to do this same thing through a oracle report template.

[Updated on: Tue, 15 December 2015 10:09]

Report message to a moderator

Previous Topic: Reports are running slow
Next Topic: how to hide or encrypt job id in url while calling report
Goto Forum:
  


Current Time: Thu Mar 28 13:31:42 CDT 2024