|
|
|
|
|
|
|
|
| Re: Dynamically Changing Labels in Discoverer [message #288349 is a reply to message #214940] |
Mon, 17 December 2007 02:57   |
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 
[Updated on: Mon, 17 December 2007 02:59] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
