Remove dublicate value



In our report rows were repeated. can any tell how to remove the row from report using particular field as we tried different thing like:

1. Using Distinct in query

2.Using Lag function

3.using lead function 

4. Tried with variable as well.

PLease help it is uregent.

Problem is attched.

help is appreciated and Thanks in advance!



pawankumar.singh's picture
Joined: Sep 19 2018 - 10:39pm
Last seen: 1 month 2 weeks ago

Query what we uses:

select  d.ref_num,d.sym as Type,d.analyst,d.descr,d.last_mod_date,a.severity,c.location_uuid,a.type as Request,b.last_name as Assignee,a.status,
  3  To_timestamp(to_char(to_date('01-01-1970 05:30:00' , 'DD-MM-YYYY HH24:MI:SS')+a.open_date/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as Open_Date
  4  from
  5  call_req a JOIN
  6  (select a.ref_num,e.sym as category,
  7  To_timestamp(to_char(to_date('01-01-1970 05:30:00' , 'DD-MM-YYYY HH24:MI:SS')+a.last_mod_dt/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as last_mod_date,
  8  d.sym,c.last_name as Analyst,to_char(b.description) as Descr
  9  from call_req a,act_log b,ca_contact c,act_type d,prob_ctg e
 10  where a.persid=b.call_req_id  and b.type=d.code and  b.analyst=c.contact_uuid and a.category=e.persid  and b.time_stamp=(select max( DISTINCT act_log.time_stamp) from act_log where act_log.call_req_id=a.persid) and a.status not like 'CL') d
 11  ON a.ref_num=d.ref_num
 12  JOIN ca_contact b ON a.assignee=b.contact_uuid
 13  JOIN ca_contact c ON a.customer=c.contact_uuid
 14  where d.category LIKE  'Finacle.%' OR d.category LIKE  'FO-%';

pawankumar.singh - 1 month 3 weeks ago

Did u try using "print repeated values" properties in jasperreports?

mundrameenaxi - 1 month 3 weeks ago

Yes tried but as you saw in the image what i have uploaded over ther one column for which value is not repeated. What i want is just remove the whole line if first column value is repeated.

pawankumar.singh - 1 month 3 weeks ago

1 Answer:


Just Found the Solution for that  is to use group band.

pawankumar.singh's picture
Joined: Sep 19 2018 - 10:39pm
Last seen: 1 month 2 weeks ago