Home » Developer & Programmer » Reports & Discoverer » pass new value in run time (10 g)
pass new value in run time [message #400087] Sat, 25 April 2009 21:58 Go to next message
hmadacompaq
Messages: 11
Registered: April 2009
Junior Member
hi every body

i have table CONTAIN 3 columns
id , name ,gender
and i set in gender 2 values 0 and 1

i want in report in run time when gender=0 then
gender in run time=male
and if gender =1 then gender =female in run time

i cannot do this if any one know how can i do this please tell me

sorry for bad english
Re: pass new value in run time [message #400111 is a reply to message #400087] Sun, 26 April 2009 04:44 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DECODE or CASE seem to be the most obvious solutions.
Re: pass new value in run time [message #400156 is a reply to message #400111] Sun, 26 April 2009 14:03 Go to previous messageGo to next message
hmadacompaq
Messages: 11
Registered: April 2009
Junior Member
Littlefoot wrote on Sun, 26 April 2009 04:44
DECODE or CASE seem to be the most obvious solutions.

hhhhhhhhhh

i'm sorry really i'm sorry i forgen my topic


[Updated on: Sun, 26 April 2009 14:04]

Report message to a moderator

Re: pass new value in run time [message #400165 is a reply to message #400087] Sun, 26 April 2009 20:40 Go to previous messageGo to next message
hmadacompaq
Messages: 11
Registered: April 2009
Junior Member
i don't know where i can write the code
Re: pass new value in run time [message #400205 is a reply to message #400165] Mon, 27 April 2009 02:47 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd try with SELECT statement, but you might also do that in a FORMULA column, for example.

Do you know how to write that query and get the result in SQL*Plus? If so, just copy it into Reports Builder. (Do you know how to create a report, then?)
Re: pass new value in run time [message #400274 is a reply to message #400205] Mon, 27 April 2009 07:16 Go to previous message
hmadacompaq
Messages: 11
Registered: April 2009
Junior Member
Littlefoot wrote on Mon, 27 April 2009 02:47
I'd try with SELECT statement, but you might also do that in a FORMULA column, for example.

Do you know how to write that query and get the result in SQL*Plus? If so, just copy it into Reports Builder. (Do you know how to create a report, then?)


ok i understand now
Previous Topic: how can i solve this problem
Next Topic: Report repeating frame repetitions should be controlled
Goto Forum:
  


Current Time: Fri Apr 19 15:01:12 CDT 2024