OraFAQ Forum: Reports & Discoverer » display report name in report

Home » Developer & Programmer » Reports & Discoverer » display report name in report (reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

display report name in report [message #438769]

Tue, 12 January 2010 03:05

azalar
Messages: 3
Registered: September 2009
Location: Slovenia

Junior Member

I would like to make a report template, that would display the report name and a filename of the stored report in the report header. Is there any function to retrieve those values so that I do not need to manualy sprecify those two values for every report?

Report message to a moderator

Re: display report name in report [message #438782 is a reply to message #438769]

Tue, 12 January 2010 03:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is easy to find out report name - you'd use SRW built-in package. For example, create a formula column whose code looks like this:

function CF_report_nameFormula return Char is
  retval varchar2(30);
begin
  SRW.GET_REPORT_NAME(retval);
  return (retval);
end;

Now display it on report layout; the simplest way is to use ampersand: &cf_report_name. Or, create a field and make its source previously created formula column.

As of file name, well, I wouldn't know how to do that. (By the way, don't you use the same name for both report and file?)

Report message to a moderator

Re: display report name in report [message #438906 is a reply to message #438782]

Wed, 13 January 2010 00:01

azalar
Messages: 3
Registered: September 2009
Location: Slovenia

Junior Member

thank you

Report message to a moderator

Previous Topic:	Failed to locate the browser
Next Topic:	convert reports 10g into excel file in 2-tier

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 23:52:06 CST 2025