pawankumar.singh Posted December 5, 2019 Share Posted December 5, 2019 Hi,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 query2.Using Lag function3.using lead function 4. Tried with variable as well.PLease help it is uregent.Problem is attched.help is appreciated and Thanks in advance!RegardsPawan Link to comment Share on other sites More sharing options...
pawankumar.singh Posted December 5, 2019 Author Share Posted December 5, 2019 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-%'; Link to comment Share on other sites More sharing options...
mundrameenaxi Posted December 5, 2019 Share Posted December 5, 2019 Did u try using "print repeated values" properties in jasperreports? Link to comment Share on other sites More sharing options...
pawankumar.singh Posted December 5, 2019 Author Share Posted December 5, 2019 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. Link to comment Share on other sites More sharing options...
Solution pawankumar.singh Posted December 5, 2019 Author Solution Share Posted December 5, 2019 Just Found the Solution for that is to use group band. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now