Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Report 2.5 - report name?

Re: Q: Report 2.5 - report name?

From: Shujda <shujda_at_prodigy.net>
Date: 1998/12/29
Message-ID: <36899A2D.47E0F962@prodigy.net>#1/1

Oracle Forms has get_application_property built in that may return form name. I don't know about Oracle Reports. Why don't you see in online help. If the similar function is available, it must be there.

Ng TC wrote:

> Hi,
> I am using Developer 2000 Reports 2.5.
> I have a report 'RPFA9016'. This name is shown at the highest level in the
> report designer.
>
> I want to do a select statement in the beforereport trigger:
> BEGIN
> SELECT UPPER(User_Concurrent_Program_Name), Concurrent_Program_Name
> INTO :P_RPT_NAME, :P_RPT_ID
> FROM FND_Concurrent_Programs
> WHERE Concurrent_Program_Name = 'RPFA9016';
> EXCEPTION WHEN NO_DATA_FOUND THEN
> :P_RPT_NAME := '*Report Name not found*';
> END ;
>
> But I do not want to hard code 'RPFA9016' in the above statement. Is there
> any global name/reserve word that I can replace the hard code with??
>
> Thanks.
>
> Regards,
> T C
> (Please also reply to mailto:tcng_at_yas.com.sg )
Received on Tue Dec 29 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US