| records grouping in the reports [message #129105] |
Fri, 22 July 2005 00:31 |
narayana2789
Messages: 5
Registered: June 2005
Location: hyderabad
|
Junior Member |
|
|
Hai
This is Narayana
My Problem IS:
Ihave a Table called as HTB001(
TRNSCTNNO VARCHAR2(20),
TRNSCTNORGN NUMBER(2) ,
ONHVAL NUMBER(10),
ONQVAL NUMBER(10));
DATA IS LIKE THIS
TRNSCTNNO TRNSCTNORGN ONHVAL ONQVAL
AT001 1 10 0
AT002 1 20 2
AT002 1 21 20
AT002 1 40 0
AT003 2 0 20
AT003 2 9 22
I WANT REPORT like
display the all records and
idont want see the repeated TRNSCTNNO ,TRNSCTNORGN VALUES
but iwant DESPLAY THE ONHVAL SHOULD BE DISPLAYED.
PLS
MAIL ME WITH SUGG.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
