pawankumar.singh

Just Create a variable and place it in first column variable is $F{Field_Name}+1500 for integer/douible/long values.

can you please elaborate the issue. As it seems like you are not able to map the parameter of main report to subreports. If this is right then no worrry use belwo steps to achive your goal 1. when you are using the subreport element the it ask to create/select the report then just select the report from workspace 2. Click next then it ask for report connection then select same datasource as main report 3. Then if your subreport have parameter then listed over there after clicking next. over there you can check what different parameter you have and work accordingly. 4. If you have already created the subreport then you need to Right click on subreport element then go to show properties --> in right hand side you are able to see subreport section over there you can add or delete the parameter listed or used. Hope this Help! pawan

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

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.

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-%';

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 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! Regards Pawan

Thanks, Man, I resolved the issue by using report book. What I have done is: 1. Create the Abstract Book Report 2. Call the main report in which i need to put the dynamic value in Abstract book 3. Run the query a simple query like (select add_months(current_timestamp,-1) as date_time from dual;) that return a date (today date subtract 1 month) that vlaue stores in the field. 4. And then just pass that value in Subreport as static parameter in $P{Today} and get the result. Regards Pawan

Hi Folks, we want to pass the dynamic timestamp in jasper reports like from $P{today}-Month/Weeks/Days in our oracle queries in jasper studio. currently, we are using static parameters in our query but now we want to schedule the reports and need to pass dynamic dates in reports. can anyone assist us for the same. Help is appreciated and Thanks in Advance. Thanks Pawan

new java.lang.Integer($F{WEEKS}.equals("1 Week" )? 1 : 0 ) use this and set calculation to sum

Resolved Thanks

Make sure you are able to telnet oracle database and try to login to database using sqlplus Thanks Pawan

Hi Guys, I need help to count the strings value that it how many times occurs in fields. I tried with using variable but no luck formate of my vairable is $F{Weeks}=="1 Week" and calculation is set to count/sum but it always return 0 value to variable. Help is appreciated ! Thanks In advance :) Thanks Pawan

use this function at SQL level to_timestamp(to_char(to_date('01-01-1970 <Time what want to add>' , 'DD-MM-YYYY HH24:MI:SS')+open_date/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as per you requirment add you time in below format like below 5:30:00 in my it works hope it will help! Thanks Pawan

If you want report split then it is better option to use abstract book report over there you can easily split your reports. Thanks Pawan

Issue is resolved by using Report Book. Thanks Pawan