OraFAQ Forum: Reports & Discoverer » Dynamically Chaging Labels in Report 6i

Home » Developer & Programmer » Reports & Discoverer » Dynamically Chaging Labels in Report 6i

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

Dynamically Chaging Labels in Report 6i [message #215146]

Fri, 19 January 2007 08:12

kumar_dnvb
Messages: 13
Registered: January 2007

Junior Member

Hi Friends,

i have requirement in report6i , where need to change the label for the column depending on the parameter values.

could anybody provide suggestions on this.

Thanks in advance.

Kumar dnvb

Report message to a moderator

Re: Dynamically Chaging Labels in Report 6i [message #215198 is a reply to message #215146]

Fri, 19 January 2007 12:01

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

Senior Member
Account Moderator

One solution might be this: create a table with all possible combinations of paramter values and column labels. Write a query which would select labels from this table, depending on parameter value. Display those fields in report.

Simpler way, which would avoid a table, would be a query which uses a DECODE (or CASE) statement; doing so, you'd have to hard-code all possible combinations and, when something changes, you'd have to change the report (which means that the first option is more flexible).

Report message to a moderator

: Dynamically Chaging Labels in Report 6i [message #215253 is a reply to message #215146]

Sat, 20 January 2007 03:24

tanwanichandan
Messages: 8
Registered: January 2007
Location: Rajkot

Junior Member

ya ,u can change ur label run time
it's very simple thing

first wirte &<"name"> in ur text box

then , just create one formula column and write ur conditions that is applied to ur lable .

very simple which is dynamically change when u run report

bye
fun oracle
chandan

Report message to a moderator

Re: Dynamically Chaging Labels in Report 6i [message #215254 is a reply to message #215146]

Sat, 20 January 2007 03:25

tanwanichandan
Messages: 8
Registered: January 2007
Location: Rajkot

Junior Member

hey "name" is ur formula column name
so be careful

Report message to a moderator

Previous Topic:	how to print txt file using orarrp.exe
Next Topic:	urgent help on reports 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 00:44:55 CST 2024