Home » Developer & Programmer » Reports & Discoverer » Dynamically Changing Labels in Discoverer
Dynamically Changing Labels in Discoverer [message #214940] Thu, 18 January 2007 12:36 Go to next message
kumar_dnvb
Messages: 13
Registered: January 2007
Junior Member
Hi All,

i have a requirement in discoverer , where in need to change the label based on parameters enter. could any one help me implementing this.


thanks in advance
kumar dnvb
Re: Dynamically Changing Labels in Discoverer [message #214942 is a reply to message #214940] Thu, 18 January 2007 12:55 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
What do you mean by label? Column heading? Workbook or worksheet name? Title?
Re: Dynamically Changing Labels in Discoverer [message #214945 is a reply to message #214942] Thu, 18 January 2007 13:01 Go to previous messageGo to next message
kumar_dnvb
Messages: 13
Registered: January 2007
Junior Member
Hi Friends,

i need to change the labels of the columns headings.

Thanks & Regards,
Kumar dnvb
Re: Dynamically Changing Labels in Discoverer [message #214948 is a reply to message #214945] Thu, 18 January 2007 13:03 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
As far as I know, this can't be done. Sorry.
Re: Dynamically Changing Labels in Discoverer [message #288349 is a reply to message #214940] Mon, 17 December 2007 02:57 Go to previous messageGo to next message
white_phoenix
Messages: 19
Registered: November 2007
Junior Member
I think this can be done, from my understanding you want to change the label based on parameter. I've done this for the header before.

First, you have to delete the default label (usually text). Add a formula column , the do pl/sql to change the label dynamically

example:

v_int_hdr varchar2(30);
begin
  IF :CNTRYCD IN ('MAL', 'IND', 'SG') THEN
  	v_int_hdr:= 'ASIA';
  ELSE
  	v_int_hdr := 'NON-ASIA';
  END IF;
  RETURN v_int_hdr;
  
  exception
  	when no_data_found then
  	RETURN null;


then add a field, change the source property to the formula column that you created

Good luck Wink

[Updated on: Mon, 17 December 2007 02:59]

Report message to a moderator

Re: Dynamically Changing Labels in Discoverer [message #288475 is a reply to message #288349] Mon, 17 December 2007 13:00 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't speak Discoverer so I'll rather believe Sabine. Your code, white_phoenix, looks like a Report Builder's code (and Discoverer <> Reports Builder). If I'm wrong, I sincerely apologize.

However, I'd like to know what's the purpose of the NO-DATA-FOUND exception handler? Which part of your code is likely to raise that exception? As far as I can tell, none (but would like to hear your explanation).
Re: Dynamically Changing Labels in Discoverer [message #288730 is a reply to message #288475] Tue, 18 December 2007 07:55 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Indeed, that code looks like reports. As far as I am aware, in Discover this can not be done.
[Edit: oops, posted that answer already, well, at least I'm pretty consistent in my answers Wink]

[Updated on: Tue, 18 December 2007 07:56]

Report message to a moderator

Previous Topic: i want to display message like "END OF THE REPORT" at the last page of the report.
Next Topic: Oracle report
Goto Forum:
  


Current Time: Sat Dec 03 12:11:14 CST 2016

Total time taken to generate the page: 0.05222 seconds